Posted by lcd_47 on March 11, 2006 at 5:24pm
Jump to:
| Project: | Weekly Archive by Node Type |
| Version: | 4.6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Prometheus6 |
| Status: | closed (fixed) |
Issue Summary
Upgrading to the week module version 1.8.2.7 results in the following errors being displayed and logged:
Invalid argument supplied for foreach() in .../modules/week/week.module on line 23.
implode(): Bad arguments. in .../modules/week/week.module on line 27.
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 'INNER JOIN node_access na ON na.nid = node.nid UNIXTIME(changed),0) AS weekno FR' at line 1 query: SELECT YEARWEEK(FROM_ INNER JOIN node_access na ON na.nid = node.nid UNIXTIME(changed),0) AS weekno FROM node n INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','og_uid0','og_group0')) AND n.type IN () GROUP BY weekno ORDER BY weekno DESC LIMIT 9 in .../includes/database.mysql.inc on line 66.Downgrading to version 1.8.2.6 makes the problem go away.
Comments
#1
Missed one change from node_get_types() to node_list() when backporting the new stuff.
I just committed the correction.
#2
Nope, same error with 1.8.2.8.
#3
Sorry, the problem seems to be deeper than I initially reported. Downgrading to version 1.8.2.6 doesn't produce any error, but the block is not shown. Downgrading to 1.8.2.5 makes the block reappear.
#4
Try visiting the settings page and explicitly setting the values.
#5
Setting the values explicitly in block's configuration page fixes the problem; perhaps this should be done automatically...
Anyway, thanks for the quick answer!
#6
Actually, now I have good defaults so no one else should have the problem.
#7