AuroraMike
02-19-2005, 08:31 AM
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT c.categoryname, c.categorydesc, c.categoryimg, COUNT(*)
FROM articles_category c
LEFT JOIN articles_article a
ON c.articles_categoryid = a.categoryid
WHERE c.articles_categoryid=5 AND a.draft!='1'
GROUP BY a.articles_articleid ;
mysql error: You have an error in your SQL syntax near ';
' at line 7
mysql error number: 1064
I get the above when I click on a category on the main articles page.
http://www.netflamewar.com/forums/articles.php
The main page comes up just fine but when clicking on a category, that's when I get the above. I'm sure it's a typo but I went over the instructions again and can't find my mistake. Any ideas?
Invalid SQL:
SELECT c.categoryname, c.categorydesc, c.categoryimg, COUNT(*)
FROM articles_category c
LEFT JOIN articles_article a
ON c.articles_categoryid = a.categoryid
WHERE c.articles_categoryid=5 AND a.draft!='1'
GROUP BY a.articles_articleid ;
mysql error: You have an error in your SQL syntax near ';
' at line 7
mysql error number: 1064
I get the above when I click on a category on the main articles page.
http://www.netflamewar.com/forums/articles.php
The main page comes up just fine but when clicking on a category, that's when I get the above. I'm sure it's a typo but I went over the instructions again and can't find my mistake. Any ideas?