1. I have upgrade the hacks and it went smoothly. However i notice it just install on my default style (skin). My second style template its not with the vbarticles templates?
My second style is vbSaint. Any ideas how can i copy those templates from my default style to my another skin?
2. Database error in vBulletin 3.0.7:
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
My www.site.com/forum/ is now unaccessible (db error above). However the articles page and admincp is available.
Hopefully you can help me to fix the errors above. Your assistance is highly appreciate on this issue.
Thanks.
1. I have upgrade the hacks and it went smoothly. However i notice it just install on my default style (skin). My second style template its not with the vbarticles templates?
My second style is vbSaint. Any ideas how can i copy those templates from my default style to my another skin?
Try to use the default style in your user settings and then try to install the templates again.
Hi Lizard,
Im using the default style, how can i re-install the templates again? By running the upgrade files?
My board is now unaccessible with the db errors. Hope someone can help me fix those. :(
LOTR, you didn't by any chance install the Latest Articles on Forum Home add-on did you ?
Yup... remoce the add-on and works fine now. Thanks.. :)
Cing, by any chance how can i re-install the vbarticles templates on my 2nd style? It didnt overwrite during the upgrade process.
Ah guessed so :)
I will update the add-ons soon. Some will no longer work ( like in your case ;) )
Yep, unfortunately the install script only puts in the templates into the default style set.
For a quick fix to install just the templates on all the other style sets as well, perform the following:
In the install_vbarticles.php file,
Find:
$styleid = $vboptions['styleid'];
at around line 642 of install_vbarticles.php
replace it with
$styleid = X;
where X is the styleid of the Style in which you have (non default).