PDA


View Full Version : MySQL error after adding first link


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.

Brian
08-26-2005, 02:31 PM
Have you modified the files at all? There's no way I can think of that you should be able to get an error like that. You may want to try saving one of your directories in the admin cp though to be sure that the directory cache is updated.

theguru
08-26-2005, 06:35 PM
Thanks Brian,
No I hadn't modified any of the files yet. What I did end up doing though was created a second directory and mark it as Private ... after that it worked :)