Ticket #251 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

gebruik van 'aut_domain' parameter op een /asset call gaat fout

Reported by: Michiel.Schok Owned by:
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

<?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>/asset</request_matched_uri>
    <request_process_time>0.0601</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 
mediamosa_aut_group ag
WHERE  (aut_group_id IN  ('16', '14', '9', '12'))' 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/aut/mediamosa_aut.inc(328): SelectQuery-&gt;execute()
#4 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/core/aut/mediamosa_aut.inc(1100): mediamosa_aut::build_access(Array, NULL, Array, 'surfnet.nl', NULL, Array)
#5 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/core/asset/mediamosa_asset_search.inc(383): mediamosa_aut::build_access_where(Array, 'MEDIAFILE', NULL, Array, NULL, Array, 'surfnet.nl', NULL, Array, false, true)
#6 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/modules/asset/mediamosa_asset.rest.inc(508): mediamosa_asset_search::asset_search(Object(mediamosa_response), Array, NULL, NULL, Array, 'surfnet.nl', NULL, NULL, NULL, NULL, true, false, false, false, false, false, true, false, true, 10, 0)
#7 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest_call.inc(269): mediamosa_rest_call_asset_search-&gt;do_call()
#8 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest.inc(304): mediamosa_rest_call-&gt;process_call()
#9 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/response/mediamosa_response.inc(125): mediamosa_rest-&gt;process_call(Array)
#10 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/mediamosa.module(94): mediamosa_response-&gt;process_rest()
#11 [internal function]: mediamosa_init()
#12 /var/opt/www/vpcore/htdocs/includes/module.inc(413): call_user_func_array('mediamosa_init', Array)
#13 /var/opt/www/vpcore/htdocs/includes/common.inc(3769): module_invoke_all('init')
#14 /var/opt/www/vpcore/htdocs/includes/bootstrap.inc(1551): _drupal_bootstrap_full()
#15 /var/opt/www/vpcore/htdocs/includes/bootstrap.inc(1417): _drupal_bootstrap(8)
#16 /var/opt/www/vpcore/htdocs/index.php(21): drupal_bootstrap(8)
#17 {main},
Query string; SELECT 
FROM 
{mediamosa_aut_group} ag
WHERE  (aut_group_id IN  (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3)) ,
Args; Array
(
    [:db_condition_placeholder_0] =&gt; 16
    [:db_condition_placeholder_1] =&gt; 14
    [:db_condition_placeholder_2] =&gt; 9
    [:db_condition_placeholder_3] =&gt; 12
)
</request_result_description>
    <request_result_id>500</request_result_id>
    <request_uri>[GET] /asset?aut_domain=surfnet.nl</request_uri>
    <version>2.1.0.236:07ebc5929cac</version>
    <errors>
      <error>Warning: Illegal offset type in isset or empty, SelectQuery-&gt;addField()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1104.</error>
      <error>Warning: Illegal offset type in isset or empty, SelectQuery-&gt;addField()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1111.</error>
      <error>Warning: Illegal offset type, SelectQuery-&gt;addField()() in file /var/opt/www/vpcore/htdocs/includes/database/select.inc on line 1116.</error>
    </errors>
  </header>
  <items/>
</response>

Change History

Changed 3 years ago by robert

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

Release 2.1

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 Michiel.Schok

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

We krijgen nu geen stacktrace meer.

Note: See TracTickets for help on using tickets.