Closed (fixed)
Project:
Delicious
Version:
5.x-1.3
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
26 Dec 2007 at 16:44 UTC
Updated:
28 Dec 2007 at 16:22 UTC
When I enable the my delicious block, I'm getting the following 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 'LIMIT 0, 3' at line 1 query: SELECT DISTINCT dl.description AS description,du.user,COUNT(*) AS count,dl.href FROM delicious_link dl LEFT JOIN delicious_tag dt ON dl.lid = dt.lid LEFT JOIN delicious_user du ON dl.uid=du.uid LEFT JOIN users u ON dl.uid = u.uid WHERE (1) AND dt.name IN ('credit_cards') GROUP BY dl.description, du.user, dl.href ORDER BY LIMIT 0, 3 in C:\wamp\www\drupal\includes\database.mysql.inc on line 172.
I'm not so great at debugging SQL problems...
Also, I believe in delicious.module:663, it should be:
INSERT INTO {delicious_block} (dbid, title, users, tags, maxentries, display, orderby)...
instead of
INSERT INTO {delicious_block} (dbid, title, users, tags, maxentries)...
I was receiving a complaint about the number of columns not matching.
Comments
Comment #1
sodani commented