i-Symbian.Com
02-27-2005, 02:33 PM
I tried to install this hack addons, to display articles on FORUMHOME but I get the following error :
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT a.title, a.articles_articleid, a.icon, SUM(r.rating) / COUNT(r.rating) avg
FROM articles_article a
LEFT JOIN articles_rating r
ON a.articles_articleid = r.articleid
WHERE a.featured=1
GROUP BY a.articles_articleid
ORDER BY RAND()
LIMIT
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8
mysql error number: 1064
I downloaded the instruction from :
https://vborg.vbsupport.ru/showpost.php?p=593923&postcount=65
Followed all the instructions but got the above error. Any idea?
My vBarticle page is at : http://www.i-symbian.com/forum/articles.php
Any concerns are appreciated.
Rgds
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT a.title, a.articles_articleid, a.icon, SUM(r.rating) / COUNT(r.rating) avg
FROM articles_article a
LEFT JOIN articles_rating r
ON a.articles_articleid = r.articleid
WHERE a.featured=1
GROUP BY a.articles_articleid
ORDER BY RAND()
LIMIT
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8
mysql error number: 1064
I downloaded the instruction from :
https://vborg.vbsupport.ru/showpost.php?p=593923&postcount=65
Followed all the instructions but got the above error. Any idea?
My vBarticle page is at : http://www.i-symbian.com/forum/articles.php
Any concerns are appreciated.
Rgds