vb.org Archive - Administrative and Maintenance Tools

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - Template Modification System (https://vborg.vbsupport.ru/showthread.php?t=152931)

I can't remember that. But this is what the readme says:

Quote:

The maintenance function 'Rebuild all Styles' MUST NOT be executed when the Plugin System or TMS is disabled!

I guess when uninstalling the styles will also be rebuild somehow, so maybe that is the cause. He should post some errors if he wants support, or maybe he fixed it already.

Update
TMS 1.2.0 Beta 3 is now available.

This is the first version that is (well , should ;)) be fully compatible with vBulletin 4, at least vBulletin 4.1.5 is required.

TMS 1.2.0 has one major new feature over the previous release:
The possibility to modify style variables via AJAX right from the style manager while editing a template.

If there are bugs please let me know.

Hi Andreas, i take it on vb3.8.x we'll not loose anything with just import with overwrite?

No, you won't loose anything but it will not work at all anyway; TMS 1.2.0 Beta 1 or higher requires vB 4.1.5 or higher.

Sorry, i just though it would as this is a vb3.8.x thread :(, ok no worries!

Hi!
I get this when importing the product:

Code:

Database error in vBulletin 4.1.5:



Invalid SQL:



                        SELECT templateid, searchstrregex, replacestr

                        FROM cf_templateedit AS templateedit

                        INNER JOIN cf_templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname)

                        INNER JOIN cf_template AS template ON (template.title=templateeditlocation.template)

                        LEFT JOIN cf_style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))

                        LEFT JOIN cf_product AS product ON (product.productid=templateeditlocation.product)

                        WHERE (NOT ISNULL(style.styleid) OR (templateedit.styleid=-1 AND template.styleid=-1))

                                AND (product.active=1 OR templateeditlocation.product='vbulletin')

                                AND templateedit.active = 1

                                AND template.title IN ('footer')

                                

                        ORDER BY searchorder ASC;



MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german1_ci,IMPLICIT) for operation '='

Error Number  : 1267

I had already tried installing the previous version on my 4.1.5, with the same error.

The product doesn't show in product manager, cannot uninstall...

Thanks for any help :up:

Andreas thanks for the update, been waiting for a wile for this to get to 4.x.

Now I can make all my edits, and make this week even better then the last.

Quote:

Originally Posted by fcherub (Post 2247969)

Illegal mix of collations [...]

This Add-on is unsupported except for proven bugs.

However you will find dozens of threads if you search for that error message on vbulletin.com/vbulletin-germany.com.
In a nutshell: Your database is inconsistent, fix it.

Ok, thank you, I'll have a look :up:

======================================
Edit: in case this could help those non-technical users like me getting that collation error and wishing to uninstall,

just DROP tables 'templateedit' and 'templateditlocation' using Phpmyadmin,

also delete fields:

'templateeditlist' from the 'style' table
and
'edited' from the 'template' table

Then delete the uploaded files.

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 (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete 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.01625 seconds Memory Usage 1,740KB 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 (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: