I get the following error:

user warning: Unknown column 'n.nid' in 'field list' query: SELECT DISTINCT(n.nid), title, created FROM node WHERE type = "planet" ORDER BY created DESC LIMIT 0, 10 in /home/duimenvoorjongeren.be/public_html/includes/database.mysql.inc on line 172.

php5, drupal5.3

Comments

Anonymous’s picture

Anonymous (not verified) commented

I fixed this "bug" by slightly modifying the SQL SELECTS in function planet_queue() in planet.module:

Change the statement 

 $result = pager_query(db_rewrite_sql('SELECT nid, title, created FROM {node} WHERE ...

on lines 246 and 249 (in 1.2) into

 $result = pager_query(db_rewrite_sql('SELECT nid, title, created FROM {node} n WHERE

See the "n" after "{node}". Now it works.

jiangxijay’s picture

jiangxijay commented

Subscribe. Similar error. Don't want to tweak module. Awaiting resolution.

user warning: Unknown table 'n' in on clause query: SELECT COUNT(*) FROM bn_node LEFT JOIN bn_localizernode loc ON loc.nid=n.nid WHERE (loc.locale IN ('en-US','es','-') OR loc.locale IS NULL) AND ( type = "planet" ) in /home/<snip>/drupal/includes/database.mysql.inc on line 172.

user warning: Unknown table 'n' in field list query: SELECT DISTINCT(n.nid), title, created FROM bn_node LEFT JOIN bn_localizernode loc ON loc.nid=n.nid WHERE (loc.locale IN ('en-US','es','-') OR loc.locale IS NULL) AND ( type = "planet" ) ORDER BY created DESC LIMIT 0, 5 in /home/<snip>/drupal/includes/database.mysql.inc on line 172.
Anonymous’s picture

Anonymous (not verified) commented

I switched completly to simplefeed.module. With planet.module it was annoying, that it always refreshed the feed items and didn't check if anything changed in the source item. So my RSS feeds and the "recent changes" list *always* showed updated nodes ...
Everything is working fine now.

swe3tdave’s picture

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

Personnaly, i dont plan to work on the 5.x module. There is a lot of problems with it and i dont feel like fixing everything twice.