Posted by Senore on February 1, 2012 at 8:32pm
3 followers
Jump to:
| Project: | Finder |
| Version: | 6.x-1.21 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Hi, I just updated Finder to 1.21 (on my productive site, yeah I know that was stupid..). I haven't done that in a while but noticed that intersect wasn't working properly anymore, so I rushed and updated to the latest. Resaved Finder, but now I get already an error when I open the page where the Finder-block is active. It's completely broken. :-/
I use a Views Finder in a block, with 4 taxonomy vocabularies and multiple terms with checkboxes in each vocabulary. All I see in the block now is the names of my four vocabularies as titles and the search button. But no terms to select at all. Did I have to do anything after/before the update which I didn't see?
The error is:
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 ') ORDER BY term_data_weight ASC' at line 30 query: SELECT node.nid AS nid, node.title AS node_title, node.language AS node_language, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node.type AS node_type, node.vid AS node_vid, node_data_field_date.field_textdate_value AS node_data_field_date_field_textdate_value, node_data_field_date.field_textdate_format AS node_data_field_date_field_textdate_format, node_data_field_date.field_projectofferer_value AS node_data_field_date_field_projectofferer_value, node_data_field_date.field_projectofferer_format AS node_data_field_date_field_projectofferer_format, term_data_1.name AS term_data_1_name, term_data_1.vid AS term_data_1_vid, term_data_1.tid AS term_data_1_tid, term_data.weight AS term_data_weight, finder_table_2.name AS finder_field_1, finder_table_2.name AS finder_field_1_matched FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_inhalt node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data_1 ON term_node.tid = term_data_1.tid AND term_data_1.vid = 1 LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN term_node finder_table_3 ON node.vid = finder_table_3.vid LEFT JOIN term_data finder_table_2 ON finder_table_3.tid = finder_table_2.tid AND finder_table_2.vid = 1 WHERE (1=1) AND (finder_table_2.name IS NOT NULL) AND () ORDER BY term_data_weight ASC in /homepages/21/xxx/htdocs/sites/all/modules/views/includes/view.inc on line 814.
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 ') ORDER BY term_data_weight ASC' at line 30 query: SELECT node.nid AS nid, node.title AS node_title, node.language AS node_language, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node.type AS node_type, node.vid AS node_vid, node_data_field_date.field_textdate_value AS node_data_field_date_field_textdate_value, node_data_field_date.field_textdate_format AS node_data_field_date_field_textdate_format, node_data_field_date.field_projectofferer_value AS node_data_field_date_field_projectofferer_value, node_data_field_date.field_projectofferer_format AS node_data_field_date_field_projectofferer_format, term_data_4.name AS term_data_4_name, term_data_4.vid AS term_data_4_vid, term_data_4.tid AS term_data_4_tid, term_data.weight AS term_data_weight, finder_table_5.name AS finder_field_4, finder_table_5.name AS finder_field_4_matched FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_inhalt node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data_4 ON term_node.tid = term_data_4.tid AND term_data_4.vid = 4 LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN term_node finder_table_6 ON node.vid = finder_table_6.vid LEFT JOIN term_data finder_table_5 ON finder_table_6.tid = finder_table_5.tid AND finder_table_5.vid = 4 WHERE (1=1) AND (finder_table_5.name IS NOT NULL) AND () ORDER BY term_data_weight ASC in /homepages/21/xxx/htdocs/sites/all/modules/views/includes/view.inc on line 814.
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 ') ORDER BY term_data_weight ASC' at line 30 query: SELECT node.nid AS nid, node.title AS node_title, node.language AS node_language, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node.type AS node_type, node.vid AS node_vid, node_data_field_date.field_textdate_value AS node_data_field_date_field_textdate_value, node_data_field_date.field_textdate_format AS node_data_field_date_field_textdate_format, node_data_field_date.field_projectofferer_value AS node_data_field_date_field_projectofferer_value, node_data_field_date.field_projectofferer_format AS node_data_field_date_field_projectofferer_format, term_data_2.name AS term_data_2_name, term_data_2.vid AS term_data_2_vid, term_data_2.tid AS term_data_2_tid, term_data.weight AS term_data_weight, finder_table_8.name AS finder_field_7, finder_table_8.name AS finder_field_7_matched FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_inhalt node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data_2 ON term_node.tid = term_data_2.tid AND term_data_2.vid = 2 LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN term_node finder_table_9 ON node.vid = finder_table_9.vid LEFT JOIN term_data finder_table_8 ON finder_table_9.tid = finder_table_8.tid AND finder_table_8.vid = 2 WHERE (1=1) AND (finder_table_8.name IS NOT NULL) AND () ORDER BY term_data_weight ASC in /homepages/21/xxx/htdocs/sites/all/modules/views/includes/view.inc on line 814.
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 ') ORDER BY term_data_name ASC' at line 30 query: SELECT node.nid AS nid, node.title AS node_title, node.language AS node_language, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node.type AS node_type, node.vid AS node_vid, node_data_field_date.field_textdate_value AS node_data_field_date_field_textdate_value, node_data_field_date.field_textdate_format AS node_data_field_date_field_textdate_format, node_data_field_date.field_projectofferer_value AS node_data_field_date_field_projectofferer_value, node_data_field_date.field_projectofferer_format AS node_data_field_date_field_projectofferer_format, term_data_3.name AS term_data_3_name, term_data_3.vid AS term_data_3_vid, term_data_3.tid AS term_data_3_tid, term_data.name AS term_data_name, finder_table_11.name AS finder_field_10, finder_table_11.name AS finder_field_10_matched FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_inhalt node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data_3 ON term_node.tid = term_data_3.tid AND term_data_3.vid = 3 LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN term_node finder_table_12 ON node.vid = finder_table_12.vid LEFT JOIN term_data finder_table_11 ON finder_table_12.tid = finder_table_11.tid AND finder_table_11.vid = 3 WHERE (1=1) AND (finder_table_11.name IS NOT NULL) AND () ORDER BY term_data_name ASC in /homepages/21/xxx/htdocs/sites/all/modules/views/includes/view.inc on line 814.I would really appreciate any help! I also updated Views to 6-2.16 prior to the Finder update.
Comments
#1
6.x-1.21 contains critical bugs, it is not a recommended release. I have tried to indicate this by unticking 'recommended' on that release, and by stating "this release contains critical bugs" in the release node. I have since fixed this AFAIK, but I am currently unable to make a new release.
Sorry about this, normally I would be able to rectify this immediately, but my hands are tied.
#2
see #1420782: Views Finder not working after upgrade
#3
Ouch. I consider this my fault then. I believe it still was the recommended release that's why I took it, however I rushed through the release notes and did not notice. Thank you for your answer, are you able to give me a timeframe? If it takes longer I will have to see if I can downgrade somehow. Thanks again for your quick answer.
#4
For production I would recommend downgrading to the version you had, or one of the more popular versions according to the usage statistics linked on the project page. The time frame is hopefully a matter of days though.
#5
Great, a matter of days sounds good! I'll see what I will to until then. Thanks!
#6
Automatically closed -- issue fixed for 2 weeks with no activity.