By etrangerequitraverselaville on

When I deleted a term from a taxonomy vocabulary this message started to appear:

user warning: Unknown table 'term_node_1' in field list query: SELECT node.nid, term_node_1.name AS term_node_1_name, term_node_2.name AS term_node_2_name FROM node node LIMIT 0, 10 in C:\xampplite\htdocs\drupal\includes\database.mysql.inc on line 172.

I don't know how to fix it or what it means. Any help? Thanks a lot.

⋅ Categories: Drupal 5.x

Comments

cog.rusty’s picture

cog.rusty commented

I have seen this again!

http://drupal.org/node/161863

Apparently there is a broken query because there is no such table.

Check your views created with the views module. Try to open them for editing and save them again to make them rebuild themselves.

etrangerequitraverselaville’s picture

etrangerequitraverselaville commented

Thanks that worked out alright!!

Wimmmmm’s picture

Wimmmmm commented

I have exactly the same problem here...
Usign Drupal 5.3, all modules have their latest versions.

I have a hefty view, with lots of filters, arguments, one exposed filter.
I'm displaying content in two languages, Dutch and French.
Every now and then the French content is no longer visible, the Dutch content still is - they're using the SAME view!
When going to the French page, I see the pagers 1 to 9, but no single node is rendering.
At that point, I have this in the log files:

I can "solve" it by opening the view and saving, but this is of course no solution, since a couple of hours later it will go berserk again!
Yhis site is now live - I'd appreciate some support :-)

Unknown column 'term_node_2.name' in 'field list' query: SELECT node.nid, node.sticky AS node_sticky, node.created AS node_created_created, node_counter.totalcount AS node_counter_totalcount, users.name AS users_name, users.uid AS users_uid, node_data_field_thumbnail.field_thumbnail_fid AS node_data_field_thumbnail_field_thumbnail_fid, node_data_field_thumbnail.field_thumbnail_title AS node_data_field_thumbnail_field_thumbnail_title, node_data_field_thumbnail.field_thumbnail_alt AS node_data_field_thumbnail_field_thumbnail_alt, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, votingapi_cache_vote_percent_average.value AS votingapi_cache_vote_percent_average_value, term_node_2.name AS term_node_2_name, node_data_field_long_video.field_long_video_value AS node_data_field_long_video_field_long_video_value FROM node node LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid INNER JOIN users users ON node.uid = users.uid LEFT JOIN content_field_thumbnail node_data_field_thumbnail ON node.vid = node_data_field_thumbnail.vid LEFT JOIN votingapi_cache votingapi_cache_vote_percent_average ON node.nid = votingapi_cache_vote_percent_average.content_id AND votingapi_cache_vote_percent_average.content_type = 'node' AND votingapi_cache_vote_percent_average.value_type = 'percent' AND votingapi_cache_vote_percent_average.tag = 'vote' AND votingapi_cache_vote_percent_average.function = 'average' LEFT JOIN content_type_news node_data_field_long_video ON node.vid = node_data_field_long_video.vid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='fr' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.status = '1') AND (node.type IN ('news')) AND (node.created >= 1159999200 && node.created <= 1194735599) ) ORDER BY node_sticky DESC, node_created_created DESC LIMIT 0, 10
cog.rusty’s picture

cog.rusty commented

Probably the best chance for a proper solution is to take this to the view module's issues queue (http://drupal.org/project/issues/views)

willeaton’s picture

willeaton commented

I had exactly the same problem and found a brief comment about it sounding like a cache issue, sure enough, when I deleted my cache, everything worked again. Not sure about this but I'm still in development so haven't turned my cron on yet, maybe not running that often enough causes issues... dunno!
Will Eaton

mamasdiner’s picture

mamasdiner commented

I know this post is outdated, but thought I'd share my experience.

I upgraded from 5.9 to 5.10. I had the same errors. I thought it was due to my Emfield or Video modules so deleted and reinstalled Emfield, but still the same error. I also followed this advice for Emfield "If any files stop working after you update, please go to admin/content/node, select all nodes that have embedded media fields and select "reload embedded media data". That gave me a whole new set of errors. I didn't know what to do with Video module so left it alone.

I followed the advice here and opened my Views and resaved each. Still the errors. I opened each Content Type that was listed in my error log and saved each. That did the trick! So any node where I used upload video or audio, etc. I opened and resaved and that was it. My site showed code where I had placed a video block, so I opened views for the block and resaved. I also made sure that in the view I had for that video block that the settings were correct because for some reason it defaulted back to the large video size and not the thumbnail. So far all errors are gone.

Hope this helps someone else.

Heather

giorgio79’s picture

giorgio79 commented

Thanks very much for the tips.

I had the following message:
user warning: Unknown column 'node_counter.totalcount' in 'field list' query

After clearing the views cache everything came back again.

Cheers,
G

My Drupal sites: