Ticket #244 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

Error message in /collection/{id}

Reported by: Michiel.Schok Owned by: forgacs
Priority: major Milestone: MediaMosa 2.1
Component: Core Version:
Keywords: Cc:
MoSCoW: Must Have Estimated time after impact analysis:
Related to project: none Tested: yes
Accepted: yes Estimated Hours:

Description

When requesting details about a collection, we observe strange results:

<?xml version="1.0" encoding="UTF-8"?>
<response>
  <header>
    <item_count>0</item_count>
    <item_count_total>0</item_count_total>
    <item_offset>0</item_offset>
    <request_matched_method>GET</request_matched_method>
    <request_matched_uri>/collection/$coll_id</request_matched_uri>
    <request_process_time>0.0552</request_process_time>
    <request_result>error</request_result>
    <request_result_description>PDOException caught; SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*
FROM 
 
WHERE  (coll_id IN  ('20slBhinilQCNYGXmaRgq2KS'))' at line 1,
trace; #0 /var/opt/www/vpcore/htdocs/includes/database/database.inc(1735): PDOStatement-&gt;execute(Array)
#1 /var/opt/www/vpcore/htdocs/includes/database/database.inc(568): DatabaseStatementBase-&gt;execute(Array, Array)
#2 /var/opt/www/vpcore/htdocs/includes/database/select.inc(1089): DatabaseConnection-&gt;query('SELECT .*?FROM ...', Array, Array)
#3 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/core/asset/collection/mediamosa_asset_collection.inc(158): SelectQuery-&gt;execute()
#4 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/modules/collection/mediamosa_collection.rest.inc(446): mediamosa_asset_collection-&gt;get_by_ids(Array)
#5 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest_call.inc(269): mediamosa_rest_call_collection_get-&gt;do_call()
#6 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest.inc(304): mediamosa_rest_call-&gt;process_call()
#7 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/response/mediamosa_response.inc(125): mediamosa_rest-&gt;process_call(Array)
#8 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/mediamosa.module(94): mediamosa_response-&gt;process_rest()
#9 [internal function]: mediamosa_init()
#10 /var/opt/www/vpcore/htdocs/includes/module.inc(413): call_user_func_array('mediamosa_init', Array)
#11 /var/opt/www/vpcore/htdocs/includes/common.inc(3769): module_invoke_all('init')
#12 /var/opt/www/vpcore/htdocs/includes/bootstrap.inc(1551): _drupal_bootstrap_full()
#13 /var/opt/www/vpcore/htdocs/includes/bootstrap.inc(1417): _drupal_bootstrap(8)
#14 /var/opt/www/vpcore/htdocs/index.php(21): drupal_bootstrap(8)
#15 {main},
Query string; SELECT .*
FROM 
{} 
WHERE  (coll_id IN  (:db_condition_placeholder_0)) ,
Args; Array
(
    [:db_condition_placeholder_0] =&gt; 20slBhinilQCNYGXmaRgq2KS
)
</request_result_description>
    <request_result_id>500</request_result_id>
    <request_uri>[GET] /collection/20slBhinilQCNYGXmaRgq2KS</request_uri>
    <version>2.1.0.236:07ebc5929cac</version>
    <errors>
      <error>Warning: Illegal offset type in isset or empty, SelectQuery-&gt;addJoin()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1191.</error>
      <error>Warning: Illegal offset type, SelectQuery-&gt;addJoin()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1196.</error>
      <error>Warning: Missing argument 1 for SelectQuery::fields(), called in /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/core/asset/collection/mediamosa_asset_collection.inc on line 156 and defined, SelectQuery-&gt;fields()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1125.</error>
      <error>Notice: Undefined variable: table_alias, SelectQuery-&gt;fields()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1135.</error>
      <error>Notice: Undefined index:  arguments, SelectQuery-&gt;getArguments()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1019.</error>
      <error>Notice: Undefined index:  table, SelectQuery-&gt;getArguments()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1023.</error>
      <error>Notice: Undefined index:  table, SelectQuery-&gt;__toString()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1313.</error>
      <error>Notice: Undefined index:  table, SelectQuery-&gt;__toString()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1317.</error>
      <error>Notice: Undefined index:  alias, SelectQuery-&gt;__toString()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1322.</error>
    </errors>
  </header>
  <items/>
</response>

Change History

Changed 3 years ago by forgacs

  • owner set to forgacs
  • status changed from new to assigned

Changed 3 years ago by robert

  • status changed from assigned to closed
  • resolution set to ready_for_review

Changed 3 years ago by robert

  • status changed from closed to reopened
  • resolution ready_for_review deleted

Changed 3 years ago by robert

  • status changed from reopened to closed
  • resolution set to fixed

Changed 3 years ago by Frans

  • tested changed from no to yes
  • accepted changed from no to yes

No strange results anymore

Note: See TracTickets for help on using tickets.