Few Errors: Styles, Forum

Cing,

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.

PHP Code:

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.

[Lizard King]

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.

[LOTR]

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.

[cinq]

LOTR, you didn't by any chance install the Latest Articles on Forum Home add-on did you ?

[LOTR]

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.

[cinq]

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:

PHP Code:

$styleid = $vboptions['styleid']; 


at around line 642 of install_vbarticles.php

replace it with

PHP Code:

$styleid = X; 


where X is the styleid of the Style in which you have (non default).


Now go to this url in your browser:

http://www.yoursite.com/forum/adminc...english&step=7

It will then put in the templates into the other non default style set.
You have to repeat this for every style you have ( which is non default ).

[Lizard King]

cinq I didn't install this hack but if a board has multiple styles around 6-7 the installation of the styles will be pain in the ass

[cinq]

Thanks for your feedback Lizard, I am actually writing a script to add the templates to all styles.

[LOTR]

Thanks lizard for the confirmation, i just thought i did something wrong during the upgrade

Great cing.. i look into that soon

Thanks guys.