After upgrading to the latest version of the Archive module, now when I go to the page, it gives the following error message:

user warning: Unknown table 'n' in field list query: SELECT DISTINCT(n.nid), type FROM node WHERE status = 1 AND created >= 1170712800 AND created < 1170799200 ORDER BY created DESC LIMIT 0, 10 in /home/xprt007/public_html/drupal5/includes/database.mysql.inc on line 172.

... which was not there before the upgrade.

A commendable thing is that since the update, all submissions made on a specific day are automatically shown.

How does one get rid of this ugly error message, which otherwise make me disable the module?

Thanks.

Comments

lionheart8’s picture

lionheart8 commented

... sorry, I meant to say submissions are NOT automatically shown, which is a good thing. :)

gábor hojtsy’s picture

gábor hojtsy
he/him
Primary language Hungarian
Location Hungary
commented
Component: User interface » Code
Status: Active » Fixed

Well, if you replace line 110 with the following, the error should go away. I have just released v5.x-1.2 of archive module to fix this issue. Thanks for reporting.

return array('SELECT n.nid, n.type FROM {node} n WHERE n.status = 1 AND n.created >= %d AND n.created < %d ORDER BY n.created D
ESC', $start - $date->tz, $end - $date->tz);
Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)