Template Modification System

[Andreas]

It's pretty straightforward:
https://vborg.vbsupport.ru/showthread.php?p=1703410#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]

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]

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]

Is this vBulletin 3.5.x compatible?

[Andreas]

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]

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]

from the first post, 3.6
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]

When I try to install this, I get the following error:
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.30Ideas?

[Videx]

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]

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.

[Videx]

When you search this mod for "illegal collations", what do you see? Obviously your post is at the top, but surely you must see mine below that?

I agonized over that problem for weeks. I'm still a little pissed about it I guess, sorry. Especially if people are going to keep posting the problem even after I posted a solution for it.

[PGAmerica]

There is no reason to get angry. I saw your post. Your solution requires that I backup my 450MB database, run a "search and replace" and then re-upload the 450MB database. This is an impossible solution for me. There is just no way to do that on such a large, large, large database.

[dartho]

Look here: http://www.phpwact.org/php/i18n/utf-8/mysql

[PGAmerica]

Thank you dartho. That was very helpful. I also found that I can change the overall characterset in phpMyAdmin using the "operations" tab.

[TheLastSuperman]

wtf... out of line a bit I might be but rest assured your sanity is safe with me...

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?

How can someone w/ 500+ not understand the need for tact on here in regards to coders simply not understanding the inner workings of every aspect of every coding language nor the need to read 500 posts or 800 pages to find an answer that should be in the first post to begin with? - We all are trying, even the most experienced :p

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.

Videx is not saying your db is messed up, from the admin panel disable the mod. What he should of said is your DB's collation is not the same, just like the error reads:

MySQL Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Error Number : 1267

Note the red.

Now you can try changing the collation via phpmyadmin if you have that or another alternative. Backup your DB before doing anything in any editor etc. If it works fine then uninstall the currently disabled mod, leave any files if present but install it again via the product etc, then it should work.

S-MAN

[Videx]

This is an impossible solution for me. There is just no way to do that on such a large, large, large database.I'm not sure why you feel there's no way to restore your db (I assume you're backing it up regardless).

But if that's the case, I also gave a link to a programmatic solution. However, that was taking forever for me as it would fail every few lines, and taking the time to make the corrections manually got onerous really fast.

[Andreas]

Erm ... you don't have to dump the whole database just to fix a couple illegal collations.

just take a look at your DB, find out which collation is being used most often, adjust the new tables/fields that generate error accordingly and you're done.

[Videx]

adjust the new tables/fields that generate error accordingly and you're done.You almost make that sound easy. But where were you when I was trying to fix mine? I would have gladly given you access to adjust these fields for me. :)

Fact is, in my case about 80 tables were different collations, and after sitting down one day and manually changing each one in PHPMyAdmin, I discovered that only changes the tables, not the fields within! A real PITA that hadn't bothered me at all until I tried to install this mod.

[TaMpE]

am I limited to editing only these templates? :(

https://vborg.vbsupport.ru/external/2009/04/21.png

I'm trying to edit showthread through TMS.

EDIT: I just read that I can onyl use TMS on templates I already edit so if I already manually edit the template I want why am I also adding that edits in TMS? I'm confused.

and do I always have to edit manually first to make it appear in the drop down list of TMS then change the one I manually edited back to the default and then add the edits in TMS? Someone share me how you do it.

[slyreptile]

am I limited to editing only these templates? :(

https://vborg.vbsupport.ru/external/2009/04/21.png

I'm trying to edit showthread through TMS.

EDIT: I just read that I can onyl use TMS on templates I already edit so if I already manually edit the template I want why am I also adding that edits in TMS? I'm confused.

and do I always have to edit manually first to make it appear in the drop down list of TMS then change the one I manually edited back to the default and then add the edits in TMS? Someone share me how you do it.

In your Template Modifications Manager, select Add Template-Modification under the MASTER STYLE dropdown box. This allows you to create the template edit for all styles without actually manually editing any template beforehand.

[dartho]

@TaMpE - those templates listed are different from the default vBulletin templates, I would assume you have a non-default style installed. If you wish to use TMS to further modify them, you can do so in that section.

If you wish to use TMS modify a template which is default (and as such not listed under the styles tree), you do so under the MASTER style in TMS. Any such modification will then be inherited by custom styles.

When I installed TMS, I went through all my non default templates and created TMS rules to make the modifications for me, and then reverted all my templates. My entire sites style is the result of TMS rules only applied to the default style - no actual direct template edits.

[voter]

Any idea how to correct this.
It appears when I am trying to import the xml of package.

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT templateid
FROM vbtemplate
WHERE
edited=1
AND title IN ('footer');

MySQL Error : Unknown column 'edited' in 'where clause'
Error Number : 1054
Request Date : Monday, April 20th 2009 @ 05:41:58 AM
Error Date : Monday, April 20th 2009 @ 05:41:59 AM
Script : ...plugin.php?do=productimport
Referrer : ...plugin.php?do=productadd
Classname : vB_Database_MySQLi
MySQL Version : 5.0.75-community-log

I just added "edited" field into template table of database as THINYINT with size 1 and default value 0. Then installation went correctly - but I don't more need this plug - so unintslling

[TaMpE]

@TaMpE - those templates listed are different from the default vBulletin templates, I would assume you have a non-default style installed. If you wish to use TMS to further modify them, you can do so in that section.

If you wish to use TMS modify a template which is default (and as such not listed under the styles tree), you do so under the MASTER style in TMS. Any such modification will then be inherited by custom styles.

When I installed TMS, I went through all my non default templates and created TMS rules to make the modifications for me, and then reverted all my templates. My entire sites style is the result of TMS rules only applied to the default style - no actual direct template edits.

In your Template Modifications Manager, select Add Template-Modification under the MASTER STYLE dropdown box. This allows you to create the template edit for all styles without actually manually editing any template beforehand.

Thank you so much for helping me out. It's going to be a really nice plugin if it allows us to edit all at once! lol

[oskqqqq]

mod of the year...

[Mrdby]

I was trying to remove and got this.

* Removing old Template-Modifications ... Done!
* Removing all Template-Modifications from Templates ...
Warning: Unknown([path]/includes/adminfunctions_templateedits.php): failed to open stream: No such file or directory in [path]/admincp/plugin.php(1522) : eval()'d code on line 10
Fatal error: (null)(): Failed opening required '/hsphere/local/home/*****/*****.net/forum/includes/adminfunctions_templateedits.php' (include_path='.:/hsphere/shared/apache/libexec/php4ext/php/') in /hsphere/local/home/****/****.net/forum/admincp/plugin.php(1522) : eval()'d code on line 10

and the screen hasn't refreshed yet.

[ragtek]

it seems that you have deleted adminfunctions_templateedits.php and it's needed for the de installation

[fukdawrld]

Thanks for this great hack but it is causing an error on my board. When I try to edit a template or use the style manager my screen looks like this

https://vborg.vbsupport.ru/external/2009/05/36.png


When I disable the TMS it looks normal. I tried reinstalling and reupping the files but that didn't work. Thanks in advance for your help.

[Andreas]

It seems like you are using a strange/uncommon content compression configuration

Check php.ini/.htaccess settings
zlib.output_compression
zlib.output_handler
output_handler
output_buffering

Check settings for apache modules mod_deflate, mod_gzip

Check vBulletin GZip setting

GZip really should be turned on only once.

[eXoOutsider]

Hey, this mod has been amazing, life saver for me thus far. But now I have a problem, the navbar template is jsut gone from the mod. Anyone have any idea? It's just navbar under navigation/breadcrumbs, not navbar_link or anything

[dancue]

When using IE I noticed that the inactive edits are not crossed out. I just noticed.

[Black Tiger]

Which version of IE are you using?

[SirHappy]

thx. works in 3.8.3.

[Andreas]

When using IE I noticed that the inactive edits are not crossed out. I just noticed.
Yep. IE is dumb and does not understand CSS properly :)
That's the reason why [X] is added for this browser instead.

[Shevko]

Works great..

[Harley D]

I love the mod but found it to be giving me server configuration errors and low memory errors, that went away once I deactivated.

Its HIGHLY possible that its conflicting with another mod... I researching that possibility now.

VB 3.8.3
PHP Version 5.2.9

[bada_bing]

It seems like you are using a strange/uncommon content compression configuration

Check php.ini/.htaccess settings
zlib.output_compression
zlib.output_handler
output_handler
output_buffering

Check settings for apache modules mod_deflate, mod_gzip

Check vBulletin GZip setting

GZip really should be turned on only once.

Andreas,

I am having the same issues and I did validate that Gzip is no enabled withing VB. My site is also hosted in a Windows Server. If I disable this plugin my templates display correclty but I have vbspell that relies on this plugin...

[Andreas]

Please post the values of the mentioned PHP settings.

[bada_bing]

Please post the values of the mentioned PHP settings.

What values and how can I get them.. Sorry

[Andreas]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1876145&postcount=536" target="_blank">https://vborg.vbsupport.ru/showp...&postcount=536</a>

[bada_bing]

https://vborg.vbsupport.ru/showpost.php?p=1876145&postcount=536

Where can I look to get those exact perameters

[fly]

Where can I look to get those exact perameters

I'd guess you could probably get them from phpinfo

[Andreas]

Where can I look to get those exact perameters
In the place they are defined, eg. php.ini, httpd.conf, vHost configuration or .htaccess :)

Where they are defined exactly depends on yoru configuration, so you (so your hoster) is the only one who could tell where to look.

[AfterWorldForum]

Loving this mod. I really really hope that this will still work with vB4, as this mod is a time-saver, and will be a major factor in succesfully migrating mods and styles to VB4.

Thanks Andreas :)

[DiGiSYS]

Hi there.

i want add this product https://vborg.vbsupport.ru/showthread.php?t=222190
but win i upload the product i have this

Error de Base de Datos en vBulletin 3.8.4:

Invalid SQL:

SELECT templateid
FROM p_template
WHERE
edited=1
AND title IN ('footer');

MySQL Error : Unknown column 'edited' in 'where clause'
Error Number : 1054
Request Date : Monday, November 2nd 2009 @ 12:33:44 AM
Error Date : Monday, November 2nd 2009 @ 12:33:45 AM
Script : http://puritanias.com/.../plugin.php?do=productimport
Referrer : http://puritanias.com/.../plugin.php?do=productadd
IP Address : 170.51.245.31
Username : DiGiSYS
Classname : vB_Database
MySQL Version : 5.0.81-community-log



i try uninstall TMS 1.1.5 but have same error in DB :confused:

Error de Base de Datos en vBulletin 3.8.4:

Invalid SQL:

SELECT templateid
FROM p_template
WHERE
edited=1;

MySQL Error : Unknown column 'edited' in 'where clause'
Error Number : 1054
Request Date : Monday, November 2nd 2009 @ 12:29:44 AM
Error Date : Monday, November 2nd 2009 @ 12:29:44 AM
Script : http://puritanias.com/.../plugin.php?do=productkill
Referrer : http://puritanias.com/.../plugin.php?do=productdelete&productid=tms&s=
IP Address : 170.51.245.31
Username : DiGiSYS
Classname : vB_Database
MySQL Version : 5.0.81-community-log

[Andreas]

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


There you go - you most likely executed that function with either TMS or Plugin-System disabled => DB corrupted.

Best advice I could give is to reload your backup, sorry.

[DiGiSYS]

:D my backup its too old... 9 days ago... i will try 1st delete and reinstall all styles or upload only template table... and post results

[Black Tiger]

Found a little problem with TMS and don't know how to fix it.

I've got the template "ad_footer_end" customized in my main style.

Now I want to make a little temporary adjustment to it, but now te problem occurs. I use TMS, select the "ad_foter_end" template and choose to "view content", but I only get an empty box. Is does not show the adjustments made.

Now I just put in the main box the text which is in the original ad_footer_end and in the replacement box the temporary replacement and this works on my forums. But when I use the "test template modifications" option the "Master" will display the "0 Edit" function, which means there is a problem.
106178

But on the bottom of this test page, the "Checking Template-Modifications: vBulletin 3" (my main style) gives the OK sign.
106179
I guess it hass something to do with the fact that the ad_footer_end templates is integrated in the footer template with the $ad_footer_end variable and I even changed that position in the original footer template. I put it a bit lower.

But seems to me this is not oke, the Master should give an "oke" just as the main style at the bottom does.
Furthermore the picture which I added on the left side of the banner in the footer, contains no border, but on the right side it does (as it should), see my forums at satellitefun.org to see what I mean.

Help?

[Andreas]

The ad_footer_end template in MASTER style is always empty ... so there is really nothing you could search and replace there?

[Black Tiger]

Standard it's empty indeed, but they are ment to put some ad in there, which I did.

And now the search and replace funktion of TMS is not working correctly, because I do a search of text, which TMS thinks is not present, and replace it with text which is present.

Which causes the template test to give a failure like in the screenshot.
If I leave the search window empty and only put the replace part in there, I get my banner numerous times.
So something is really wrong there. It should be possible to also use that template in TMS, shouldn't it?

I would like the border around that picture and I would like the error in the TMS test templates funktion to be gone.

Maybe I can solve it by doe a TMS search/replace on the footer template, which has the ad_footer_end template variable included and it will work, but still I find it strange then that the ad_footer_end template (and probably the others too) can't be used with TMS.

[TheSupportForum]

will this mod be introduced for vbulletin 4 ?

[Andreas]

So something is really wrong there. It should be possible to also use that template in TMS, shouldn't it?

Yes - for a Non-Master Style.

So if you customized the template and added foo in there you can use TMS to replace that foo with bar.

If you add a modification for this template in MASTER style (where it will always be empty) you will obviously get an error when you test the modification (searching for smth. in an empty template does fail).

[Black Tiger]

Ah oke, thank you Andreas, now I understand.
I need the change in all styles, so I would have to do them seperately in all styles then.

In that case I can better use TMS in the Master Style on the Footer template and add the images around the $ad_footer_end variable because that works also, and without the error notice.

Thank you for your explanation and your patience with me.

[ndahiya]

this mod appears to work in vb4 without any change, thought a lot of the mods have to reapplied (coz of code changes, search strings can not be found).

[fly]

Aww man, you had to install it on 4.0? I was hoping Andreas would be able to slip this into production. :(

[AWJunkies]

This should be standard in vBulletin for sure. So we 100% this works in 4.0 any confirmation from developer?

[lgnd]

It's working on my test board but it's recommended to completetly uninstall before upgrading to 4.x.x I had problems when upgraded my test board with TMS installed even with removed template mods.

The best mod for vB ever!

[Videx]

It's working on my test board but it's recommended to completetly uninstall before upgrading to 4.x.x I had problems when upgraded my test board with TMS installed even with removed template mods.

The best mod for vB ever!yes, I understand I'll have to disable hooks entirely in the config.php file when upgrading. But if you remember what the troubles were and how you fixed them, could you let us know? Had you disabled hooks?

[lgnd]

I completly uninstalled TMS before the upgrade. There are few files you'll have to manually delete after uninstallation, check the readme file. First time I forgot to delete those files and it caused problems after the upgrade on my test board.

So I did my template mods in my test enviroment with tms and after upgrading my live site I imported the template mods from the test forum into the live forum tms.

Side note the branding notice is not visible in the footer I hope Andreas will fix this problem!

[Videx]

I completly uninstalled TMS before the upgrade. There are few files you'll have to manually delete after uninstallation, check the readme file. First time I forgot to delete those files and it caused problems after the upgrade on my test board.That's just odd. Why would a few files sitting there, being called by nothing, cause trouble? Oh well, I'll do as told.

[fly]

I fear that I have done something very, very wrong. This mod seems to work great on vB4. However, I just disabled and then enabled this hack. After re-enabling it, I get nothing but a blank page in the admincp.

I'm trying not to panic, but can anyone help?

edit: Odd. It was suhosin, if anyone cares. I made some changes to it yesterday. I guess TMS didn't like the changes...

[derrene]

1.1.5 works on 4.0.2

after modification or adding new

click "rebuild all template modifications"
below under the table

[fly]

1.1.5 works on 4.0.2

after modification or adding new

click "rebuild all template modifications"
below under the table

It doesn't work on CSS templates.

[demonfatal]

When I want uninstall it I get this sql error:
----------------------------------------------------------
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT templateid
FROM template
WHERE
edited=1;

MySQL Error : Unknown column 'edited' in 'where clause'
Error Number : 1054
Request Date : Monday, March 8th 2010 @ 08:14:10 AM
Error Date : Monday, March 8th 2010 @ 08:14:11 AM
Script : http://www.XXXXXXXXXX/forums/admincp/plugin.php?do=productkill
Referrer : http://www.XXXXXXXXX/forums/admincp/plugin.php?do=productdelete&productid=tms&s=
IP Address : XXXXXXXXXXXXX
Username : XYX
Classname : vB_Database
MySQL Version : 5.0.90
---------------------------------------------------

Any help will be appreciated.

[Black Tiger]

I can't get this working on v4.02.

When importing 1.1.5 eng then the following error occurs:
Warning: require_once([path]/includes/adminfunctions_templateedits.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/adminfunctions_plugin.php(450) : eval()'d code on line 24

Fatal error: require_once() [function.require]: Failed opening required '/home/username/domains/mysite.org/public_html/includes/adminfunctions_templateedits.php' (include_path= '.:/usr/local/lib/php') in /home/username/domains/mysite.org/public_html/includes/adminfunctions_plugin.php(450) : eval()'d code on line 24
That's odd because the adminfunctions_templateedits.php is present in the /includes directory.
Any idea?
(I added a space here on the forums after include_path) so the text width fits better.

Additional info: Seems I also cant view version_tms.php with the browser get a 404 while the file is present. The normale vbulletin files will give me a blank screen but no error notice, so those work as they should be.
Very strange.

[lgnd]

Upgraded my forum from 4.0.1 to 4.0.2 PL1 yesterday and TMS is working with css files as well.

[Black Tiger]

Problem of mine is gone with the wind. The main admin imported the mod without any problems.
But I keep wondering why I got the error.:)

[lgnd]

I got the following error during working with TMS

Warning: Invalid argument supplied for foreach() in [path]/includes/adminfunctions_template.php on line 913

Found the solution with searching the vb forum:

Store CSS Stylesheets as Files? = No

TMS is working with CSS without any issues with 4.0.2.PL1 at my forum.

[Black Tiger]

Tank you Ingd. But I only got the message during installation. When the other admin imported it, he did not change anything, just imported it the same way I did and it worked without problems.
But maybe your answer can help others with a kind like problem, thank you.

[|Jordan|]

Something wierd is happening. All my template edits for postbit_legacy dont work but everything else is fine and my site is set up to use the legacy postbit. I haven't edited the style, TMS says that the template modification works - but yet it doesnt show up on my site. I tried rebuilding templates and rebuilding template modifications and it doesnt fix it.

EDIT: Nevermind, i found it. There was a missind </if> tag in one of my template edits.

[HydraulicJack]

I'm interested in the 4.x version of this product so I hope you'll let me know when it's available. Thanks!
HJ

[analog-x]

Sorry Posted in the wrong thread.

[Andreas]

I'm interested in the 4.x version of this product so I hope you'll let me know when it's available. Thanks!
HJ
As soon as the necessary hook becomes available (again).

[Ben Wilkins]

Installed on 3.8.3 and get an error:

Unable to add cookies, header already sent.
File: /home/benjwilkins/domains/benjwilkins.co.uk/public_html/forums/includes/class_core.php
Line: 3277

[Vitaly]

As soon as the necessary hook becomes available (again).

Andreas, can you make a short manual to patch existing 4.0.3PL1? Which hooks/files cause problems?

[AfterWorldForum]

Andreas, can you make a short manual to patch existing 4.0.3PL1? Which hooks/files cause problems?

I would also appreciate this :)

[DragonMasterNYC]

I just cross checked all the hooks in the product xml and vB4.0.3 PL1. They are all there, but that doesn't mean they all work the way they used to. It would we nice to find out which one is the problem. After that it's only converting the code to work on vB4.

Well I've gotten it to work on 4.0.3 PL1 for now still some bugs to iron out, but it works. Andreas I will gladly send you the files so you could finish the edits.

[IrPr]

Any update for VB4?

It would be greatly appreciated

[fly]

FWIW, it works on vB4. Just doesn't work for CSS templates...

[eglyntine]

Definitely would love to know when this is fixed for latest vb4 patch. I can't live without this Add-on :'(

[Calystos]

Agreed, this addon was awesome for addons/plugins without messing about. Can't wait til a version is out for 4.x :D

[Harley D]

I'm using the EXCELLENT Mod in (vBulletin 4.0.7).
Now that said I haven't completely tried EVERY feature, However I am able to manually add Template Modifications without any issues thus far.

Thanks again for this mod. It is the most valuable mod I have ever used.

[fly]

According to Andreas not everything works. The only thing that I've seen that doesn't work is trying to use TMS for CSS templates.

[Bravo]

When I want uninstall it I get this sql error:
----------------------------------------------------------
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT templateid
FROM template
WHERE
edited=1;

MySQL Error : Unknown column 'edited' in 'where clause'
Error Number : 1054
Request Date : Monday, March 8th 2010 @ 08:14:10 AM
Error Date : Monday, March 8th 2010 @ 08:14:11 AM
Script : http://www.XXXXXXXXXX/forums/admincp/plugin.php?do=productkill
Referrer : http://www.XXXXXXXXX/forums/admincp/plugin.php?do=productdelete&productid=tms&s=
IP Address : XXXXXXXXXXXXX
Username : XYX
Classname : vB_Database
MySQL Version : 5.0.90
---------------------------------------------------

Any help will be appreciated.

same here, is there anyway to fix?

Edit: NM Got it to uninstall by adding the "edited" field in the template table

[fly]

As soon as the necessary hook becomes available (again).

Any chance that 4.1 has the needed hooks?

[dcuellar]

Any chance that 4.1 has the needed hooks?

And is this hook something that can be manually added?

[Boofo]

And is this hook something that can be manually added?

No.

[dcuellar]

No.

Darn, I guess I'll wait then to upgrade to 4.1 until this mod is working. This is my number 1 priority.

[Andreas]

The required hook is now there, but there is still one bug (http://tracker.vbulletin.com/browse/VBIV-7378) left open that needs to be fixed before TMS can made fully compatible with vB 4.

[dcuellar]

The required hook is now there, but there is still one bug (http://tracker.vbulletin.com/browse/VBIV-7378) left open that needs to be fixed before TMS can made fully compatible with vB 4.

Great. Would this bug have an effect on template edits that were OK before? Am I better off waiting?

[Hostboard]

Waiting on this and the new editor and I can then start thinking about upgrading. thank you for staying on top of this as it should be part of the core system!

[OldSchoolDSL]

The required hook is now there, but there is still one bug (http://tracker.vbulletin.com/browse/VBIV-7378) left open that needs to be fixed before TMS can made fully compatible with vB 4.

Voted for this to be fixed.

I'd really like to see this updated for vBulletin 4.

(Someone recommended this on vBulletin.com )

Tagged

[fly]

Voted for this to be fixed.

I'd really like to see this updated for vBulletin 4.

(Someone recommended this on vBulletin.com )

Tagged

Ah yes, forgot about that voting thing. Thanks for the reminder.

[demonfatal]

Andreas, when this bug will be fixed? We need your tool for vb4!

[fly]

Andreas, when this bug will be fixed? We need your tool for vb4!

No sense in bothering him, it isn't up to him. If you want it fixed, vote for it please.

[COL NIL SATIS]

tagged

[lgnd]

Voted! The best mod ever! Hope you can make it work for vb4 sooner or later! Thanks for your efforts!

[Mark4865]

Any news on when the update will be available for 4.1.1

[toon79]

Does anyone know how to use the TMS to add styles to the additional.css?

As the file is blank I have nothing to paste code after or before?

[fly]

Does anyone know how to use the TMS to add styles to the additional.css?

As the file is blank I have nothing to paste code after or before?

At least on vB4, TMS doesn't work with the CSS templates. Were there CSS templates in 3.x? I can't remember.

[Andreas]

Any news on when the update will be available for 4.1.1
As soon as possible after vBulletin Solutions, Inc. has fixed the bug that prevents this Add-on from being made compatible with vBulletin 4 (http://tracker.vbulletin.com/browse/VBIV-7378).

At least on vB4, TMS doesn't work with the CSS templates. Were there CSS templates in 3.x? I can't remember.
It does work, you just have to rebuild styles afterwards as it does not update the timestamp (due to it not being existent in vB 3).

[fly]

^Oh! Good to know!

[Phaedrus]

Where is this voting on vbulletin.com that they are talking about? There are Template modification systems in vb4, but none as good as this one.

*edit: I found it, and voted for it. Come on... we need this thing people go and vote.

[Videx]

*edit: I found it, and voted for it. Come on... we need this thing people go and vote.Nice of you to give the link then. :)

After updating to 4.1.2 and seeing most all my edits carried over, I'm wondering if this isn't actually included in vb now? Maybe not, as I don't have any styles that aren't parented to the default style.

[Phaedrus]

Nice of you to give the link then. :)

After updating to 4.1.2 and seeing most all my edits carried over, I'm wondering if this isn't actually included in vb now? Maybe not, as I don't have any styles that aren't parented to the default style.

Actually it's on the side next to the reported bug, it's been linked to several times on the thread.

[Simon Lloyd]

Hi i'm using vb3.8.6, i currently have tons of manual template modifications, there's no way i can revert all those templates and then add them to this system, i want to use this system as it will be easier to keep track of the modifications in future, could someone tell me what i need to do to keep ALL my current edits but have them managed by this system so i can revert the templates?

[Phaedrus]

Hi i'm using vb3.8.6, i currently have tons of manual template modifications, there's no way i can revert all those templates and then add them to this system, i want to use this system as it will be easier to keep track of the modifications in future, could someone tell me what i need to do to keep ALL my current edits but have them managed by this system so i can revert the templates?

Personally I think this mod is worth it. I even paid to remove the links in the footer.

It will make it so you can upgrade without having to revert, save, etc. modifications you make to the templates as they are made in a "Master Template" that will simply apply the changes you make at upgrade. It makes upgrading simple and quick. As long as you are in the 3.x.x version you will have the easiest upgrades you will ever have. If you have many styles and mods this is the mod for you.

What I would do is take each modified template and copy them into a file (you can export them but then you'd have to open and read them to do this), print them out and apply them in the Master Template which copies all the modifications to all the styles. Once you have it done, you are golden.

[Simon Lloyd]

So you are saying that i DO have to find every modification i've ever done, save them seperately . revert the templates and then add all those back?? that would be weeks of work as i have made many many changes over the years.

[fly]

So you are saying that i DO have to find every modification i've ever done, save them seperately . revert the templates and then add all those back?? that would be weeks of work as i have made many many changes over the years.

That's exactly what you'd have to do. Don't you essentially do that already when you upgrade?

The other option is to just leave those edits, and use this system going forward...

[Simon Lloyd]

That's exactly what you'd have to do. Don't you essentially do that already when you upgrade?

The other option is to just leave those edits, and use this system going forward...Yes i have done that previously which is why i know it took a very long time :), but you gave me the answer i was looking for, i can simply use this tool for all future edits or modifications.

One last thing, how about if i export the style, install this mod and then re-import the style, would that work?

[fly]

Yes i have done that previously which is why i know it took a very long time :), but you gave me the answer i was looking for, i can simply use this tool for all future edits or modifications.

One last thing, how about if i export the style, install this mod and then re-import the style, would that work?

That wouldn't help you. You need to use the TMS UI to make template edits. The reason for this, if I remember correctly, is that TMS makes the changes to the default (hidden) base templates.

[Phaedrus]

Or you can wait until you upgrade, then make all the changes you need to reapply through the TMS system (this is what I did back in the day, my board is heavily modded). Once you have it done it is sooooo worth it. You will love any future upgrades. Of course, your next upgrade may be to 4.x.x... If such is the case you will want to wait until the product is migrated to the new platform (after the bug is fixed).

[Simon Lloyd]

Or you can wait until you upgrade, then make all the changes you need to reapply through the TMS system (this is what I did back in the day, my board is heavily modded). Once you have it done it is sooooo worth it. You will love any future upgrades. Of course, your next upgrade may be to 4.x.x... If such is the case you will want to wait until the product is migrated to the new platform (after the bug is fixed).Thanks for the reply......i'm NEVER moving to 4.x it's been so buggy and had so many patches and updates in such a short space of time it proves they haven't thought it through properly and use the pying public as their testing ground, it's ridiculous for what they charge.......anyway that discussion is for another time :), i appreciate the feedback and advice from you guys.

[Simon Lloyd]

Does anyone have an idea of how the performance would be or what the implications would be if i was to use the find and replace to find the entire contents of a template and replace the entire contents?

This way i wouldn't have to go through the 40 templates i have modified and countless moddifictions in each to try and find which mods i've made but then could revert the original templates as the whole modified templates would be in the TMS!

[Phaedrus]

Does anyone have an idea of how the performance would be or what the implications would be if i was to use the find and replace to find the entire contents of a template and replace the entire contents?

This way i wouldn't have to go through the 40 templates i have modified and countless moddifictions in each to try and find which mods i've made but then could revert the original templates as the whole modified templates would be in the TMS!

It would make it slightly more difficult to add any mods. You'd have to copy the entire template into the "find" box, then copy the entire modified one into the other box with the "replace with"...

I wonder if it would cause time delays? I can't see how, we have it replacing stuff all the time...

[Simon Lloyd]

I have tried it and it does work but not in my scenario, i have 3 styles none of them child styles, using this it sets up a master and the styles are child styles if i revert the template (normally) it doesn't show up in that particular style in the Template Manager so i have to apply the edit to ALL styles that defeats the object or am i missing something?

Lets say that in Default syle nothing is changed, in Style1 i have added a box to the header template and in Style2 i have added a box and coloured it, if inow copy those header templates and then revert the header templates in those styles and go to Templat manager, when i look at Style 1 and Style2 there there is no longer a Header template which means in order to put my template edits in place i have to edit the master style and it is then applied to all styles????

How would i edit on a per style basis if i have reverted the templates?

[fly]

I have tried it and it does work but not in my scenario, i have 3 styles none of them child styles, using this it sets up a master and the styles are child styles if i revert the template (normally) it doesn't show up in that particular style in the Template Manager so i have to apply the edit to ALL styles that defeats the object or am i missing something?

Lets say that in Default syle nothing is changed, in Style1 i have added a box to the header template and in Style2 i have added a box and coloured it, if inow copy those header templates and then revert the header templates in those styles and go to Templat manager, when i look at Style 1 and Style2 there there is no longer a Header template which means in order to put my template edits in place i have to edit the master style and it is then applied to all styles????

How would i edit on a per style basis if i have reverted the templates?

Because of the way it works, TMS can only apply template changes to the Master template, or templates that have been modified in a child style.

And in answer to your earlier question, you can do 10,000 template edits with TMS and there is ZERO performance impact.

[Phaedrus]

I have tried it and it does work but not in my scenario, i have 3 styles none of them child styles, using this it sets up a master and the styles are child styles if i revert the template (normally) it doesn't show up in that particular style in the Template Manager so i have to apply the edit to ALL styles that defeats the object or am i missing something?

Lets say that in Default syle nothing is changed, in Style1 i have added a box to the header template and in Style2 i have added a box and coloured it, if inow copy those header templates and then revert the header templates in those styles and go to Templat manager, when i look at Style 1 and Style2 there there is no longer a Header template which means in order to put my template edits in place i have to edit the master style and it is then applied to all styles????

How would i edit on a per style basis if i have reverted the templates?

You simply apply it directly in TMS to the style you want to change instead of the Master Template, it would only apply it to that style. Basically, make the change in the Master, then go into each style and revert it in that style only. (At least I think it would work that way, all my changes apply to all my styles.)

[Phaedrus]

Anyway, I upgraded to 4.1.2. I simply disabled the hack, upgraded, then enabled it. It's working for my purposes that way.

[Videx]

Anyway, I upgraded to 4.1.2. I simply disabled the hack, upgraded, then enabled it. It's working for my purposes that way.So maybe you can tell us. Is this built into 4.1 or not? What are the differences?

[Phaedrus]

So maybe you can tell us. Is this built into 4.1 or not? What are the differences?

I ran my test site without the mod and I saw no "Master Template" option, changes are applied directly to styles in 4.1.x. After an upgrade I would have had to revert and change all my styles all over again.

As for the additional.css template that is empty. I was able to add functions to that area simply by leaving the top box empty and selecting "add below" then adding the stuff I wanted into it. It worked swimmingly. I do not know if you want to try to install it directly into any 4.x version, when I tried that on the test site I got some errors and it didn't appear to work. Somehow it worked when I simply enabled an already installed mod.

[Videx]

No, I wasn't asking if you could carry edits from 3.x to 4.x; obviously that would be impossible. I was just wondering about 4.x upgrades. When I went from 4.08 to 4.1.2 it showed me the templates that it could and couldn't merge code and as I recall that's what this mod was supposed to do, but never really did it very well.

[Phaedrus]

No, I wasn't asking if you could carry edits from 3.x to 4.x; obviously that would be impossible. I was just wondering about 4.x upgrades. When I went from 4.08 to 4.1.2 it showed me the templates that it could and couldn't merge code and as I recall that's what this mod was supposed to do, but never really did it very well.

Nah, what this mod does is allow you to create changes to your templates without going into each style and making the changes manually. saving the changes when you upgrade and continuing to apply them. It allows you to test each of the mods you make to the templates to see if they work, and continues to apply them after upgrade without even one change. It does it wonderfully.

I was able to upgrade in 3.x version after version without all the template revert, change. When making changes you simply go to the Master Template this mod adds, you go to the template you are going to change, you add the code it looks for select the "add after" "add before" "delete" "replace" selection and put in the changed code below.

This then goes into all the styles, and makes the changes on the fly without even one iota of speed degradation. This keeps your styles templates clean and unchanged entirely, making upgrades within the same vbulletin platform very easy.

I'm not talking about style migration from 3.x to 4.x. This functionality does not exist in 4.x any more than it has in any previous versions of vbulletin.

This mod is definitely worth it, especially if you add mods often.

[Videx]

This functionality does not exist in 4.x any more than it has in any previous versions of vbulletin. Clearly you're wrong there. They've made big changes to upgrades in vb4. This last one told me exactly which templates it merged with my custom code, which were successful merges and which weren't, and gave me the option to edit and compare the files side by side. A huge change from vb3.

All of which may be off topic for this particular thread, except that more than one person has said they don't want to upgrade to vb4 until this functionality is included. From what I saw with the 4.1.2 upgrade, it is included.

[Phaedrus]

Clearly you're wrong there. They've made big changes to upgrades in vb4. This last one told me exactly which templates it merged with my custom code, which were successful merges and which weren't, and gave me the option to edit and compare the files side by side. A huge change from vb3.

All of which may be off topic for this particular thread, except that more than one person has said they don't want to upgrade to vb4 until this functionality is included. From what I saw with the 4.1.2 upgrade, it is included.

If this did what you are saying then it would be included. It doesn't. This simply creates an overlay system that allows the changes to be made without direct changes to templates making merges and comparisons unnecessary.

Believe me, using both 4.1.2 without the mod and with it is miles different (I have done both now, with my test upgrade on a test board). This is better.

1. This allows you to make changes in a Master Template that applies to every style without changing the actual templates.
2. These changes will continue to work unless the template changes so your search string no longer exists. In upgrades there will be no template matches to change, the ones that don't work simply will not apply.
3. Those that do no longer work are easy to find by simply running a test against them, then you can view and find a different search string to apply the "add before" or "add after" etc. to...

While changes to 4.x were large, it certainly did not add the functionality of this mod. I am glad it still worked with my RL upgraded version.

I am not "clearly wrong", you are simply incorrect as to what this mod actually does. However, if you believe that you get the same functionality then I have no dog in this fight. I felt crippled without it on the test site and I'm very glad it is working now. It most definitely wasn't the same thing, nor did it give me the same capabilities with just 4.1.2 without the mod.

[Phaedrus]

Did they fix the bug in the newest release? (Please)...

[cellarius]

No, that bug has not been fixed yet. Please vote for it in the tracker:
http://tracker.vbulletin.com/browse/VBIV-7378

Or directly by clicking this link (you'll need to login at vb.com):
VOTE! (http://tracker.vbulletin.com/secure/ViewIssue.jspa?id=31830&vote=vote)

[Boofo]

Is this still usable in 4.1.3 then?

[cellarius]

Is this still usable in 4.1.3 then?
With minor limitations because of the bug I linked: Yes. I used it since vB4 alpha 1 and it's basic functionality is intact. I wouldn't want to modify vB4 without it.

[Boofo]

Isn't that bug also in stock vb ? I get it sometimes where it goes to a white page and says something about child nodes when I do something wrong in a template edit (like no ending if statement for instance).

[cellarius]

Jap, of course, that's a bug in sstock vB that needs to be fixed. The bug in vB affects TMS and has been reported ages ago. Sadly, 1300+ installations (counting those registered on vBG.org, too) have not been enough to varrant a little fix until now...

[Boofo]

So, the bug affecting this mod and the stock bug are the same?

[cellarius]

Almost- There's only one bug at all, and it's in the stock software since day 1. TMS has no bug strictly speaking, but suffers from the bug in the stock software, which causes minor issues in TMS (but does not render it unusable).

[Boofo]

It shouldn't cause any problems with this mod if the template code is correct in the first place. Looks like I will be installing this after all. Thanks for the heads up, sir. ;)

[cellarius]

A pleasure :) I can definitely recommend it.

[Phaedrus]

Is this still usable in 4.1.3 then?

It is for me... When you upgrade disable it, upgrade, enable it... It acts funny sometimes, but it has been usable for me.

[Divokymuz]

Or directly by clicking this link (you'll need to login at vb.com):
VOTE! (http://tracker.vbulletin.com/secure/ViewIssue.jspa?id=31830&vote=vote)

Pleas click on Vote for this bug.

It needs a higher priority, that IB hopefully fixes it in 4.1.4

[Phaedrus]

I don't get it, some bugs with less votes get fixed, this one remains.

[Boofo]

Because they don't stand to make anything on fixing it, so it is not a priority.

[Divokymuz]

Pleas click on Vote (http://tracker.vbulletin.com/secure/ViewIssue.jspa?id=31830&vote=vote)for this bug.

It needs a higher priority, that IB hopefully fixes it in 4.1.4

come on people, we need your help and more votes for this stupid little bug.

[MarkusB]

What for a pity and shame to IB, this minor ages bug let suffer one of the most helpful mods to get regular updated into vb4 !
Have voted ages ago...
Without this Mod we are not willing to buy any new vb4 Licenses, anyhow now we have to look forward into competing companies with better troubleshooting abilities, can`t wait forever!

[Juggernaut]

It says that this bug has been fixed, was on my way to voting for it :D

[cellarius]

Yes, it has been fixed, and Andreas is working on an updated version. :D

[Crotan]

Yes, it has been fixed, and Andreas is working on an updated version. :D

good to hear

[giorgino]

Installed on 4.1.5

[Boofo]

Yes, it has been fixed, and Andreas is working on an updated version. :D

Any idea when the update will be?

[cellarius]

Any idea when the update will be?
When it's ready (SCNR ;))
Andreas would have to answer that one; a beta is available on the German .org; there seem to be a few issues still.

[Boofo]

When it's ready (SCNR ;))
Andreas would have to answer that one; a beta is available on the German .org; there seem to be a few issues still.

What is SCNR? It better have something to do with being studly on my part. ;)

[cellarius]

What is SCNR? It better have something to do with being studly on my part. ;)
Of course, of course :p

[Boofo]

You know, if it was anyone else, I would call you out on this, but knowing you, I truly believe it. :p

[iask]

Andreas has uploaded TMS 1.2.0 Beta 2 (http://www.vbulletin-germany.org/showthread.php?24-Template-Modification-System) on vBulletin-Germany.org

[Hostboard]

Tried to create an accoutn there but do not have access to D/L
Waiting paitiently for its release here...
Previous use of TMS under 3.x proved invaluable

[Calystos]

Ditto, I created an account and no D/L access at all. Guess it is just a case of waiting til he releases it over here, :-(

[dartho]

Bug Report/Code Typo
Plugin : Event-Handler: Alle Templates wiederherstellen
Hook: admin_complete
call to function cad_administer('canadminstyles') - should be can_administer('canadminstyles')
global $deletetemplates;
if ($_POST['do'] == 'dorevertall' AND !empty($deletetemplates) AND $vbulletin->adminloggedin AND cad_administer('canadminstyles'))
{
$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "templateedit WHERE styleid = " . $vbulletin->GPC['styleid']);
require_once(DIR . '/includes/adminfunctions_templateedits.php');
rebuild_template_edits($vbulletin->GPC['dostyleid'], array_keys($deletetemplates));
}

[vgevolution]

Tried to create an accoutn there but do not have access to D/L
Waiting paitiently for its release here...
Previous use of TMS under 3.x proved invaluable

Ditto, I created an account and no D/L access at all. Guess it is just a case of waiting til he releases it over here, :-(

You have to add vbulletin-germany.org to your list of approved support locations in your member options of vbulletin.com. Then those sites can validate your license, and you'll be able to download the code. Here's a link to the place where you can activate those sites (you must be logged into vbulletin.com:
http://members.vbulletin.com/membersupport_priority.php

Added later:
I sure hope Andreas uploads an English version soon. I'm not certain, but it looks like the 1.2.0 Beta 2 version still has issues. Has anyone tried it yet? My German is pretty rusty, but I get nervous when I see several database errors.

[Lon]

I can confirm that this does indeed work for Vbulletin 4 versions.

Fresh clean install of this modification worked wonders. :)

Don't get any weird errors or anything when adding new template changes.

[Calystos]

Yeah I worked out the approval thingy, had to go to my members vb account page an tick it to the list. An yeah got it. Haven't tested it though. Am pondering just waiting for the English build.

[realmr]

can any one explain how is this add-on any different from the default TMS which vb has by default ?

[DragonMasterNYC]

can any one explain how is this add-on any different from the default TMS which vb has by default ?This plugin allows for much more control over how the templates are edited and which ones. For example what type of edit it's performing like a before, after, or a replacement the searched code within a specified template not the whole style. I had hoped when I got the upgraded version of vBulletin that this would be the case, but as you can see the vB team didn't quite get it right since all it does is a simple replace in the entire style.

[misericorde]

V.4.1.5

Installed Tms 115 It s ok

Thank you

[realmr]

This plugin allows for much more control over how the templates are edited and which ones. For example what type of edit it's performing like a before, after, or a replacement the searched code within a specified template not the whole style. I had hoped when I got the upgraded version of vBulletin that this would be the case, but as you can see the vB team didn't quite get it right since all it does is a simple replace in the entire style.

thanks for the clarification, so I am adding this up ;)

until vb4 reaches some where close to my liking, I am not gonna upgrade my forums to 4 series, hopefully by then a 4.x version is released for this add-on ;)

[fly]

Can any of you german speaking folk translate a status on this please?

[Black Tiger]

A status on what exactly?

[fly]

A status on what exactly?
Sorry, I was just wondering how the development was going. I know there isn't any hard release date, but if there were any big show stoppers right now...

[Black Tiger]

Aah... now I understand, you would like to know of the progression on the German forum of Andreas. I'll have a look for you.

Oke latest news:
With the beta2 an error is fixed when editing Style-variables.
For the rest I just ad a look at the last page, being page 117 at the moment over there, and it seems there still are some database errors occuring with several people on the beta2. Even with all mods turned of.

So I guess it will need some work.

[fly]

Awesome, thanks for the update!

[Black Tiger]

No problem, you're welcome. Glad to be of service.;)

[MikeF]

This is a monstrosity. No ability to remove it at all. Killed my forum with SQL errors on an attempted uninstall.

[fly]

This is a monstrosity. No ability to remove it at all. Killed my forum with SQL errors on an attempted uninstall.
I have no idea what it is, but you did something wrong.

[Black Tiger]

Maybe if you post some of the SQL errors we can get a clue of what is going on or what can be causing the problems.

[fly]

I seem to recall Andreas saying there was some scenario where you shouldn't uninstall it. Maybe if plugins were disabled?

[Black Tiger]

I can't remember that. But this is what the readme says:
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.

[Andreas]

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.

[Simon Lloyd]

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

[Andreas]

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.

[Simon Lloyd]

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

[fcherub]

Hi!
I get this when importing the product:

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:

[DragonMasterNYC]

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.

[Andreas]

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.

[fcherub]

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.

[misericorde]

Uptaded Thank you

[thecore762]

Hi there, when I enable this most of my forum icons custom or default skins do not appear.
What's going on?

[Scalemotorcars]

I realize this is not supported but I cant seem to find the exact cause for this error.

Warning: Invalid argument supplied for foreach() in [path]/includes/functions.php on line 3433


For some reason I cant edit my Footer template. If I try I get the above error.

When I click Show Modified Template the only one that shows is the footer.

If I try to ignore the warning it simple loops me back to the template saying

This template was changed by someone else while you were editing it. Your changes have not been saved. Please merge your changes from the lower editor into the current version in the upper editor. When you save this page, only what is in the upper editor will be saved.

And Store CSS Stylesheets as Files is turned off. Im still getting the error.

Any help would be great.

Forgot to mention. Im using the 1-1-5 version with 4.1.4 Thank...

[Scalemotorcars]

If I disable the product I can edit the footer, no error. Product on and the footer locks up. I also noticed last night that it never added the copyright code when I installed it. Maybe thats the problem????

[Scalemotorcars]

Looks like Ill have to uninstall. With it kicking back any kind of error its just not worth messing with especially since its not supported.

To bad this was a good mod back in 3.8.

[thecore762]

This is honestly lousy customer service.
There is 0 help.

[dartho]

You should demand a refund!

[cellarius]

This is honestly lousy customer service.
There is 0 help.
Once you grow up you'll surely understand what it takes to be a "customer", and that it is good manners to say thank you if you get something for free.

Honestly, you guys need to understand that the version for vB4 is in BETA as is clearly stated. If you don't know what beta means, feel free to look it up at wikipedia.

Andreas is in no way obligated to give you individual suport. He'll sort the problems out when he finds the time. Be patient, and stop the impertinencies, will you?

[Boofo]

Although I agree with you 100%, I think the "Once you grow up" was a little over the top, especially for you, my friend. You usually don't let them get you riled up like that. ;)

[cellarius]

Yeah, maybe. But this I want everything for free, immediately and top supported mentality really gets me over the top sometimes. And yes, it reminds me of little children sometimes. But they doin't know any better. Forum Owners should.

[Boofo]

I agree. But don't let them get to you. They aren't going to change so it is better to do like Andreas does, and ignore it. The mentality here isn't what it used to be.

[rugby]

Looks like Ill have to uninstall. With it kicking back any kind of error its just not worth messing with especially since its not supported.

To bad this was a good mod back in 3.8.

I am using this modification on my 4.1.6 version site, and it works perfectly without any errors. So i don't know why you are complaining for? There is a possibility that some mod has conflicted with this one, so its fault of another mod. You should check other mods that is causing trouble for you. I can guarantee this mod have no errors so far. I am using more than 15 mods on my site, and so far no bugs or error i have found with this mod.

I hope this will help you to rectify your problem.

:) Peace.

[Andreas]

Forgot to mention. Im using the 1-1-5 version with 4.1.4 Thank...
As you've carefully read the first post you are fully aware that TMS 1.1.5 is not fully compatible with vBulletin 4 and that errors like the one you are experiencing are caused by this incompatiblity, right? :)

[Scalemotorcars]

Im not complaining and Im sorry to see other members here think I am. I had a simple error kicked back by this mod. I spent several days trying to find the cause both here and on vb-Germany and the net without resolution.

@cellarius. Im shocked by your reply. I've always been very impressed with your mods and willingness to help others even with trivial errors. Don't let a few frustrated forum owners get to you.

@Boofo, I agree 100%, the mentality here has changed. At one time I remember a willingness to help everyone. It seems more and more that pro coders are just to busy to be bothered by novice forum owners with small issues. If I run across a mod and I know the answer to a members problem I try to make the time to help them out. Sure it might be simple for me but to them it might be a disaster. In fact you yourself have shown me that courtesy and I was very thankful for it. Its these few minutes of assistance that keep mod, and forums like vb.org alive.

@ Andreas My apologies for all this. I seem to have opened the proverbial can of worms and that was not my intention at all. Hopefully these small issues will be resolved eventually when there's more time.

[cellarius]

Don't get me wrong: it's not novices asking questions, its guys that go: I have a right to get an answer ("customer service", go figure).
But you're all right, I was a bit on the overwrought side, so - sorry for that, guys, and Scalemotorcars, it wasn't really aimed at you. I'll better stop ti spam this thread now :)

[thecore762]

^try to stay on topic.
If you got something to say personal take it to PM's.

@Andreas, I've ran the beta, none of the topic images work, not even the default vBulletin icons.

Also after installing the mod the plugins menu looks all messed up too, I'll try to take a screenshot for you.

[Andreas]

@thecore762
This Add-on is unsupported - all support requests except for proven bugs will therefore be ignored.
Please decide yourself if you want to post screenshots anyway.

[thecore762]

@thecore762
This Add-on is unsupported - all support requests except for proven bugs will therefore be ignored.
Please decide yourself if you want to post screenshots anyway.

Ok thanks for the clarification.
Looking forward to the gold release of this plugin for vb4.

[misericorde]

Thanks

Uploaded

[Alfa1]

TMS should become part of stock vbulletin IMHO.

[Phaedrus]

Quick question, Andreas...

If I donated to have the unbranded version long ago, will upgrading rebrand me?

[thecore762]

TMS should become part of stock vbulletin IMHO.

I agree. Andreas could we post this as a suggestion at vb.com?

I want to make sure it's ok with you before we request it to be added.

[cellarius]

Go ahead and do so. It has been suggested since the initial alpha testing phase of vB4 Gold, but like so many things...

[fly]

I agree. Andreas could we post this as a suggestion at vb.com?

I want to make sure it's ok with you before we request it to be added.
Doesn't he still work for them?

[cellarius]

Doesn't he still work for them?
Who is "them"?

[fly]

Who is "them"?
Sorry, I mean isn't Andreas employed by vB? I'd think he'd have the best access to get this added to the default...

[cellarius]

No, he is not (of course, if they're smart they may have hired him yesterday ;))

[fly]

No, he is not (of course, if they're smart they may have hired him yesterday ;))

Well he was a vB dev at one point...

[misericorde]

Very Nice

Please Uptaded for 4.1.7

[thecore762]

Very Nice

Please Uptaded for 4.1.7

This plugin is not fully support for 4.x.x yet.
It's still beta so no support will be given yet.

[cellarius]

Well he was a vB dev at one point...
I know, but that is quite a few years back. But this is really OT and has nothing to do with this addon.

[MalluParadise]

work with vb 4.1.7 ?

[Andreas]

Quick question, Andreas...

If I donated to have the unbranded version long ago, will upgrading rebrand me?
No. Branding-free licenses for TMS are perpetual, eg. valid for any version.

Well he was a vB dev at one point...
Yes - I was, but that was several years ago (at 3.5/3.6) :)

It's still beta so no support will be given yet.
Even if it comes out of beta (which I expect to happen soon as there have not been new bug reports for quite some time) it will still be unsupported as I simply do not have the time to give support.
Apart from that TMS 1.2.0 Beta 4 should work just fine with 4.1.7, 4.1.8, 4.1.9 ... basically any version > 4.1.5

[thecore762]

Thanks for the update Andreas, everything working great!

[addamroy]

Can someone verify if this will work with vb 4.0.7??

I want to use this addon so this one, https://vborg.vbsupport.ru/showthread.php?t=266696&highlight=sprites will be easier to install.

Also, where do I get the branding free version, I absolutely will not place a sitewide footer link to websites irrelevant to my forum, that's absurd.

I already sent an email to the email in the readme but didn't get a response back.

I'd love to use this just to make the installation of other products easier like the one I linked to above. However, in the description it says 'partly compatible with 4.0.x', what exactly do you mean by partly?

Is the sitewide footer link really necessary? It's not like anybody on my forum or many other forums would have any interest in the link back anyways since it's completely irrelevant and certainly won't add any value to the community.

[dartho]

Yes, it works with 4.0.7

Having a footer link or branding is like an author having his name on the front cover of a book. Fortunately for you, the author has been generous enough to provide a means for having it removed.

Send the author a $100 donation using the "Support Developer" link in the first post and you will be able to remove branding.

[B16MCC]

Hi , great mod. Installed and working fine. Just one thing I'd like to ask please ...

Could this be expanded to include the creation of custom templates ?
In my forum I use several additional templates, if I install a new style I have to recreate all my custom styles in that new style.

I just wondered if this could be used to add existing templates to new styles, unless there's a simple way of doing it ?

[Andreas]

I already sent an email to the email in the readme but didn't get a response back.
Maybe I missed it but I don't rembmber any email from you?


However, in the description it says 'partly compatible with 4.0.x', what exactly do you mean by partly?
Partly means that it does work, but that it is not fully compatible :)
Eg. expect problems in some usae cases (like editing a template that has template modifications, modifying a .css-template with TMS, saving a template-modification that contains one half of a conditional, etc.).
Apart from that it does work (eg. importing Add-ons that contain TMS data and having that applied).


Is the sitewide footer link really necessary?
Yes :)
Developing software costs a lot of time - the link compensates that.
If you do not want to have a link you can purcahse a branding-free license for 15 €.

Could this be expanded to include the creation of custom templates ?
TMS is not care if templates are "custom" or not.
For you usecase I'd sugest to create your own Add-on, create your custom templates for that Add-on in MASTER style - then they will automatically appear in all styles.
But that has nothing to do with TMS :)

[tpearl5]

With the latest beta i'm getting a "No Template-Modifications could be found for this product." after trying to export some custom template modifications that I entered. (templateedits.php?do=files) I'm 100% sure that I'm choosing the correct product. Any ideas?

Update - It's probably because I didn't choose the correct style :)

[Maxii]

error

Database error in vBulletin 4.1.9:

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 (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267


edit - fixed my problem

[franks]

Could you share how did you fix it? I'm facing the same problem.

Thanks.

[fly]

Could you share how did you fix it? I'm facing the same problem.

Thanks.

I'm pretty sure that, or similar errors, have been posted in this thread if you search. In short, fix your database.

[franks]

I'm pretty sure your user name is fly, not Maxii.

[fly]

I'm pretty sure your user name is fly, not Maxii.

:confused:

[OldSchoolDSL]

Database error in vBulletin 4.1.10 Alpha 2:

Invalid SQL:

SELECT templateid
FROM template
WHERE
edited=1;

MySQL Error : Unknown column 'edited' in 'where clause'
Error Number : 1054
Request Date : Sunday, January 1st 2012 @ 03:39:02 AM
Error Date : Sunday, January 1st 2012 @ 03:39:02 AM
Script : http://www.sociallyuncensored.eu/beta/admincp/plugin.php?do=productkill
Referrer : http://www.sociallyuncensored.eu/beta/admincp/plugin.php?do=productdelete&productid=tms&s=
IP Address : 7xx.xxx.xxx.xxx
Username : Beta
Classname : vB_Database_MySQLi
MySQL Version : 5.5.18-55

This is the only modification that was installed on the test site. Can't un-install it either.

I had this bug on 4.1.9 and not just 4.1.10 Alpha 2

Now I know for sure where it was coming from.

[OldSchoolDSL]

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.

This worked, but you should also drop

TMS structure values inside product and productcode and productdependency tables

Further, make sure there are no plugin for Template Modification System .... If so, delete them.

[OldSchoolDSL]

I found the cause and for now, the resolve to the error.

Cause: Upgrading vBulletin with this installed.

I don't know why, but for whatever "unknown" reason, having this installed during an upgrade will result with the error after the upgrade. It is important to note that this doesn't prevent you from upgrading vBulletin. And also important you to note that even with all hooks disabled globally using config.php this error will / can happen

Solution: Until the developer fixes this. I find uninstalling this before upgrading vBulletin and then re-installing it after you have completely and successfully upgraded, will keep you from getting the above error.

Reason: unknown

Test: A fesh copy of vBulletin 4.1.8, 4.1.9, 4.1.10 (Alpha 1 & 2) with no modifications or 3rd party skins.

Repeated results: 3x each version

[rjmjr69]

Updating table templateedit ...
Warning: require_once([path]/includes/adminfunctions_templateedits.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/adminfunctions_plugin.php(959) : eval()'d code on line 24

Fatal error: require_once() [function.require]: Failed opening required '/home/rjmjr69/public_html/acsyndicate.net/forums/includes/adminfunctions_templateedits.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rjmjr69/public_html/acsyndicate.net/forums/includes/adminfunctions_plugin.php(959) : eval()'d code on line 24

When trying to install

VB 4.1.0

[Alan_SP]

What version you tried to install?

As said in first post:

vBulletin Compatibility
Versions up to and including 1.1.5 are compatible with vBulletin 3.6.X, 3.7.X and 3.8.X
Version 1.1.5 is partly compatible with vBulletin 4.0.X and 4.1.X
Version 1.2.0 Beta 1 or higher is compatible with vBulletin 4.1.5 or higher

[TombstoneWarrior]

what does this mod do and if i instal it any mod i already have that i edited the text i will have to uninstall and reinstall? how does this mod work and why is it worth downloading??

[tpearl5]

what does this mod do and if i instal it any mod i already have that i edited the text i will have to uninstall and reinstall? how does this mod work and why is it worth downloading??

Read the first post?

[TombstoneWarrior]

Read the first post? AFTER READING THE FIRST POST FOR THE THIRD TIME I AM STILL VERY CONFUSSED ON WHAT THIS DOES BESIDES HELP WHEN YOU DO UPDATES SO YOU DONT HAVE TO DO THE TEMPLET MODS AGAIN. WHERE IS THE XML FILES I NEED SO I DONT HAVE TO MOD THE TEMPLET'S? ARE THE XML FILES THAT DO THE TEMPLET MODS FOR YOU THE XML FILE YOU UPLOAD VIA THE PLUGIN AND PRODUCTS MANGE PRODUCTS UPLOAD? ( SORRY ABOUT THE CAPS JUST RELIZED THEY WERE ON) sorry again! can someone please explain my questions to me please!

[TheSupportForum]

AFTER READING THE FIRST POST FOR THE THIRD TIME I AM STILL VERY CONFUSSED ON WHAT THIS DOES BESIDES HELP WHEN YOU DO UPDATES SO YOU DONT HAVE TO DO THE TEMPLET MODS AGAIN. WHERE IS THE XML FILES I NEED SO I DONT HAVE TO MOD THE TEMPLET'S? ARE THE XML FILES THAT DO THE TEMPLET MODS FOR YOU THE XML FILE YOU UPLOAD VIA THE PLUGIN AND PRODUCTS MANGE PRODUCTS UPLOAD? ( SORRY ABOUT THE CAPS JUST RELIZED THEY WERE ON)MS sorry again! can someone please explain my questions to me please!

basically you inport a product as normal, as you always have
the TMS then does the $find $replace for you if someone has already implented a TMS based product

the TMS also allows you do do template edits without having to go directly into the main template and edit it, TMS will do any $find & replace $add as long as it find the peace of code you put into the criteria boxes

[TombstoneWarrior]

basically you inport a product as normal, as you always have
the TMS then does the $find $replace for you if someone has already implented a TMS based product

the TMS also allows you do do template edits without having to go directly into the main template and edit it, TMS will do any $find & replace $add as long as it find the peace of code you put into the criteria boxes how will i know if some one has already implented a TMS based product????

[OldSchoolDSL]

how will i know if some one has already implented a TMS based product????

Most authors will state if their modification supports TMS. TMS will also help confirm if those templates were indeed added and if they work with your version.

[TombstoneWarrior]

basically you inport a product as normal, as you always have
the TMS then does the $find $replace for you if someone has already implented a TMS based product

the TMS also allows you do do template edits without having to go directly into the main template and edit it, TMS will do any $find & replace $add as long as it find the peace of code you put into the criteria boxes

Most authors will state if their modification supports TMS. TMS will also help confirm if those templates were indeed added and if they work with your version.where will they state it in the mod description or where else can this be found??? sorry for all the questions this mod just confusses me. im reading and reading and getting nowhere. i have only been doing this for 2 weeks so im a newbie at this sorry!!!!!!!!!!!!!
see even this confusses me can some talk to me and help a nebie out im more than willing to pay through paypal forthe help

[thecore762]

Strange, when I go to edit template I get to this page and I can't do anything unless I disable TMS.

See screenshot:

[TheSupportForum]

where will they state it in the mod description or where else can this be found??? sorry for all the questions this mod just confusses me. im reading and reading and getting nowhere. i have only been doing this for 2 weeks so im a newbie at this sorry!!!!!!!!!!!!![/color]
see even this confusses me can some talk to me and help a nebie out im more than willing to pay through paypal forthe help

if a developer is using TMS with their MODS

they will have to state in the requirements of the MOD description that TMS is required
also some mods will put TMS as a requirement to install the MOD and will come up with an error to say "TMS is required to install this MOD" this will appear when you attempt to install and halt coz you don't have the requirements
also within Admincp > settings [MOD name]
they will display an "enable" or "Disable" to use the TMS to auto insert the code

[cellarius]

TMS should never be required to install a mod. You can do everything TMS does by manual template edits, too, and TMS even offers to print template edit instructions. All my addons support TMS, but I always also give the instructions for manual template edits.

[apaydin2148]

any update?

[BlueCheri]

Installed, let me check how it works.

G!

[w8baby]

database error with the latest vb 4.1.11/mobile template
had to disable it to stop the database

was working fine before with 4.1.10

[ndahiya]

seeing this error with VB 4.1.11 - everytime any style related stuff is changed, including cleanup etc.


Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2
FROM templateedit AS t1
LEFT JOIN templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=14)
WHERE t1.styleid = -1;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Thursday, March 1st 2012 @ 04:50:51 PM


ndahiya

[BlueCheri]

I have same error, and after removing TMS modification, still getting following error.


Warning: require_once([path]/includes/adminfunctions_templateedits.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/adminfunctions_template.php(3208) : eval()'d code on line 4

Fatal error: require_once() [function.require]: Failed opening required '/home/offwalk/public_html/includes/adminfunctions_templateedits.php' (include_path='.:/usr/lib/php') in /home/offwalk/public_html/includes/adminfunctions_template.php(3208) : eval()'d code on line 4

Next when I tried to add again "adminfunctions_templateedits.php'", it give db error again.

G!

seeing this error with VB 4.1.11 - everytime any style related stuff is changed, including cleanup etc.


Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2
FROM templateedit AS t1
LEFT JOIN templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=14)
WHERE t1.styleid = -1;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Thursday, March 1st 2012 @ 04:50:51 PM


ndahiya

[Hostboard]

When modifying VB's advertising system the following DB error will occur during the save. Confirmed with Trevor via VB support ticket.


Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2
FROM vb_templateedit AS t1
LEFT JOIN vb_templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN vb_templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=37)
WHERE t1.styleid = -1;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Thursday, March 1st 2012 @ 04:33:06 PM
Error Date : Thursday, March 1st 2012 @ 04:33:06 PM
Script : http://www.MyDomain.xxx/forums/admincp/ad.php?do=update
Referrer : http://www.MyDomain.xxx/forums/admincp/ad.php?do=edit&adid=5&ad_location=global_below_navbar&ad_location_orig=global_below_navbar
IP Address : xx.xxx.xx.xxx
Username : UserName
Classname : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10

[TnT]

I have same error, and after removing TMS modification, still getting following error.


Warning: require_once([path]/includes/adminfunctions_templateedits.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/adminfunctions_template.php(3208) : eval()'d code on line 4

Fatal error: require_once() [function.require]: Failed opening required '/home/offwalk/public_html/includes/adminfunctions_templateedits.php' (include_path='.:/usr/lib/php') in /home/offwalk/public_html/includes/adminfunctions_template.php(3208) : eval()'d code on line 4

Next when I tried to add again "adminfunctions_templateedits.php'", it give db error again.

G!

You have to disable the Product not to remove the files.

[Nirjonadda]

Installed on 4.1.10

[thecore762]

Doesn't work properly with 4.1.11.
Will we be expecting this to be updated anytime soon by Andreas?

[gothicuser]

Doesn't work properly with 4.1.11.
Will we be expecting this to be updated anytime soon by Andreas?
Hopefully so bud.

[cellarius]

At vBGermany.org there's a Patch (first post, way down: tms_patch210b4.zip)

[thecore762]

At vBGermany.org there's a Patch (first post, way down: tms_patch210b4.zip)

I suppose it's not translated correct?

Edit, I can't register on vb germany, I don't understand the security question when translated...
Is it possible for someone to dl it and then upload it here?