hi,

i just installed usercontent on 2 different drupal sites i run.
for one of them, it worked. for the other, i get this when i view a user page:

user warning: You have an error in your SQL syntax near '(SELECT nid, NULL AS cid, title AS txt, created, type FROM node ' at line 1 query: (SELECT nid, NULL AS cid, title AS txt, created, type FROM node WHERE uid=2 AND type = "image"AND status=1 ORDER BY created DESC LIMIT 9) UNION ALL (SELECT nid, NULL AS cid, title AS txt, created, type FROM node WHERE uid=2 AND type = "story"AND status=1 ORDER BY created DESC LIMIT 9) UNION ALL (SELECT nid, NULL AS cid, title AS txt, created, type FROM node WHERE uid=2 AND type = "video"AND status=1 ORDER BY created DESC LIMIT 9) UNION ALL (SELECT nid, cid, subject AS txt, timestamp AS created, 'Comment' AS type FROM comments WHERE uid='2' AND status=0 ORDER BY created DESC LIMIT 9)ORDER BY type, created DESC in /var/www/html/cms-5.2/includes/database.mysql.inc on line 172.

this in drupal 5.2 and 5.7. the 2 sites have slightly different modules installed, so that must be the problem, but i wonder if anyone knows where to start debugging this - which modules are known to conflict with this one, etc?

thanx,

steev

Comments

pomliane’s picture

pomliane commented
Status: Active » Closed (won't fix)

This version of Usercontent is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.