I am trying to upgrade my views from 2x to 3x and when I do this I get all these warnings.

user warning: 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 '= term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_addito' at line 5 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid_1, location_node_data_field_additonal_geo_info.city AS location_node_data_field_additonal_geo_info_city, node.nid AS nid FROM node node LEFT JOIN term_data term_data_node ON .tid = term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_additonal_geo_info ON node.vid = node_data_field_additonal_geo_info.vid LEFT JOIN location location_node_data_field_additonal_geo_info ON node_data_field_additonal_geo_info.field_additonal_geo_info_lid = location_node_data_field_additonal_geo_info.lid LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid WHERE (node.type in ('beer_craving')) AND (node.status = 1) AND (workflow_node.sid = 4) AND (location_node_data_field_additonal_geo_info.city IS NOT NULL) ) count_alias in /home/idbeer/public_html/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
user warning: 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 '= term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_addito' at line 5 query: SELECT DISTINCT(node.nid) AS nid_1, location_node_data_field_additonal_geo_info.city AS location_node_data_field_additonal_geo_info_city, node.nid AS nid FROM node node LEFT JOIN term_data term_data_node ON .tid = term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_additonal_geo_info ON node.vid = node_data_field_additonal_geo_info.vid LEFT JOIN location location_node_data_field_additonal_geo_info ON node_data_field_additonal_geo_info.field_additonal_geo_info_lid = location_node_data_field_additonal_geo_info.lid LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid WHERE (node.type in ('beer_craving')) AND (node.status = 1) AND (workflow_node.sid = 4) AND (location_node_data_field_additonal_geo_info.city IS NOT NULL) LIMIT 0, 10 in /home/idbeer/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150.
user warning: 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 '= term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_addito' at line 4 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, term_data_node__term_node_count.node_count AS term_data_node__term_node_count_node_count FROM node node LEFT JOIN term_data term_data_node ON .tid = term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_additonal_geo_info ON node.vid = node_data_field_additonal_geo_info.vid LEFT JOIN location location_node_data_field_additonal_geo_info ON node_data_field_additonal_geo_info.field_additonal_geo_info_lid = location_node_data_field_additonal_geo_info.lid LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid LEFT JOIN term_node_count term_data_node__term_node_count ON term_data_node.tid = term_data_node__term_node_count.tid WHERE (node.type in ('beer_craving')) AND (node.status = 1) AND (workflow_node.sid = 4) AND (location_node_data_field_additonal_geo_info.city IS NOT NULL) ORDER BY term_data_node__term_node_count_node_count DESC ) count_alias in /home/idbeer/public_html/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
user warning: 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 '= term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_addito' at line 4 query: SELECT DISTINCT(node.nid) AS nid, term_data_node__term_node_count.node_count AS term_data_node__term_node_count_node_count FROM node node LEFT JOIN term_data term_data_node ON .tid = term_data_node.tid LEFT JOIN content_type_beer_craving node_data_field_additonal_geo_info ON node.vid = node_data_field_additonal_geo_info.vid LEFT JOIN location location_node_data_field_additonal_geo_info ON node_data_field_additonal_geo_info.field_additonal_geo_info_lid = location_node_data_field_additonal_geo_info.lid LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid LEFT JOIN term_node_count term_data_node__term_node_count ON term_data_node.tid = term_data_node__term_node_count.tid WHERE (node.type in ('beer_craving')) AND (node.status = 1) AND (workflow_node.sid = 4) AND (location_node_data_field_additonal_geo_info.city IS NOT NULL) ORDER BY term_data_node__term_node_count_node_count DESC LIMIT 0, 10 in /home/idbeer/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150.

Comments

sslam’s picture

sslam commented
Priority: Major » Critical

I have the same problem.

user warning: Unknown column 'term_node_value_0.tid' in 'on clause' query: SELECT DISTINCT(node.nid) AS nid, node.type AS node_type, term_data_node__term_image.tid AS term_data_node__term_image_tid, term_data_node.description AS term_data_node_description FROM node node INNER JOIN term_data term_data_node ON term_node_value_0.tid = term_data_node.tid LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 10 LEFT JOIN term_image term_data_node__term_image ON term_data_node.tid = term_data_node__term_image.tid WHERE (node.status = 1) AND (node.type IN ('product')) AND (term_data_node.vid in ('2')) AND (term_node_value_0.tid = 10) LIMIT 0, 1 in /var/www/virtual/fortem.com.ua/htdocs/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150.
user warning: Unknown column 'term_node_value_0.tid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid_1, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_title.field_title_value AS node_data_field_title_field_title_value, node_data_field_title.field_amperage_value AS node_data_field_title_field_amperage_value, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node.title AS node_title, uc_products.sell_price AS uc_products_sell_price FROM node node INNER JOIN term_data term_data_node ON term_node_value_0.tid = term_data_node.tid LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 10 LEFT JOIN content_type_product node_data_field_title ON node.vid = node_data_field_title.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = 1) AND (node.type IN ('product')) AND (term_node_value_0.tid = 10) ORDER BY node_title ASC ) count_alias in /var/www/virtual/fortem.com.ua/htdocs/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
user warning: Unknown column 'term_node_value_0.tid' in 'on clause' query: SELECT DISTINCT(node.nid) AS nid_1, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_title.field_title_value AS node_data_field_title_field_title_value, node_data_field_title.field_amperage_value AS node_data_field_title_field_amperage_value, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node.title AS node_title, uc_products.sell_price AS uc_products_sell_price FROM node node INNER JOIN term_data term_data_node ON term_node_value_0.tid = term_data_node.tid LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 10 LEFT JOIN content_type_product node_data_field_title ON node.vid = node_data_field_title.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = 1) AND (node.type IN ('product')) AND (term_node_value_0.tid = 10) ORDER BY node_title ASC LIMIT 0, 20 in /var/www/virtual/fortem.com.ua/htdocs/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150.
mustanggb’s picture

mustanggb commented
Status: Active » Closed (won't fix)