vb.org Archive - Few Errors: Styles, Forum

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vbArticles (https://vborg.vbsupport.ru/forumdisplay.php?f=106)

- - Few Errors: Styles, Forum (https://vborg.vbsupport.ru/showthread.php?t=76753)

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.

Quote:

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:

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 ).

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 :)

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

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

Great cing.. i look into that soon :)

Thanks guys.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01259 seconds Memory Usage 1,735KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: