Great work so far. This is the one bug I've encountered so far.

When creating a feed and I choose to promote n number of items I get the following MySQL error(s) when refreshing the feed. Otherwise it works well.

user error: You have an error in your SQL syntax near 'n, aggregator2_item a SET n.promote = 0 WHERE a.nid = n.nid AND a.fid = 208' at line 1
query: UPDATE node n, aggregator2_item a SET n.promote = 0 WHERE a.nid = n.nid AND a.fid = 208 in /var/www/html/includes/database.mysql.inc on line 66.


user error: You have an error in your SQL syntax near 'n, aggregator2_item a SET n.promote = 1 WHERE a.nid IN (222,221) AND a.nid = n.n' at line 1

query: UPDATE node n, aggregator2_item a SET n.promote = 1 WHERE a.nid IN (222,221) AND a.nid = n.nid AND a.fid = 208 in /var/www/html/includes/database.mysql.inc on line 66.


warning: Cannot modify header information - headers already sent by (output started at /var/www/html/includes/common.inc:384) in /var/www/html/includes/common.inc on line 192.

Comments

ahwayakchih’s picture

ahwayakchih commented
Assigned: Unassigned » ahwayakchih

I've just commited changes which should fix this. Now it uses different SQL commands and should be more compatible with PostgreSQL and older MySQL versions :).

tng@neuralgourmet.com’s picture

tng@neuralgourmet.com commented

Thanks. I'm crushed for time this week but I'll check it out later on and let you know how it's working.

ahwayakchih’s picture

ahwayakchih commented
Status: Active » Closed (fixed)

Another change was needed, cause i made stupid bug (it promoted items for one feed only at a time ;). Now it should be ok.