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?
At that line :
GROUP BY a.articles_articleid ;
Remove the
;
Been brought up before.
Change that for a quick fix for v1.0.2.
v2.0 won't have that :)
thanks. I usually do a search before I ask but it's almost 4am where I'm at. ;-)
off topic but is there a way for users to submit an article other than giving them access to the admincp? Am I missing something basic? Right now I'm having ppl email it to me and then I copy paste but it sure would be nice if there were some interface on the articles page or in the usercp so they would get the same WYSIWUG editor that's in the admincp but then they can write/submit there @ the site versus emailing something.
No way for v1.0.2
Again, that's possible in v2.0 :D