Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.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
Comment #1
Prometheus6 commentedMissed one change from node_get_types() to node_list() when backporting the new stuff.
I just committed the correction.
Comment #2
lcd_47 commentedNope, same error with 1.8.2.8.
Comment #3
lcd_47 commentedSorry, 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.
Comment #4
Prometheus6 commentedTry visiting the settings page and explicitly setting the values.
Comment #5
lcd_47 commentedSetting the values explicitly in block's configuration page fixes the problem; perhaps this should be done automatically...
Anyway, thanks for the quick answer!
Comment #6
Prometheus6 commentedActually, now I have good defaults so no one else should have the problem.
Comment #7
Prometheus6 commented