user warning: Unknown column 's.nid' in 'on clause' 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 GROUP BY n.nid, n.title ORDER BY cnt DESC LIMIT 0, 5 in /var/www/vhosts/therevival.co.uk/httpdocs/sites/all/modules/forward/forward.module on line 959

From what I can see, there is no column called nid in the table forward_log, just path, type and timestamp.

Comments

Peter Martin’s picture

Peter Martin commented

I am receiving the same error after installing the latest version and running Drupal update.

naheemsays’s picture

naheemsays commented
Status: Active » Fixed

Just updated to a later version of the module (7 September) and this issue is fixed.

emilyf’s picture

emilyf commented
Status: Fixed » Active

I have the latest dev version (appears to be sept 6, don't see anything for sept 7) and running update.php gives me the same error described:

Failed: ALTER TABLE {forward_log} DROP INDEX forward_nid

and

user warning: Can't DROP 'forward_nid'; check that column/key exists query: ALTER TABLE forward_log DROP INDEX forward_nid in /var/www/html/includes/database.mysql-common.inc on line 448.

seanr’s picture

seanr
he/him
commented
Status: Active » Fixed

Please try it again (you may have to pull from CVS or wait until the packages update later today). There was an error in the 5.x branch, but I just fixed that and the other branches appear correct.

Anonymous’s picture

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

Automatically closed -- issue fixed for two weeks with no activity.