vb.org Archive

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)

Andreas 03-16-2009 07:04 AM

It's pretty straightforward:
https://vborg.vbsupport.ru/showthrea...10#post1703410

@redraider
Did you edit Template Modifications using vBulletin 3.8.X and TMS < 1.1.5 by any chance?
If so:
UPDATE templateedit SET styleid = -1 WHERE styleid = 0;
UPDATE templateeditlocation SET addstyleid = -1 WHERE addstyleid = 0;

Kalyse 03-17-2009 08:34 PM

Hello,
Is there a reason that the modifications wouldn't show even though they are marked as active.
I don't understand why none of the template changes are taking effect.

Icy 03-17-2009 11:59 PM

Quote:

Originally Posted by Kalyse (Post 1770703)
Hello,
Is there a reason that the modifications wouldn't show even though they are marked as active.
I don't understand why none of the template changes are taking effect.

By any chance, are you using vB Optimise? You need to flush cache everytime you edit/update something in TMS then :)

analog-x 03-29-2009 03:48 AM

Is this vBulletin 3.5.x compatible?

Andreas 03-29-2009 11:39 AM

No, I'm sorry - vBulletin 3.5.X. doesn't support "always execute" installation code - a feature that is absolutely necessary for TMS.

However, if you don't mind template modifications not being installed/updated automatically upon product installation/upgrade, you could try to run in with 3.5 - it should basically work.

analog-x 03-29-2009 09:53 PM

Quote:

Originally Posted by Andreas (Post 1779646)
No, I'm sorry - vBulletin 3.5.X. doesn't support "always execute" installation code - a feature that is absolutely necessary for TMS.

However, if you don't mind template modifications not being installed/updated automatically upon product installation/upgrade, you could try to run in with 3.5 - it should basically work.

Ok so what is the earliest version of vBulletin that I can upgrade to, before I can use this tool?

going from v3.5.x to v.3.8.x I think is a big jump and I'm just worried about the things that will break and I wont be able to repair.

dartho 03-29-2009 10:46 PM

from the first post, 3.6
Quote:

Originally Posted by Andreas
vBulletin Compatibility
Those asking for a specific vBulletin 3.6.X, 3.7.X or 3.8.X release will be feathered, tared and blown up - this is the release your are searching for.


PGAmerica 04-12-2009 02:10 AM

When I try to install this, I get the following error:
Code:

Database error in vBulletin 3.8.2:
Invalid SQL:
            SELECT templateid, searchstrregex, replacestr
            FROM templateedit AS templateedit
            INNER JOIN templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname)
            INNER JOIN template AS template ON (template.title=templateeditlocation.template)
            LEFT JOIN style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))
            LEFT JOIN 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 (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Error Number  : 1267
Request Date  : Saturday, April 11th 2009 @ 10:08:24 PM
Error Date    : Saturday, April 11th 2009 @ 10:08:25 PM
Script        : http://www.christianfunforums.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.christianfunforums.com/forums/admincp/plugin.php?do=productadd
MySQL Version : 5.1.30

Ideas?

Videx 04-12-2009 02:43 AM

How can anyone with 314 posts not read back before posting a question like that? Did you just dive into this mod and try to install it without bothering to read the earlier posts?

PGAmerica 04-12-2009 03:41 AM

35 pages. I did a search in this thread and read through many posts stating the same thing. Instead of just chewing me out, how about telling me which post you are referring too? I read about people being told to fix their database over and over again, but I saw nothing about how to do it. My forums have been working perfectly. I find it hard to believe that the database is screwed up.


All times are GMT. The time now is 06:43 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01800 seconds
  • Memory Usage 1,745KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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