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

Prometheus6’s picture

Assigned: Unassigned » Prometheus6
Status: Active » Fixed

Missed one change from node_get_types() to node_list() when backporting the new stuff.

I just committed the correction.

lcd_47’s picture

Status: Fixed » Active

Nope, same error with 1.8.2.8.

lcd_47’s picture

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.

Prometheus6’s picture

Try visiting the settings page and explicitly setting the values.

lcd_47’s picture

Status: Active » Fixed

Setting the values explicitly in block's configuration page fixes the problem; perhaps this should be done automatically...
Anyway, thanks for the quick answer!

Prometheus6’s picture

Actually, now I have good defaults so no one else should have the problem.

Prometheus6’s picture

Status: Fixed » Closed (fixed)