When I tried putting the Featured Articles hack in, I get this database error on my forumhome:
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
Any ideas?
The settings are saved already right ?
I've removed the limit, line and it seemingly works..but I'm sure I need it. Now I have an issue with the arcitles icon's not showing up, and I assume that is because its calling a template that doesn't exist: