When cron runs, get this error on every entry:

1) Unknown column 'Object' in 'where clause' query: SELECT * FROM term_data WHERE tid = Object in /includes/database.mysqli.inc on line 121.

Looks like not associating the category selection of the feed with aggregator item. Viewing the category tag for an item, see no results.

Comments

Anonymous’s picture

Anonymous (not verified) commented
Priority: Critical » Minor

Sorry - this is just user error. The Aggregator Item node type needs to be associated to the same vocabulary as the feed is associated to in the module settings. Should add that to the install docs.

budda’s picture

budda
Primary language English
Location Cheshire
commented
Assigned: Unassigned » budda
Status: Active » Fixed

Have updated the node processor (feedaggregator_node.module) to better handle things when you have not yet created a vocabulary that is assigned to the 'aggregator-item' content-type.

Committed to CVS.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Active

I was incorrect above, just setting the Aggregator Item content type to be the same vocab as the feed did not resolve this issue. Downloaded the latest build, but still getting the SQL error:

Unknown column 'Object' in 'where clause' query: SELECT * FROM term_data WHERE tid = Object in /var/www/vhosts/blockhousepublishing.net/httpdocs/includes/database.mysqli.inc on line 121.

Throws this error for every new node created - a sea of red in my log :)

-G

budda’s picture

budda
Primary language English
Location Cheshire
commented
Status: Active » Fixed

I fixed this last week but never updated CVS as I was trying to resolve the HTML entity bug in the code.

So this should now be fixed with tonights CVS update.

Anonymous’s picture

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