Closed (fixed)
Project:
Shadow - SQL queries / views optimization
Version:
7.x-1.0-beta2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
9 Feb 2012 at 14:23 UTC
Updated:
16 May 2012 at 21:10 UTC
I'm receiving this error upon navigating to admin/config/development/shadow/queries/list/1/new:
exception 'Exception' with message 'Parse error in state "fieldlist_comma" at offset 241 (near " 'flagging")' in sites/all/modules/contrib/shadow/classes/state_machine.inc:143
Stack trace:
#0 sites/all/modules/contrib/shadow/classes/query.inc(417): ShadowStateMachine->parse('SELECT flag_con...')
#1 sites/all/modules/contrib/shadow/classes/query.inc(412): ShadowQuery->parse('SELECT flag_con...')
#2 sites/all/modules/contrib/shadow/shadow.admin.inc(493): ShadowQuery->__construct('SELECT flag_con...')
#3 includes/form.inc(773): shadow_create_table_form(Array, Array, '1')
#4 includes/form.inc(317): drupal_retrieve_form('shadow_create_t...', Array)
#5 includes/form.inc(189): drupal_build_form('shadow_create_t...', Array)
#6 includes/menu.inc(503): drupal_get_form('shadow_create_t...', Array)
#7 index.php(21): menu_execute_active_handler() #8 {main}
Here is the query:
SELECT flag_content_node.fcid AS flag_content_node_fcid, node.nid AS nid, node.title AS node_title, flag_content_node.timestamp AS flag_content_node_timestamp, flag_content_current_user_3.content_id AS flag_content_current_user_3_content_id, 'flagging' AS field_data_field_ugc_collection_site_flagging_entity_type, 'node' AS field_data_field_node_uuid_node_entity_type, 'node' AS field_data_field_node_image_url_node_entity_type, 'flagging' AS field_data_field_ugc_collection_note_flagging_entity_type, 'flagging' AS field_data_field_ugc_collection_tags_flagging_entity_type
FROM
{node} node
LEFT JOIN {taxonomy_index} taxonomy_index ON node.nid = taxonomy_index.nid
LEFT JOIN {taxonomy_term_data} taxonomy_term_data_node ON taxonomy_index.tid = taxonomy_term_data_node.tid
INNER JOIN {flag_content} flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = :views_join_condition_0 AND flag_content_node.uid = :views_join_condition_1)
LEFT JOIN {flag_content} flag_content_current_user_3 ON node.nid = flag_content_current_user_3.content_id AND (flag_content_current_user_3.fid = :views_join_condition_2 AND flag_content_current_user_3.uid = :views_join_condition_3 AND flag_content_current_user_3.sid = :views_join_condition_4)
ORDER BY flag_content_node_timestamp DESC
Any clues on where to look?
Comments
Comment #1
mauritsl commentedI've made some improvements to the SQL parser and this query can now be parsed without errors. I've created a new beta release with the parser changes.