theguru
08-26-2005, 10:33 AM
I installed the Links module and all looked good untill I added my first link via the AdminCP. Then I got this from the public side -
Invalid SQL:
SELECT links.*, links_categories.title FROM vb3_links AS links
LEFT JOIN vb3_links_categories AS links_categories ON (links.catid = links_categories.catid)
WHERE valid = 1 AND suspended = 0 AND links.catid NOT IN ()
ORDER BY dateline DESC
LIMIT 5
I'm picking it's the 'NOT IN ()' but what causes it and where in the code do I find it? or fix it?
Thanks in advance.
Invalid SQL:
SELECT links.*, links_categories.title FROM vb3_links AS links
LEFT JOIN vb3_links_categories AS links_categories ON (links.catid = links_categories.catid)
WHERE valid = 1 AND suspended = 0 AND links.catid NOT IN ()
ORDER BY dateline DESC
LIMIT 5
I'm picking it's the 'NOT IN ()' but what causes it and where in the code do I find it? or fix it?
Thanks in advance.