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

mauritsl’s picture

Status: Active » Fixed

I'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.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.