I had Trackback installed with no filtering of spam. So about 4,000 spam trackbacks later I figured I needed to deal with the issue. I installed the Spam module. I also updated the trackback.spam.inc file with a newer version that was suggested in a post in this help forum. I then deleted the spam trackbacks through phpMyAdmin as there were too many to delete within Drupal.

I now have the following error message:



    user warning: Unknown column 's.source' in 'on clause' query: SELECT COUNT(*) FROM trackback_received tr LEFT JOIN spam_tracker s ON s.source = 'trackback' AND tr.trid = s.id WHERE tr.status = 1 in /var/www/vhosts/provada.com/httpdocs/sites/all/modules/trackback/trackback.admin.inc on line 75.
    user warning: Unknown column 's.probability' in 'field list' query: SELECT tr.*, s.probability FROM trackback_received tr LEFT JOIN spam_tracker s ON s.source = 'trackback' AND tr.trid = s.id WHERE tr.status = 1 ORDER BY created DESC LIMIT 0, 50 in /var/www/vhosts/provada.com/httpdocs/sites/all/modules/trackback/trackback.admin.inc on line 75.

Any clue what I did or how to fix the problem?

Comments

Lloyd’s picture

Lloyd commented

I disabled the spam module and the error message went away, and a list of trackbacks appeared. However, most were spam. So it appears that there is some compatibility issue between the Spam module and the Trackback module. I guess I'll disable Trackback until I figure out some way of combating spam.