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

sodani’s picture

Status: Active » Closed (fixed)