Prior to the latest update 5.x-1.7, I was using the Most Emailed block without issue. After the update, I get the following SQL error

user warning: Unknown column 's.nid' in 'on clause' query: eval SELECT node.nid AS nid_me, node.title, count(*) AS cnt,node_data_field_headline.field_headline_value AS X FROM shared_forward_log s LEFT JOIN shared_node AS node ON s.nid = node.nid LEFT JOIN shared_content_field_headline node_data_field_headline ON node.vid = node_data_field_headline.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND s.type='sent' group by node.nid ORDER BY cnt DESC LIMIT 0, 5 in /var/www/html/includes/database.mysqli.inc on line 156.

So I thought "hey the schema changed, but there was nothing in the release notes, no big deal I'll look at the code and get the SQL I want from there." The SQL from the code though also throws an error:

Unknown column 's.nid' in 'on clause'

This is the code snippet from the Most Emailed section of forward.module

$query="SELECT n.nid, n.title, count(*) AS cnt FROM {forward_log} s LEFT JOIN {node} n ON s.nid = n.nid WHERE s.type='sent' AND n.status=1 AND timestamp > ". $pastday .' GROUP BY n.nid, n.title ORDER BY cnt DESC';

Am I missing something?

Comments

stevenpatz’s picture

Version: 5.x-1.7 » 5.x-1.17

Updated the Version, I am using the latest release.

seanr’s picture

Could you please retest with the current version?

stevenpatz’s picture

Status: Active » Closed (fixed)