After edit(update) node with leech-feed i see a next error

user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( tn.tid SEPARATOR ',' ) AS tids FROM l query: SELECT li.nid, GROUP_CONCAT( tn.tid SEPARATOR ',' ) AS tids FROM leech_news_item li LEFT JOIN term_node tn ON tn.nid = li.nid WHERE li.fid = 86 GROUP BY nid in /home/u37190/traveldaily.ru/www/includes/database.mysql.inc on line 172.

MySQL version 4.0.28 PHP 4.4.4

What is it?

Comments

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Assigned: Unassigned » aron novak
Status: Active » Closed (won't fix)

GROUP_CONCAT( tn.tid SEPARATOR
This is the problematic part.
Here you can find the root of this error message http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html :
GROUP_CONCAT() was added in MySQL 4.1.
So if you send me an equivalent SQL statement of this for 4.0.x:

SELECT li.nid, GROUP_CONCAT( tn.tid SEPARATOR ',' ) AS tids
                        FROM {leech_news_item} li
                        LEFT JOIN  {term_node} tn ON tn.nid = li.nid
                        WHERE li.fid = %d
                        GROUP BY nid

then I'll include your solution. We cannot take big efforts to make leech compatible with a product that its lifecycle is over (http://dev.mysql.com/doc/refman/4.1/en/index.html)