Ticket #244 (closed defect: fixed)
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->execute(Array)
#1 /var/opt/www/vpcore/htdocs/includes/database/database.inc(568): DatabaseStatementBase->execute(Array, Array)
#2 /var/opt/www/vpcore/htdocs/includes/database/select.inc(1089): DatabaseConnection->query('SELECT .*?FROM ...', Array, Array)
#3 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/core/asset/collection/mediamosa_asset_collection.inc(158): SelectQuery->execute()
#4 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/modules/collection/mediamosa_collection.rest.inc(446): mediamosa_asset_collection->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->do_call()
#6 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest.inc(304): mediamosa_rest_call->process_call()
#7 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/response/mediamosa_response.inc(125): mediamosa_rest->process_call(Array)
#8 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/mediamosa.module(94): mediamosa_response->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] => 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->addJoin()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1191.</error>
<error>Warning: Illegal offset type, SelectQuery->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->fields()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1125.</error>
<error>Notice: Undefined variable: table_alias, SelectQuery->fields()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1135.</error>
<error>Notice: Undefined index: arguments, SelectQuery->getArguments()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1019.</error>
<error>Notice: Undefined index: table, SelectQuery->getArguments()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1023.</error>
<error>Notice: Undefined index: table, SelectQuery->__toString()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1313.</error>
<error>Notice: Undefined index: table, SelectQuery->__toString()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1317.</error>
<error>Notice: Undefined index: alias, SelectQuery->__toString()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1322.</error>
</errors>
</header>
<items/>
</response>
Change History
Note: See
TracTickets for help on using
tickets.
