Problem with taxonomy
dominik__w - April 27, 2009 - 14:41
| Project: | Autocomplete Node Finder |
| Version: | 5.x-3.9 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
When I place in "Find nodes by this field" a field such a Taxonomy type (vocabulary name) I will recaive an error like this in instead of a search result
user warning: Unknown column 'autocomplete_node_finder.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (1,2,3) AND autocomplete_node_finder_n.type IN ('wizytowka_info','wizytowka_prestige','wizytowka_standard') AND autocomplete_node_finder_term.name IS NOT NULL AND (autocomplete_node_finder_term.name LIKE '%Kategoria 2%' ) ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 2147483647 in /includes/database.mysql.inc on line 174.
user warning: Unknown column 'autocomplete_node_finder.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (1,2,3) AND autocomplete_node_finder_n.type IN ('wizytowka_info','wizytowka_prestige','wizytowka_standard') AND autocomplete_node_finder_term.name IS NOT NULL AND (autocomplete_node_finder_term.name LIKE '%Kategoria 2%' ) ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 2147483647 in /includes/database.mysql.inc on line 174.Please help me to solve this problem
#1
#2
#3
I am looking at the code that generates this query and I don't see how this is possible.
#4
I'm really stumped I have no clue what is going on - can you tell me which modules you have enabled? Perhaps it will give me a clue :/
#5
I am having the same errors with taxonomy also. I can generate forms that query fields but when I use forms that query taxonomy terms, the search fields don't respond and produce errors as mentioned by dominik__w.
* user warning: Unknown column 'autocomplete_node_finder_tid.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder_n.vid = autocomplete_node_finder_tid.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (684,8,668,698,693,696,699,653,690,709,652,691,712,675,692,708,663,685,711,697,669,679,672,689,11,671,3,667,695,676,650,6,681,694,683,633,678,5,631,680,687,634,688,651,9,706,682,704) AND autocomplete_node_finder_n.type IN ('bio') AND autocomplete_node_finder_term.name IS NOT NULL AND LOWER(autocomplete_node_finder_term.name) LIKE LOWER('%N%') ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 25 in /home/noisevox/public_html/dev/includes/database.mysql.inc on line 174.* user warning: Unknown column 'autocomplete_node_finder_tid.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder_n.vid = autocomplete_node_finder_tid.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (684,8,668,698,693,696,699,653,690,709,652,691,712,675,692,708,663,685,711,697,669,679,672,689,11,671,3,667,695,676,650,6,681,694,683,633,678,5,631,680,687,634,688,651,9,706,682,704) AND autocomplete_node_finder_n.type IN ('bio') AND autocomplete_node_finder_term.name IS NOT NULL AND LOWER(autocomplete_node_finder_term.name) LIKE LOWER('%N%') ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 25 in /home/noisevox/public_html/dev/includes/database.mysql.inc on line 174.
* user warning: Unknown column 'autocomplete_node_finder_tid.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder_n.vid = autocomplete_node_finder_tid.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (684,8,668,698,693,696,699,653,690,709,652,691,712,675,692,708,663,685,711,697,669,679,672,689,11,671,3,667,695,676,650,6,681,694,683,633,678,5,631,680,687,634,688,651,9,706,682,704) AND autocomplete_node_finder_n.type IN ('bio') AND autocomplete_node_finder_term.name IS NOT NULL AND LOWER(autocomplete_node_finder_term.name) LIKE LOWER('%N%') ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 25 in /home/noisevox/public_html/dev/includes/database.mysql.inc on line 174.
* user warning: Unknown column 'autocomplete_node_finder_tid.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder_n.vid = autocomplete_node_finder_tid.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (684,8,668,698,693,696,699,653,690,709,652,691,712,675,692,708,663,685,711,697,669,679,672,689,11,671,3,667,695,676,650,6,681,694,683,633,678,5,631,680,687,634,688,651,9,706,682,704) AND autocomplete_node_finder_n.type IN ('bio') AND autocomplete_node_finder_term.name IS NOT NULL AND LOWER(autocomplete_node_finder_term.name) LIKE LOWER('%N%') ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 25 in /home/noisevox/public_html/dev/includes/database.mysql.inc on line 174.
* user warning: Unknown column 'autocomplete_node_finder_tid.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder_n.vid = autocomplete_node_finder_tid.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (684,8,668,698,693,696,699,653,690,709,652,691,712,675,692,708,663,685,711,697,669,679,672,689,11,671,3,667,695,676,650,6,681,694,683,633,678,5,631,680,687,634,688,651,9,706,682,704) AND autocomplete_node_finder_n.type IN ('bio') AND autocomplete_node_finder_term.name IS NOT NULL AND LOWER(autocomplete_node_finder_term.name) LIKE LOWER('%NY%') ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 25 in /home/noisevox/public_html/dev/includes/database.mysql.inc on line 174.
* user warning: Unknown column 'autocomplete_node_finder_tid.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder_n.vid = autocomplete_node_finder_tid.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (684,8,668,698,693,696,699,653,690,709,652,691,712,675,692,708,663,685,711,697,669,679,672,689,11,671,3,667,695,676,650,6,681,694,683,633,678,5,631,680,687,634,688,651,9,706,682,704) AND autocomplete_node_finder_n.type IN ('bio') AND autocomplete_node_finder_term.name IS NOT NULL AND LOWER(autocomplete_node_finder_term.name) LIKE LOWER('%NYC%') ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 25 in /home/noisevox/public_html/dev/includes/database.mysql.inc on line 174.
* user warning: Unknown column 'autocomplete_node_finder_tid.vid' in 'on clause' query: SELECT autocomplete_node_finder_term.tid AS tid, autocomplete_node_finder_term.name AS field, autocomplete_node_finder_n.nid AS nid FROM node autocomplete_node_finder_n LEFT JOIN term_node autocomplete_node_finder_tid ON autocomplete_node_finder_n.vid = autocomplete_node_finder_tid.vid LEFT JOIN term_data autocomplete_node_finder_term ON autocomplete_node_finder_tid.tid = autocomplete_node_finder_term.tid WHERE autocomplete_node_finder_n.status = 1 AND autocomplete_node_finder_tid.tid IN (684,8,668,698,693,696,699,653,690,709,652,691,712,675,692,708,663,685,711,697,669,679,672,689,11,671,3,667,695,676,650,6,681,694,683,633,678,5,631,680,687,634,688,651,9,706,682,704) AND autocomplete_node_finder_n.type IN ('bio') AND autocomplete_node_finder_term.name IS NOT NULL AND (autocomplete_node_finder_term.name = 'NYC' ) ORDER BY autocomplete_node_finder_term.name ASC LIMIT 0, 2147483647 in /home/noisevox/public_html/dev/includes/database.mysql.inc on line 174.
* Your keyword yields no results.
Here are current modules that are currently being used:
Drupal 5.16 - Includes: Block, Color, Comment, Filter, Help, Menu, Node, Path, Search, Statistics, System, Taxonomy, Upload, User, Watchdog
Actions 5.x-2.6
Activity 5.x-4.x-dev (2009-Apr-09) -Includes: Activity history, Comment activity, Flag activity, Node activity, Voting activity, Activity
AMFPHP 5.x-1.0-beta1
Automatic Nodetitles 5.x-1.2
Auto Assign Role 5.x-1.2
Autocomplete Node Finder 5.x-3.9
Backup and Migrate 5.x-1.2
Bio 5.x-1.3
Content Construction Kit (CCK) 5.x-1.10 - Includes: Content, Content Copy, Fieldgroup, Node Reference, Number, Option Widgets, Text, User Reference
CCK Field Permissions 5.x-1.10
CCK Taxonomy Fields 5.x-1.2
Compact Forms 5.x-1.0
Content Templates (Contemplate) 5.x-2.04
Date 5.x-2.6 - Includes: Date, Date API, Date Timezone
Embedded Media Field 5.x-1.3 - Includes: Embedded Image Field, Embedded Media Field
FileField 5.x-2.4
Flag 5.x-1.1
Forward 5.x-1.20
Google Analytics 5.x-1.9
Image 5.x-1.9 - Includes: Image Attach, Image
ImageAPI 5.x-1.5 - Includes: ImageAPI, ImageAPI GD2, ImageAPI ImageMagick
ImageCache 5.x-2.4 - Includes: ImageCache, Imagecache UI
ImageField 5.x-2.6
Invite 5.x-1.13 - Includes: Cancel User Accounts, Invite
jCarousel 5.x-1.3
jQuery Update 5.x-2.0
Link 5.x-2.5
MimeDetect 5.x-1.2
NodeReferrer 5.x-1.x-dev (2008-Jun-10)
Pathauto 5.x-2.3
Poormanscron 5.x-1.1
Printer, e-mail and PDF versions 5.x-4.5
Privatemsg 5.x-3.0
Restricted Search 5.x-1.1
Services 5.x-0.92 - Includes: Node Service, System Service, Views Service, Services
SimpleMenu 5.x-5.0
Taxonomy Menu 5.x-1.03
Token 5.x-1.11
Update Status 5.x-2.3
User Delete 5.x-1.0
Usernode 5.x-1.4
User Points 5.x-3.7 - Includes: Userpoints, Userpoints Workflow-NG integration, Userpoints Basic, Views Integration
userreview 5.x-1.x-dev (2007-Jun-27)
Viewfield 5.x-1.5
Views 5.x-1.6 - Includes: Views, Views UI, Views RSS, Views Theme Wizard
Views Bonus Pack 5.x-1.2-alpha2
Vote Up/Down 5.x-1.0
Voting API 5.x-1.6
Workflow-ng 5.x-2.2 - Includes: Workflow-ng, Workflow-ng UI
#6
Your error is not the same as the original post. I see now that the SQL queries backported from Drupal 6 are not compatible with the Drupal 5 schema.
the join between term_node and node should be on nid not vid.
#7
Thank you danielb for addressing this issue. Is there a quick fix to this?
#8
I have made a fix for this and released a new version as 5.x-3.10
Feel free to reopen if you encounter the issue again.
#9
Awesome! it seems to work now, thank you so much!
#10
Automatically closed -- issue fixed for 2 weeks with no activity.