PDA

View Full Version : Administrative and Maintenance Tools - Template Modification System


Pages : 1 [2] 3 4

bigtime
03-23-2008, 08:00 PM
Anyone successfully using this on 3.7 RC1?

Thanks,

Tim

ringleader
03-24-2008, 12:17 AM
Andreas,
I am testing this on 3.7.0 b4 but nothing happened when I select Add Template Modification in the Master style from the dropdown menu?

That happens because your version of mySQL is incorrect for this mod, I believe.
If it's installed on the wrong version the dropdown menus don't work.

A way around this (not sure if it causes problems though - none that I found yet) is installing it somewhere where your board has the correct version of mysql (say, localhost) and uploading the board with it installed to the server that has the wrong version of mysql.

(I've two hosts with differing mysql versions - one works, one doesn't)

Now, if I add a new style, will it automatically add the template-modifications to that style?

Yes. Every style inherits from the MASTER style in TMS.

dancue
03-24-2008, 02:28 AM
I got to say, I wish I would have tried this system out the first time I came across it.

I really wanted to give my members a good selection of styles so I had about 10 different styles which I was making template edits to individually!!

lol

I did it now with the TMS and it took me a fraction of the time!! What a wonderful idea!!

oh and bigtime...I'm using 3.7 RC1. It's working just fine with the exception of the go button on safari. I just downloaded FF though and got around that.

dancue
03-24-2008, 11:43 PM
quick question.

Can I add a template modification to one style without it affecting the others?

I went to the dropdown box and selected "add a template modification" for one of the styles. I looked at the list of templates and not all the templates are included. I was looking for the header template in particular because each style has a different header setting.

is it possible?

Andreas
03-25-2008, 01:20 PM
As long as the template physically exists in the style (eg it is customized there or a custom tamplate added in this style) - yes.
Otherweise it is not possible due to the fact that no physical template exists in the style in this case.

dancue
03-25-2008, 01:22 PM
Okay. Thank you much.

smartwulf
04-08-2008, 06:41 AM
Exellent plugin! thank you so much~~

DieselTruck
04-09-2008, 05:51 PM
Im currently using this on 3.7 RC2. But, in the Admin CP I have a error on page when trying to collaspe any templates using this mod.

Any suggestions?

dancue
04-09-2008, 09:17 PM
Any fix on the issue with the go button not working in Safari?

KanmaiseR
04-10-2008, 04:58 AM
Thanks Andreas.. ;)

Icy
04-10-2008, 03:22 PM
Im currently using this on 3.7 RC2. But, in the Admin CP I have a error on page when trying to collaspe any templates using this mod.

Any suggestions?
Try this plugin (https://vborg.vbsupport.ru/showpost.php?p=1384949&postcount=165)!

Sebijk
04-11-2008, 04:28 PM
The newest version of TMS is on the German vBulletin Add-on Site: http://vbulletin-germany.org/showthread.php?t=24

dancue
04-12-2008, 11:56 AM
The newest version of TMS is on the German vBulletin Add-on Site: http://vbulletin-germany.org/showthread.php?t=24

Hopefully we'll get it here. I don't understand a bit of german.:confused:

Andreas
04-18-2008, 10:09 AM
The new version will be release here too, I am just waiting to see if there are bugs that need to be fixed first :)

dancue
04-18-2008, 11:16 AM
awesome! Can't wait.

smonabav
04-19-2008, 10:32 AM
sorry, i'm completely new in here and new with vBulletin, how can i install this?

Black Tiger
04-19-2008, 11:45 AM
You could start reading the readme.txt in there.
Upload all files to your forums.
Then go to your AdminCP. Left column, nearly at the bottom you have the "plugins and products".

Expand it and open "manage products" and choose "import product" and import the product file.

RedeemedWarrior
04-20-2008, 01:36 PM
excellent works a treat!

Black Tiger
04-23-2008, 11:52 PM
TMS bug found?
I don't know for sure if this is also happaning on 3.6.x installations when trying to change things in the footer near the vbulletin copyright notices.

In my 3.7.0 installation I wanted to move the ad_location ad_footer_end code a bit higher like this:

$ad_location[ad_footer_end]
<br />

<div align="center">
<div class="smallfont" align="center">
<!-- Do not remove this copyright notice -->
$vbphrase[powered_by_vbulletin]
<!-- Do not remove this copyright notice -->
</div>

<div class="smallfont" align="center">
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
$cronimage
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->

$vboptions[copyrighttext]
</div>
</div>

</form>

<if condition="$show['dst_correction']">

Normally the addcode is between the /form code and the dst correction code.

I can't get this to work, not even if I copy the complete footer template code to get this changed.
Changes in the beginning of the footer code, f.e. adding an add code in the beginning of the footer template, is no problem.
Just moving this add_footer code above the copyright code won't work unless I change it in the template itselve.

How come this won't work with the TMS system whilest everything else and also other footer template adjustments (higher up in the template) work with TMS even in 3.7.x?

goddess_dix
04-24-2008, 01:42 PM
How come this won't work with the TMS system whilest everything else and also other footer template adjustments (higher up in the template) work with TMS even in 3.7.x?

i would guess this may well be related to the TMS credit line being hardcoded into the product.

Black Tiger
04-24-2008, 08:17 PM
That could be indeed a fact, I didn't think of that yet, thanks!

BigDog56
04-30-2008, 02:37 AM
Since I updated to 3.6.10, it no longer works. Seems I get an error on page message when I try to hit edit template modification.

Icy
04-30-2008, 04:17 AM
TMS just works fine with vB 3.7.0, however it doesn't auto refresh. I had to manually click Test Template Modification after upgrade & then it rebuild the template modificatoin. Can it be automated Andreas?

Boofo
04-30-2008, 04:27 AM
Isn't there supposed to be an upgrade coming for this from the German site?

Black Tiger
04-30-2008, 11:19 AM
TMS just works fine with vB 3.7.0, however it doesn't suto refresh.
Well it auto-refreshed when I upgraded from RC3 to RC4. But after upgrading I had to refresh the ACP once by clicking F5 in IE, or logout and login again.

Worked fine on 3.7.0 RC4 so should also work on 3.6.10.
What error on page message did you get BigDog? And did you test the templates with the TMS system again after upgrading?

dancue
04-30-2008, 01:46 PM
Isn't there supposed to be an upgrade coming for this from the German site?

Yeah. Can't wait to have that one installed.

Andreas
05-01-2008, 07:57 AM
There will be an update once all discovered bugs have been fixed; I don't want a too buggy release on vBulletin.org as it would cause too many support requests ;)

dancue
05-01-2008, 11:27 AM
That sounds good Andreas. Thank you.

Meanwhile, do you mind sharing the changes that have taken place?

Andreas
05-01-2008, 12:15 PM
Nothing big, mainly just bugfixes.

The only new features are:
- Search Template Modifications
- Action 'Delete' (some people requested that, although it's the same as 'Replace' with nothing anyway)
- No Default action selected (this was also requested to prevent accidental selction of action 'Replace')

I think i'll also add an auto-rebuild function after vBulletin upgrades.

dancue
05-01-2008, 12:28 PM
Cool. Any idea why on Safari the GO button does not work.

Andreas
05-01-2008, 01:16 PM
No, sorry.
I don't have access to a Mac so I can't test it either.

You did upload the fixed JavaScript files?

dancue
05-01-2008, 02:03 PM
I believe I did. That's fine. I don't mind opening FF instead.

Andreas
05-03-2008, 03:37 PM
The 1.1.1 package is almost ready to be released.
Just wating to see if I introduced any new bugs ;)

Mosh
05-07-2008, 12:17 AM
Hi Kirby,

Can you please tell me how one go about dealing with usergroup permissions, in conjunction with this hack?

What I mean is that if I want the template edits to display to only certain usergroups, with normal template injections I would just put conditionals in a hook and check against the current user's $bbuserinfo.

Where usergroup permissions for the template changes are not needed, I have not problems with TMS (I even release a small hack with it today for v3.7.0), but getting usergroup permissions to work is not as easy as it looks.

Thanks in advance,

Mosh :)

jojo77
05-07-2008, 07:29 PM
is a version for 3.7 coming anytime soon? I'm waiting for this before I install other mods. thanks.

dancue
05-07-2008, 09:54 PM
is a version for 3.7 coming anytime soon? I'm waiting for this before I install other mods. thanks.

I've been using this on 3.7 and it is working perfectly fine.

dancue
05-07-2008, 10:19 PM
Andreas,
I don't know how open you are to suggestions, but I'd like to make two requests for a future release.

1 - A "Save and Reload" button
2 - A Preview Button allowing you to preview the changes you've made.

Vinyljunky
05-08-2008, 04:29 PM
Installed and working on VB 3.7 :up:

Brilliant Mod!

Thank You

VinylJunky

dartho
05-09-2008, 01:31 AM
Just upgraded my 3.6 board to 3.7, with TMS in place before the upgrade = EASIEST UPGRADE EVER!!

Andreas
05-09-2008, 09:02 AM
is a version for 3.7 coming anytime soon? I'm waiting for this before I install other mods. thanks.
This is the 3.7 version.

Andreas
05-09-2008, 09:06 AM
@Mosh
I don't understand your question, sorry.
Design your template edits without TMS in mind (eg. how you would be doing them manually), write down (or just keep in mind) the instuctions (search, replace, ...) - than go into TMS and paste the strings. Done.

@Dancue
Save & Reload sounds like a good idea :-)
What exactly do you want to 'preview', the template as it would look like before compilation?

dancue
05-09-2008, 11:36 AM
What exactly do you want to 'preview', the template as it would look like before compilation?

The best example I could give you is Dreamweaver. How you can split the screen to show the code and the layout. If you make a change to the code, you click on refresh to view the changes in the layout.

I ask about this because there are times that I like to take a look at the changes I'm doing in order to get a better idea of what changes I need to make. Right now I have to try it on a test forum, open a new tab, open the site and click refresh after every edit to see if I've achieved the look I wanted.

I don't know how difficult this would be, so excuse me if I've asked for the impossible.

I imagine there would have to be another input box for the user to input the url address of the affected page(s).

Andreas
05-09-2008, 12:01 PM
TMS has no idea where a certain template is being used, so 'previewing' the resulting frontend output isn't really possible.

Asking the user for an URL would be possible, but where is the advanted over just opening another tab for that?

dancue
05-09-2008, 12:51 PM
You could make changes on a site without having to disrupt anything. It would make it convenient to use for those of us who "experiment" with templates because we are not coders. Things tend to go bad every once and a while...:)

In other words the user would go through the regular process of inputing the strings of code, but before they hit the save button they hit the preview button which will give them a view of the changes without actually posting it through yet.

Icy
05-09-2008, 01:20 PM
I think i'll also add an auto-rebuild function after vBulletin upgrades.
Thank you Andreas :)

Saint_ago
05-09-2008, 05:23 PM
Oke, otherwise I could pm Andrea.

Now I've got another problem. I just logged in to my ACP and see a notice that wasn't there before it has this headline:

And this is the content of the notice:

But when I use the test function (it's clickable in this notice) all 3 template edit i made so far has a "v" in the circle, meaning they are ok.

So now I don't know what the problem is. Nore why it's giving this notice.

I could try and disable them one by one to see which one is giving the problem, but I wonder why this notice was not given yesterday after I implemented them.

Or could this notice appear because I'm using vb 3.7.0 beta 5 and TMS is not recognizing things?

I'm having the same problem here. I've deleted all modifications and the message still remains!

When i click "Test Template-Modifications", the message "No Template-Modifications could be found for this product." appears.

Using 3.7.0 Gold

Black Tiger
05-10-2008, 03:43 AM
My problems are long gone.:)
You did make TMS template edits didn't you? If not, then it's working as designed.
There is nothing to test if no TMS templates are added.

Icy
05-10-2008, 05:46 AM
I'm having the same problem here. I've deleted all modifications and the message still remains!

When i click "Test Template-Modifications", the message "No Template-Modifications could be found for this product." appears.

Using 3.7.0 Gold
Wondering why didn't you see the solution (https://vborg.vbsupport.ru/showpost.php?p=1314430&postcount=85) just after the Black Tiger's post :S

BigDog56
05-10-2008, 05:29 PM
The proplem I have after updating is when i go to Template-Modifications Manager, hit "go" on any of them, nothing happens... I cannot add ant new mods, or modify any.

dancue
05-10-2008, 06:25 PM
The proplem I have after updating is when i go to Template-Modifications Manager, hit "go" on any of them, nothing happens... I cannot add ant new mods, or modify any.

Are you using Safari? This issue has been mentioned in this thread before. You cannot use Safari. Try FF or IE

BigDog56
05-10-2008, 06:55 PM
Are you using Safari? This issue has been mentioned in this thread before. You cannot use Safari. Try FF or IE

Nope. using IE
EDIT. Just tried it in fire fox and it works. Go figure. But not IE

TsirhCitna
05-11-2008, 03:06 AM
I just installed this and I'm getting a lot of SQL errors. Here is the one I get if I try to uninstall TMS:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT templateid, searchstrregex, replacestr
FROM vb3_templateedit AS templateedit
INNER JOIN vb3_templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname )
INNER JOIN vb3_template AS template ON (template.title=templateeditlocation.template)
LEFT JOIN vb3_style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))
LEFT JOIN vb3_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


ORDER BY searchorder ASC;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, May 10th 2008 @ 11:06:14 PM
Error Date : Saturday, May 10th 2008 @ 11:06:14 PM
Script : http://www.tenstones.net/forums/admincp/plugin.php?do=productkill
Referrer : http://www.tenstones.net/forums/admincp/plugin.php?do=productdelete&productid=tms&s=
IP Address : 65.25.2.41
Username : Bob
Classname : vB_Database
MySQL Version : 4.1.22-standard

Andreas
05-12-2008, 05:22 AM
@TsirhCitna
The character sets used in your DB are not consistent (latin1_swedish_ci vs. latin1_general_ci).
You have to correct that.

@BigDog56
I assume you did install the fixes as well?

BigDog56
05-12-2008, 01:11 PM
I presume I did, but will double check when I get back home.

redraider
05-12-2008, 04:57 PM
Any changes or updates for 3.7 ?

Andreas
05-12-2008, 04:59 PM
There will be planned update soon, but it isn't exactly necessary - TMS works fine on 3.7. as-is.

Boofo
05-12-2008, 05:41 PM
Any idea how soon?

PGAmerica
05-12-2008, 08:26 PM
There will be planned update soon, but it isn't exactly necessary - TMS works fine on 3.7. as-is.
Well, I put that to the test and installed this in my 3.7.0 system. Now my menus do not work and my ACP screen is all fubarred. I cannot even get to the option to uninstall this. I included a screencap of my current ACP screen.

Since I cannot get to the "Uninstall" option in the ACP, How do I either uninstall this or fix it?

Black Tiger
05-12-2008, 09:02 PM
You can't click "Go" next to the uninstall of the TMS system in the ACP (2nd screenshot)?
I also don't think it's TMS which fubarred your forums but the combination of 2 mods. I also see in there the "Let php level" mod and my guess is that TMS and the "Let PHP level" mod are conflicting with each other some way, which caused the problem.

I've had about 20 mods on my 3.6.8 forums when I installed TMS. I upgraded to 3.7.0, no problems, and I'm also running vBA like you do.
So that's why I think the 2 named mods are conflicting.

PGAmerica
05-12-2008, 09:13 PM
That may very well be, but the problem still is that I cannot click the "Go" button to uninstall any mods at all. I need to know how to uninstall this mod so I can fix the conflict.

dartho
05-12-2008, 09:28 PM
Disable the plugin system. Edit your config.php file, and add

define('DISABLE_HOOKS', true);

on its line directly under the <?php. ie. insert as a new line on line 2. Then you should be able to disable/uninstall mods

dancue
05-12-2008, 09:31 PM
That may very well be, but the problem still is that I cannot click the "Go" button to uninstall any mods at all. I need to know how to uninstall this mod so I can fix the conflict.

Use firefox, the go button seems to not be working on Safari or IE. (IE without the fix)

PGAmerica
05-12-2008, 09:36 PM
Use firefox, the go button seems to not be working on Safari or IE. (IE without the fix)
I have tried this in IE, Firefox and Safari. I have tried it on my PC as well as my Mac. Same thing in all environments.

Disable the plugin system. Edit your config.php file, and add

define('DISABLE_HOOKS', true);
on its line directly under the <?php. ie. insert as a new line on line 2. Then you should be able to disable/uninstall mods
I followed your instructions and I still cannot get any reaction by pushing the "Go" button. Nothing at all.

The top 8 lines of my config.php file look like this.

<?php
define('DISABLE_HOOKS', true);
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 3.7.0 - Licence Number 15455617
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ?2000-2008 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||

dancue
05-13-2008, 12:52 PM
Am I the first to install the new upgrade?

Nice! Thanks Andreas!

I assume the upgrade process is the same as installation?

Mosh
05-13-2008, 01:09 PM
Am I the first to install the new upgrade?

Nice! Thanks Andreas!

I assume the upgrade process is the same as installation?
Nope, that would have been me.

And yes, the upgrade process is the same, upload and overwrite all the files, import the product, then you are all done.

I have come across no problems so far :)

dancue
05-13-2008, 01:21 PM
lol...darn...

Thanks mosh!

PGAmerica
05-13-2008, 02:16 PM
I followed your instructions and I still cannot get any reaction by pushing the "Go" button. Nothing at all.
Is there any answer to my problem? My entire ACP is practically useless right now.

Andreas
05-13-2008, 02:25 PM
The answer is: I don't know nor can I do anything as the problem ist not reproducable.

Feel free to send me a PM with an ACP login and i'll take a look, otherwise I suggest to not use this mod if it causes problems for you.

PGAmerica
05-13-2008, 02:33 PM
I cannot choose to not use this mod as it cannot be uninstalled. All I am looking for is a way to remove it so I can figure out what is causing the problem. Clicking the "Go" button will most likely call an exact url that will uninstall it. Do you have any idea howI can do this?

Andreas
05-13-2008, 02:37 PM
See post #311.

If this doesn't help you are SOL as I can't help any further without ACP access.

PGAmerica
05-13-2008, 03:22 PM
See post #311.

If this doesn't help you are SOL as I can't help any further without ACP access.
I have sent you a pm with the ACP access info. Thank you for your offer of help.

dancue
05-13-2008, 07:22 PM
I had a question for you about the testing of modifications.

I am receiving an error, however the edit is showing on the site.
What I did was I added nav buttons to a style that did not have it included in the navbar template. That was the first edit. Searchorder 1.

The second template edit added another button based on the first edit. Searchorder 2.

Ideally, this would work and it did, but I guess the error comes because when the template is tested it tests the default template, not including other edits.

Am I correct in saying this? Are there plans to correct this in the future?

TsirhCitna
05-14-2008, 01:09 AM
@TsirhCitna
The character sets used in your DB are not consistent (latin1_swedish_ci vs. latin1_general_ci).
You have to correct that.
How do I go about that? I tried both of the solutions here: http://www.vbulletin.com/forum/showthread.php?t=121120 and I still get the same error.

vengefuldeath87
05-16-2008, 03:57 PM
Great product! One small problem, the main page of the ACP says that there is one out of date template modification, but the test doesnt give any errors, and says that all the templates are alright. i only have modifications to the navbar and postbit templates and run vbul 3.7.0

member007
05-16-2008, 08:14 PM
Hi,
I couldn't find the two extra links in in the admincp under styles & templates. I am using vbulletin version 3.7. Thanks.

Andreas
05-17-2008, 06:33 AM
@vengefuldeath87
Which Version do you use?

@member007
Check if you did all installation steps correctly, especially if cpnav_tms.xml is in the right place.

vengefuldeath87
05-17-2008, 09:08 AM
i use the latest version.

dancue
05-17-2008, 12:37 PM
Hi,
I couldn't find the two extra links in in the admincp under styles & templates. I am using vbulletin version 3.7. Thanks.


also check to see if you refreshed the page.

Andreas
05-18-2008, 07:00 AM
@vengefuldeath
I am repeating my question: Which Version do you use according to your ACP?

vengefuldeath87
05-18-2008, 07:59 AM
acp says 1.0.0

Andreas
05-18-2008, 08:13 AM
The next time you are asking for support and state that you are using the latest version please make sure that you are really using the latest version ...

Lionel
05-22-2008, 10:34 AM
Well, I put that to the test and installed this in my 3.7.0 system. Now my menus do not work and my ACP screen is all fubarred. I cannot even get to the option to uninstall this. I included a screencap of my current ACP screen.

Since I cannot get to the "Uninstall" option in the ACP, How do I either uninstall this or fix it?

I have the same issue, when I edit a template and click on "Save". This started to happen with 1.12 that I installed one hour ago.

Andreas
05-23-2008, 09:19 AM
I am sorry, but this is unfixable ATM as I cannot reproduce the problem.
Feel free to send me a PM with ACP details and I'll take a look.

sebaldus
05-23-2008, 12:26 PM
Thanks, great addons. :P

Lionel
05-23-2008, 03:05 PM
I uninstalled 1.12 and reinstalled 1.0 (on vb 3.70) and all is fine ....

Lionel
05-23-2008, 04:49 PM
Thanks Andreas, for fixing this.

wtfsoccerdude
05-26-2008, 06:41 PM
will this work on 3.7? I really need TMS to install vBCredits. I don't have much time to manually edit the templates.

vengefuldeath87
05-26-2008, 06:51 PM
yes, it works perfectly on 3.7, just make sure you use the latest version.

Black Tiger
05-26-2008, 07:38 PM
And I can confirm too that it wil also work with vBCredits on 3.7, when using the latest vbcredits version.

bonkerspr
06-02-2008, 06:44 AM
where is the use instrucctions for this mod?

Black Tiger
06-02-2008, 01:28 PM
Try the first post, a part is in there.
It's basically very easy. Install this mod. If you want a template change, go to your Styles and Templates, click the template manager then select on the right "add new template".

It's then basically like any mod change here. Choose a unique id, then follow the template change instructions of the mods you want to install.
A basic "look for this" and "change to that" is implemented in the TMS system. You can also choose to "place above" or "place below" the search text like stated in some mod installation instructions.

Have a look for yourself, it's really very easy.
If you have a mod supporting the TMS, you mostly don't have to do anything.:)

fly
06-02-2008, 03:25 PM
I didn't see this covered in the FAQ, but here's my problem...

When TMS is enabled and I expand the 'Postbit Templates', the ONLY template I see is 'postbit'. Every other template is missing from this menu. The problem continues even if I create a new style with no parent style. I've tried reinstalling this hack, deleting all template mods, and rebuilding the styles from TMS. As soon as I disable this hack, the problem disappears. Any ideas?

edit: whoops, btw I'm using 3.7.1

Andreas
06-02-2008, 03:43 PM
As soon as I disable this hack, the problem disappears. Any ideas?

It most likely has to do with some 'strange' mod_gzip/mod_deflate/gzip/zlib/output buffer configuration, but I can't help you as I cannot reproduce the problem locally.

Feel free to send me a PM and i'll take a look.

fly
06-02-2008, 09:07 PM
It most likely has to do with some 'strange' mod_gzip/mod_deflate/gzip/zlib/output buffer configuration, but I can't help you as I cannot reproduce the problem locally.

Feel free to send me a PM and i'll take a look.

ygpm. ;)

fly
06-03-2008, 10:56 PM
If it matters, I commented out mod_deflate and bounced apache. Same thing...

Andreas
06-04-2008, 04:08 AM
I'll take a look as soon as possible, but you will have to wait at least until this evening.

silurius
06-05-2008, 06:17 PM
Hi Andreas. Great add-on. I have a question about the "Template-Modifications by TMS" notice in the footer. The wording strongly implies that the theming of my vBulletin site was also done by TMS, rather than that the TMS system was done by TMS. I thought a good compromise might be to edit that to say something like "Template-Modifications System by TMS", but unfortunately I can't seem to locate where this is stored in the footer or in phrases. Can you advise?

Also a related comment: Why show this notice at all on the main forums, when your average forum user is unlikely to even know what a template is (or at least what it is referring to)? Might I suggest having this appear in the footer of the admincp pages instead?

Andreas
06-06-2008, 05:25 AM
I thought a good compromise might be to edit that to say something like "Template-Modifications System by TMS"
GNU is not Unix? ;-)
Sorry, but that makes no sense.

The wording strongly implies that the theming of my vBulletin site was also done by TMS
What's wrong about that? In fact, this is correct.

Might I suggest having this appear in the footer of the admincp pages instead?
Declined.

dartho
06-06-2008, 09:10 AM
Hi Andreas. Great add-on. I have a question about the "Template-Modifications by TMS" notice in the footer. The wording strongly implies that the theming of my vBulletin site was also done by TMS, rather than that the TMS system was done by TMS. I thought a good compromise might be to edit that to say something like "Template-Modifications System by TMS", but unfortunately I can't seem to locate where this is stored in the footer or in phrases. Can you advise?

Also a related comment: Why show this notice at all on the main forums, when your average forum user is unlikely to even know what a template is (or at least what it is referring to)? Might I suggest having this appear in the footer of the admincp pages instead?

May I suggest you read the readme.txt file included in the download package for information on how to remove the branding.

fly
06-06-2008, 09:13 AM
Andreas, have you had any chance to look at my TMS problem?

Andreas
06-06-2008, 09:39 AM
I can only assume that output_buffering is too low (4 KB).
As this is a php.ini setting and can't be changed at runtime, there is not much I could do.

fly
06-06-2008, 12:26 PM
I can only assume that output_buffering is too low (4 KB).
As this is a php.ini setting and can't be changed at runtime, there is not much I could do.
Ah! That was it. I am constantly amazed by you. Thanks man!

btw, do you have a suggested value? I just doubled it to 8k...

silurius
06-06-2008, 03:37 PM
I'm a little surprised at the dismissive pushback here. I thought I was presenting my concerns clearly and respectfully.

First of all, when I said "The wording strongly implies that the theming of my vBulletin site was also done by TMS", what I meant was, this statement will lead someone who is not familiar with vBulletin software to believe that the branding customizations to my vBulletin site/forum was done by some person or group called "TMS". Obviously the statement as you have it written is factually correct, but it's also misleading, especially on sites that are not related to software, vBulletin or otherwise. If you don't see that as a potential issue or problem, then I suppose we really do lack common ground on this issue.

Secondly, this is what is actually written in the version of the readme.txt that I downloaded yesterday: This Modification will display a small copyright-notice "Template-Modifications by TMS" in the footer of your forum. According to the license agreement for this modification, you are not allowed to remove this copyright notice! If you want a branding free version, please contact me (andreas.kirbach@gmxpro.de).

fly
06-06-2008, 04:02 PM
I'm a little surprised at the dismissive pushback here. I thought I was presenting my concerns clearly and respectfully.

First of all, when I said "The wording strongly implies that the theming of my vBulletin site was also done by TMS", what I meant was, this statement will lead someone who is not familiar with vBulletin software to believe that the branding customizations to my vBulletin site/forum was done by some person or group called "TMS". Obviously the statement as you have it written is factually correct, but it's also misleading, especially on sites that are not related to software, vBulletin or otherwise. If you don't see that as a potential issue or problem, then I suppose we really do lack common ground on this issue.

Secondly, this is what is actually written in the version of the readme.txt that I downloaded yesterday:

Excuse me while I get in the middle of a conversation I have nothing to do with...

He read your post and doesn't want to do it. Isn't that his right?

Andreas
06-06-2008, 04:25 PM
@silurius
Hoenstly, I really don't see a problem with the wording - it isn't much different from the vBulletin branding itself.
Though you can change it to "Template-Modifications powered by TMS", "Templates managed with TMS", or smth. like this (approval required!) if it makes you feel better.

silurius
06-06-2008, 08:00 PM
Of course it's his right, flypaper. Did it really seem that I suggested otherwise? I have no emotional attachment to any of this and was simply pointing out something I felt was a potential issue and making a suggestion. I also failed to locate where the text is stored in the footer template and in phrases, when I thought I'd edit it a little, which was actually the primary motivation to post about it in the first place. And obviously, if I had wanted to opt out altogether I'd have emailed Andreas instead.

Sorry to stir up the ant's nest! Honestly, I didn't think it would become such a big deal.

phuongdp
06-07-2008, 07:14 AM
Thanks very much!

deepmob
06-10-2008, 02:39 PM
when i am trying to uninstall this mode, then i am getting this error

Entferne alle Eintr?ge f?r Template-Modifikationen ... Done!
Entferne alle Template-Modifikationen aus den Templates ...
Warning: Unknown([path]/includes/adminfunctions_templateedits.php): failed to open stream: No such file or directory in [path]/admincp/plugin.php(1512) : eval()'d code on line 10

Fatal error: (null)(): Failed opening required '/home/content/d/e/e/deepmob/html/includes/adminfunctions_templateedits.php' (include_path='.:/usr/local/lib/php') in /home/content/d/e/e/deepmob/html/admincp/plugin.php(1512) : eval()'d code on line 10

Andreas
06-10-2008, 02:59 PM
If you follow the installation and uninstallation instructions correctly you will not get this error.

Tulsa
06-15-2008, 01:28 AM
Hi

IM running the latest version of TMS and Vb3.7

while attempting to make template modifications. although it saves the template modifications it does not update the template.
therefore although it shows there is a template modification none is made?

I also deleted a modification as a test and even though it is deleted it remains active?
not showing in the tms but active nonetheless on the board

what am i missing?

Andreas
06-15-2008, 07:51 PM
Most likely you have a broken template conditional and thus the template fails to compile, cannot be saved.

Try to open the template in style manager and save it again - do you get an error?

srkrocks
06-20-2008, 03:50 PM
Installed!

Spurcell
06-21-2008, 02:10 PM
I have uninstalled this mod and would like to know how to remove the branding from my site. Why does it remain after uninstallation?

Andreas
06-22-2008, 08:38 AM
Hmm ... it should not, but that might be a bug - will check that out.

To get rid of it:
- If your footer template is customized - open it and save it again
- If your footer template is inherited from MASTER style, import MASTER style again.

germinus
06-22-2008, 11:02 AM
Can this be used on 3.7.x

Andreas
06-22-2008, 11:33 AM
I don't answer questions from users who don't even care to completey read the first post.

Mrdby
06-26-2008, 11:33 AM
good to go 3.7.2?

BANDiT600
06-26-2008, 11:54 AM
Mrdby, yes, seems it's working...;)

Mrdby
06-28-2008, 01:41 AM
Mrdby, yes, seems it's working...;)

thanks!!!!

Mrdby
06-28-2008, 01:47 AM
when trying to edit and clicking on GO. it does not open my styles. Please advise!

Kinneas
07-24-2008, 01:48 PM
Wow,

Can't believe I haven't come across this before. This could have saved me hours of work :P

Thanks a lot!

EvilJohn
08-10-2008, 12:11 AM
Thank you. I don't think I fully understand what I have with this mod. But if it helps me with vb upgrades, and reverts. Then its found gold. Thanks

Masiello
08-27-2008, 05:59 AM
I don't answer questions from users who don't even care to completey read the first post.
This is anyway an answer LoL.

Anyway at first post he says: Yes it works on vB 3.7.

But isn't the same if you ask for 3.7.3 I think...anyboy tried on that version?

Icy
08-27-2008, 06:07 AM
anyboy tried on that version?
Yeah! Works fine for me :)

Kinneas
08-27-2008, 12:24 PM
Works fine.

Mrdby
08-29-2008, 08:42 AM
can we get an update?

fly
08-29-2008, 12:32 PM
can we get an update?

What else would you like it to do?

TriMe
09-20-2008, 03:12 PM
What should I do if I have template edits already and want to install this mod? Do I have to uninstall revert the templates and start from scratch to make this mod beneficial?

fly
09-20-2008, 03:41 PM
What should I do if I have template edits already and want to install this mod? Do I have to uninstall revert the templates and start from scratch to make this mod beneficial?

Yes, and you'll thank yourself when you're done. Trust me. Makes upgrades soooooo easy.

TriMe
09-20-2008, 04:16 PM
Yes, and you'll thank yourself when you're done. Trust me. Makes upgrades soooooo easy.

Crap. I was affaid someone was going to say that. :(

TriMe
09-20-2008, 05:11 PM
Can someone post some easy to follow steps for using this mod with template edits in place?

fly
09-20-2008, 05:33 PM
Can someone post some easy to follow steps for using this mod with template edits in place?

You can just use it for all new template edits if you want. But dude, this thing is awesome for updates. Its really worth it...

TriMe
09-20-2008, 05:40 PM
I would love to use this, but there isn't any good documentation on what to do or how it's used once installed.

SuperTaz
09-23-2008, 07:00 AM
I take it that version 1.1.2 is compatible with 3.7.3 PL1? or no?

Black Tiger
09-23-2008, 01:30 PM
Yes it does.

ExTincTi0N
09-24-2008, 12:32 AM
Will this come out for 3.7?

Black Tiger
09-24-2008, 12:56 AM
Seems reading is difficult for some people.:)
vBulletin Compatibility
Those asking for a vBulletin 3.7 release will be feathered, tared and blown up - this is the vBulletin 3.7 release.
The same goes for those asking if it is compatible with vBulletin 3.6.whatever - it is compatible.

Black Tiger
09-26-2008, 01:07 PM
I would love to use this, but there isn't any good documentation on what to do or how it's used once installed.
What documentation do you need? If there are template edits, it always have this kind of documentation in the mod you download: "get this template, find this line, below it add that line" or "find such and replace with this".

Now take your TMS, just do exactly the same as you would with a normal template edit.
In the first box you place the text you have to find in the template.
Then, on the left side you have a selection box to choose from "place above, replace with and place below".
And last on the second box, you place the text which should come above, below or instead off. That's all!

Believe flypaper and believe me. First you do a couple, then you get use to it, and after that (especially when upgrading) you ask yourself why this is not a standard option in vBulletin.
It saves you HOURS of work when you have a lot of mods.

Crap. I was affaid someone was going to say that. :(
Then why ask the question? He is right you know. Just try with a couple of mods.
The nice thing is that you can do them one by one. A few today, another few tomorrow. You don't need to convert them all at once. So you can do it in your own time.
And if you're done, the first forum upgrade you will perform, you will indeed thank yourself.

fly
09-29-2008, 12:26 AM
hmmm...

After upgrading, I'm no longer seeing all my templates with TMS enabled. I had this issue before, but am unable to find what I had to change last time. Cant find it in this thread, nor in PMs. Andreas?

fly
09-29-2008, 12:34 AM
I can only assume that output_buffering is too low (4 KB).
As this is a php.ini setting and can't be changed at runtime, there is not much I could do.

Ah-ha! This was it. I originally changed it to 8k, which worked at the time. I tried doubling it again to 16k, but that didn't work (neither did setting it back to 4k). Any suggestions?

Andreas
10-01-2008, 06:27 AM
The whole page needs to be in the buffer, so I'd say you need at least 50K.

fly
10-01-2008, 06:47 PM
The whole page needs to be in the buffer, so I'd say you need at least 50K.

Instead of setting a hard limit, I just set it to 'On' and I also tried 128k. When I did that, I got even weirder results: A white page with text, but no templates at all. Since I can't get it working with this latest update, and I can't live without TMS, I have disabled output buffering. If you have any other suggestions, I'd love to hear em. Thanks!

aharown07
10-04-2008, 02:14 PM
Recently installed TMS but after playing around and reading a good bit I still can't figure out how to use it.
For example... the FAQ here says only customized templates can be modified using TMS... but isn't customizing a template the same thing as modifying it? Isn't customizing it what TMS is for? Clearly, I'm not clear on the concept. Can someone enlighten me?

All I really want to do is add code to templates (maybe sometimes change or remove code) to get the right look for the website... and have some easier way to keep it all intact when doing all those vB upgrades. From those who recommended TMS to me I got the impression that was what TMS is for.

fly
10-04-2008, 07:02 PM
Recently installed TMS but after playing around and reading a good bit I still can't figure out how to use it.
For example... the FAQ here says only customized templates can be modified using TMS... but isn't customizing a template the same thing as modifying it? Isn't customizing it what TMS is for? Clearly, I'm not clear on the concept. Can someone enlighten me?

All I really want to do is add code to templates (maybe sometimes change or remove code) to get the right look for the website... and have some easier way to keep it all intact when doing all those vB upgrades. From those who recommended TMS to me I got the impression that was what TMS is for.

Did you install it? Did you click on the Template-Modifications Manager? It's pretty straightforward and will do exactly what you want.

Black Tiger
10-04-2008, 08:46 PM
the FAQ here says only customized templates can be modified using TMS.
Yes that's a bit a strange explanation in the faq. It means that you can only change templates with TMS which are made with TMS as far as I understood it.
So yes, TMS is for customizing. You leave the original templates intact and with TMS you make the changes, which are in fact virtual changes because nothings really get's edited in the original templates.
That's what's making upgrading so easy afterwards.:)

You just have to open the Styles and templates section, choose Template Modification Manager and then on the right side select "add template modification".

dartho
10-04-2008, 10:32 PM
the FAQ here says only customized templates can be modified using TMS.

If you wish to use TMS to modify templates in a specific style, only customised templates can be changed with TMS. Most custom/additional styles will have customised templates which differ from the default MASTER style.

Otherwise use TMS to modify the MASTER style to make changes to default temapltes across all styles that use them.

aharown07
10-05-2008, 04:58 PM
I think I get it now, but just to confirm: what you have to do is make new templates using TMS and then, therafter, you can edit/modify the new ones you made? ... but I could use it to modify Master style templates if for some reason wanted to do that?
But making new ones works for me. Will have to give it go later today or tomorrow and see if I really know how to do that.

Thanks for the help.

I'm also not clear on some of parameters, vars and such, but I think if I RTF(abulous)M some more the vars concept will click.

fly
10-05-2008, 05:09 PM
I think I get it now, but just to confirm: what you have to do is make new templates using TMS and then, therafter, you can edit/modify the new ones you made? ... but I could use it to modify Master style templates if for some reason wanted to do that?
But making new ones works for me. Will have to give it go later today or tomorrow and see if I really know how to do that.

Thanks for the help.

I'm also not clear on some of parameters, vars and such, but I think if I RTF(abulous)M some more the vars concept will click.

No, you use it to modify the DEFAULT vB templates. ALL of my TMS edits are done to the Master style.

aharown07
10-06-2008, 01:01 AM
OK, I went into the Template Modifications Manager.
Selected Add Template Modifation from the Default Style dropdown and clicked Go.
On that form, the Product is set to vBulletin by default. Left it as it was.
The template I want to modify is navbarheader, so I selected that from the Template dropdown.
Gave it a title and a varname.

Now I don't really know what search and replace is for. Just want to paste some stuff in the template.
Didn't know what else to do at that point, so clicked Save.
Error appears: Please select the processing mode. No idea what is. I don't see anything on the form that says "Processing mode" and wouldn't know what to select if it did.

So what am I doing wrong? ... and tell me again how straightforward this is? :D
I'm convinced this is worth figuring out but it's apparently gonna take some figuring.

fly
10-06-2008, 09:16 AM
OK, I went into the Template Modifications Manager.
Selected Add Template Modifation from the Default Style dropdown and clicked Go.
On that form, the Product is set to vBulletin by default. Left it as it was.
The template I want to modify is navbarheader, so I selected that from the Template dropdown.
Gave it a title and a varname.

Now I don't really know what search and replace is for. Just want to paste some stuff in the template.
Didn't know what else to do at that point, so clicked Save.
Error appears: Please select the processing mode. No idea what is. I don't see anything on the form that says "Processing mode" and wouldn't know what to select if it did.

So what am I doing wrong? ... and tell me again how straightforward this is? :D
I'm convinced this is worth figuring out but it's apparently gonna take some figuring.

Have you ever done a template edit for a hack? Find this, replace with that? Find this, enter this below it? etc?

aharown07
10-07-2008, 01:10 PM
Have you ever done a template edit for a hack? Find this, replace with that? Find this, enter this below it? etc?

Mostly I've commented out code, pasted in new code, etc. But when I did that in the situation I described above, I still got "Please select the processing mode."
What's that?

aharown07
10-10-2008, 01:35 AM
Mostly I've commented out code, pasted in new code, etc. But when I did that in the situation I described above, I still got "Please select the processing mode."
What's that?

I think I figured out what "processing mode" is. It's maybe the blank dropdown that appears on the left side of the Edit Template Modification form above the "Large Edit Box" button? Seems that if I select something there before I click Save, I don't get the error.
But the template doesn't seem to be modified either... at least, when I display it afterwards, it looks the same as it did before.
I'm afraid I'm not finding the form intuitive at all. A step by step guide would sure be helpful.

fly
10-10-2008, 01:44 AM
But thats the point, the template itself remains the same, so upgrades happen flawlessly. I'm really not sure how it could be explained better. Maybe you should stick to template edits... :P

dartho
10-10-2008, 04:00 AM
TMS (Template Modification System" is a tool for making modifications to existing templates.

Lets say you have a vbulletin template which had the following line in it:


<div>This is the title!</div>


and you wanted to modify this template so that the phrase "This is the title!" was bolded.

You could simple edit the template and add appropriate tags, and viola - it would be done. However, a future version of vbulletin may update that template and then you would need to re-apply the edits.

Using TMS, you can 'Search for Text' <div>This is the title!</div> and choose to 'Replace with Text' <div><strong>This is the title!</strong></div>

and TMS will edit your template for you.

If a future release of vBulletin modifies that template, your edit will remain - if it modifies the section of teh template you have edited, you will be alerted to this and will then be able to easily update your TMS edits.

I have a heavily customised site based on the default style - ALL of it is done with TMS - my last upgrade required zero additional effort other than uploading files and running the upgrade script.

Learn how to use it - you'll be glad you did!

aharown07
10-10-2008, 02:06 PM
Thanks for your patience! I think I get it now... but really this time. http://www.freesmileys.org/smileys/basic/dunce.gif (http://www.freesmileys.org)

You don't really change the templates, you store your changes and TMS applies them as though you changed the template.
So... TMS doesn't actually "modify templates." That's what was tripping me up... I'm just way, way too literal at times (ADHD? autism? Nah... just a nutcase). Seriously though, who would have thought "Template Modification System" was a "system for avoiding actual modifications to templates"?

I definitely see that avoiding actually changing the templates is the advantage though.
So... since I have a number of templates already edited, what I could do now is put those edits in text files temporarily, revert all the templates and then use TMS to faux-modify them. Then, going forward, vBulletin just sees unmodified templates and upgrades them normally while TMS continues applying my "modifications."

A couple questions though: what happens if...
1. My "insert after" string is not unique... will TMS apply my new code more than once?
2. A future template upgrade by vB removes/alters the string I placed my modification in place of/after/before?

aharown07
10-10-2008, 02:10 PM
2. A future template upgrade by vB removes/alters the string I placed my modification in place of/after/before?
This one's already been answered... it notifies you at upgrade time.

Black Tiger
10-10-2008, 02:26 PM
1.) I'm not sure about that, but if it's not unique, just paste more code in the "search for" window (the upper window) so that it -is- unique. If done that way, you are always sure it only changes the one thing you want changed.

2.) vB upgrade will change nothing of your TMS system. If a template get changed by vBulletin this is what happens:
a.) You upgrade your vbulletin
b.) You login to your admincp
c.) TMS system will doe a check automatically or at least if you refresh your screen once. Then it will see things are changed, you get a list of OK templates which you changed in TMS, but the templates which are change by vBulletin will get a sign that it's not oke, you will get notified.
d.) You check the original vB template for the changed code and change the changed code in your TMS system.
e.) Rerun the template check from TMS and all will be fine.

lgnd
10-12-2008, 08:24 PM
Thanks for this great mod! Installed and nominated!

fly
10-12-2008, 08:35 PM
Instead of setting a hard limit, I just set it to 'On' and I also tried 128k. When I did that, I got even weirder results: A white page with text, but no templates at all. Since I can't get it working with this latest update, and I can't live without TMS, I have disabled output buffering. If you have any other suggestions, I'd love to hear em. Thanks!

Okay, even with output buffering disabled, I am unable to add a new style. If you have any time to look at this, I'd really appreciate it. In the meantime, it looks like I can disable the hack, add a new style, and reenable it.

aharown07
10-17-2008, 05:34 PM
I think I have the concept now, but some how-to is still eluding me.
I want to change the way the private message quota progress bar displays. I'm told this is in the pm_messagelist template.

So I go to the Template Modifications Manager and select "Add Template Modification" under Default style.
Problem: the Template dropdown doesn't show pm_messagelist as an opition... in fact it only shows a dozen or so templates.
This must have something to do w/what I was discussing earlier... can only modify customized templates? But I got the impression there was no need to create a new style, so not sure where to go next.

fly
10-17-2008, 06:10 PM
Sounds like you're running into the same problem that I had. My output_buffer was set too low. iirc, thats a apache config, check with your host...

I'm still having problems with it when adding styles, but I just disable TMS, add the style, and re-enable TMS.

dartho
10-17-2008, 09:02 PM
You should make template modifications under MASTER STYLE

dodjer42
10-24-2008, 06:52 AM
Can this be used after templates have already been modified? Or is it meant for a fresh install?

fly
10-24-2008, 09:18 AM
Check one or two pages back for a whole conversation on that. Yes.

Black Tiger
10-24-2008, 10:43 AM
Can this be used after templates have already been modified?
This is the "yes" part.:)

Mondi
11-04-2008, 06:13 AM
Hey all:

Two things:

Thanks for great mod - just installed it and I can see this working for us at GBLCG.com.

However - thing II - I am now receiving the following error message on all pages:

Unexpected Call to Method or Property Access

See Attachment.

Any wisdom on how to tackle this pesky little issue welcomed with joy!

Cheers!

dartho
11-07-2008, 09:56 PM
I'm testing a 3.8 beta2 upgrade. I had had TMS 1.0.0 installed, after upgrading the site to 3.8b2 (from 3.7.2 PL1) editing a Template Modification resulted in it disappearing/being deleted without warning

I exported the template edits from my live site, upgraded test site to TMS to 1.1.4, truncated the "templateedit" table in the DB, imported template edits (ignoring version and allowing overwrite) and tried again. The same thing happens.

Edit: I've got Mysql Version 5.0.51a. I noticed on vb-germany that you mention that it only with MySQL 4.1.x version 4.1.10 and MySQL 5.0.x version 5.0.3. Could this be the issue?

Andreas
11-15-2008, 11:40 AM
No, it's a 3.8 issue.
An updated package will be released soon.

dartho
11-15-2008, 10:23 PM
Excellent, thank you.

Vinyljunky
11-18-2008, 02:30 PM
Great mod installed and working for some time now :up:

Id like to use it for the VBStatus (https://vborg.vbsupport.ru/showthread.php?t=181283) template mods such as:


Template Edit 1: headinclude

Add the Following HTML code to the BOTTOM of your template:

<!--BEGIN VBSTATUS-->
<!--BEGIN VBSTATUS-->
<!--BEGIN VBSTATUS-->
<if condition="$vbulletin->options['vbstatus_active']">
<div id='mypopup' name='mypopup' style='z-index:1000; position: absolute; background: none; border: none;'></div>
<script type="text/javascript" src="vbstatus/ajax_wrapper.js"></script>

<script type="text/javascript" src="vbstatus/headerjavascript.js"></script>
</if>
<!--END VBSTATUS-->
<!--END VBSTATUS-->
<!--END VBSTATUS-->

How do I get TMS to add the code at the bottom?

Thanks :o

thincom2000
11-21-2008, 05:07 PM
No, it's a 3.8 issue.
An updated package will be released soon.

Yeah, they aren't deleted, they are just saved with a styleid = 0. In the update GPC list, ismaster was TYPE_NOOL, and styleid was TYPE_UINT. I had made a few changes to the product a while back to fix some content encoding issues I was having, but I don't think I messed with this.

Changing these to TYPE_BOOL and TYPE_INT respectively fixed any further "disappearances" in 3.8 for me.

fly
11-21-2008, 05:16 PM
No, it's a 3.8 issue.
An updated package will be released soon.

Any chance you've seen my posts and think its something you might be able to fix in this next version?

https://vborg.vbsupport.ru/showpost.php?p=1643601&postcount=409

momo2
11-27-2008, 05:30 PM
Also how do i get rid of the footer advertising for tms

Vinyljunky
11-28-2008, 09:37 AM
Great mod installed and working for some time now :up:

Id like to use it for the VBStatus (https://vborg.vbsupport.ru/showthread.php?t=181283) template mods such as:


Template Edit 1: headinclude

Add the Following HTML code to the BOTTOM of your template:

<!--BEGIN VBSTATUS-->
<!--BEGIN VBSTATUS-->
<!--BEGIN VBSTATUS-->
<if condition="$vbulletin->options['vbstatus_active']">
<div id='mypopup' name='mypopup' style='z-index:1000; position: absolute; background: none; border: none;'></div>
<script type="text/javascript" src="vbstatus/ajax_wrapper.js"></script>

<script type="text/javascript" src="vbstatus/headerjavascript.js"></script>
</if>
<!--END VBSTATUS-->
<!--END VBSTATUS-->
<!--END VBSTATUS-->

How do I get TMS to add the code at the bottom?

Thanks :o

Any ideas to answer the above would be very welcome :)

In short: How do I get TMS to add stuff to the bottom of a template?

Thanks

VJ

K4GAP
12-01-2008, 02:41 PM
I am like so many vb'ers in that I frequent this board looking for something to make my life easier as both a license holder and fan of Vbulletin.

My question is this...

I have a heavily modded style that I have played with and tweaked for months. I also have a bunch of mods installed. If I install this "TMS" what problems are there that I am likely to encounter?

dartho
12-02-2008, 08:58 AM
Andreas - is there a manual work around to the 3.8 incompatibility?

Any ideas to answer the above would be very welcome :)

In short: How do I get TMS to add stuff to the bottom of a template?

Thanks

VJ
Search for
<!-- logo --> and add below

-or-

I've attached my vBstatusTMS edits - try importing this

Deepdog009
12-02-2008, 10:57 PM
Great Mod Andreas... Updating templates without it,,, is a pain in the A$$...;)

drsli
12-07-2008, 10:13 AM
I simply love this modification and for me it?s definitely the most important enhancement for any vb-upgrade. I just can say "Thankyou so much" for giving us this tool.

Changing these to TYPE_BOOL and TYPE_INT respectively fixed any further "disappearances" in 3.8 for me.
Could you please explain the steps to do this for a non-programmer, if it?s not too much striking out? I don?t fear to change any code, but I don?t know where to search for this type-variants.

I came across the same issues with diminishing template-edits, searched my database and found the described styleid-variable in the database. But in the end I made a switch back to 3.74pl1 to be safe with TMS.

dartho
12-07-2008, 11:07 PM
I've not tested this personally yet, but thincom2000 was referring to the templateedits.php file. TO apply his/her 'fixes' for version 1.1.4:

Edit the admincp/templateedits.php file, search for :

// update a modified templateedit
if ($_REQUEST['do'] == 'update')
{
$vbulletin->input->clean_array_gpc('p', array(
'searchorder' => TYPE_UINT,
'searchstr' => TYPE_NOTRIM,
'replacestr' => TYPE_NOTRIM,
'styleid' => TYPE_UINT,
'oldtemplate' => TYPE_STR,
'template' => TYPE_STR,
'title' => TYPE_NOHTML,
'oldproduct' => TYPE_STR,
'product' => TYPE_STR,
'varname' => TYPE_STR,
'oldvarname' => TYPE_STR,
'templateeditid' => TYPE_INT,
'templateeditlocationid' => TYPE_INT,
'method' => TYPE_STR,
'active' => TYPE_BOOL,
'ismaster' => TYPE_NOOL
));


and replace with


// update a modified templateedit
if ($_REQUEST['do'] == 'update')
{
$vbulletin->input->clean_array_gpc('p', array(
'searchorder' => TYPE_UINT,
'searchstr' => TYPE_NOTRIM,
'replacestr' => TYPE_NOTRIM,
'styleid' => TYPE_INT,
'oldtemplate' => TYPE_STR,
'template' => TYPE_STR,
'title' => TYPE_NOHTML,
'oldproduct' => TYPE_STR,
'product' => TYPE_STR,
'varname' => TYPE_STR,
'oldvarname' => TYPE_STR,
'templateeditid' => TYPE_INT,
'templateeditlocationid' => TYPE_INT,
'method' => TYPE_STR,
'active' => TYPE_BOOL,
'ismaster' => TYPE_BOOL
));

dartho
12-08-2008, 03:21 AM
After initial testing on a NOT LIVE site, the above change by Thincom2000 appears to address the issues under 3.8RC1.

drsli
12-08-2008, 11:01 AM
Thank you very much, dartho, for these infos! :)

fly
12-17-2008, 07:55 PM
Any chance you've seen my posts and think its something you might be able to fix in this next version?

https://vborg.vbsupport.ru/showpost.php?p=1643601&postcount=409

BTW if you care, I changed a bunch of things and now everything seems to work. Don't know what fixed it.

- Upgraded to 3.7PL1
- Upgraded TMS
- Disabled output_buffering (According to this (http://www.vbulletin.com/forum/showthread.php?t=46821) it should be off if I have gzip enabled)
- Prolly some other stuff that I forget

fly
12-17-2008, 08:28 PM
Can anyone confirm or deny this bug?

Attempt to create a new template mod (under vBulletin), select a template (I used navbar), click 'View Template', when the template shows up at the bottom - attempt to use the search feature and look for 'hello'. I get the following error:

Not Found

The requested URL /admincp/.php was not found on this server.

dartho
12-17-2008, 11:02 PM
not happening under TMS 1.1.4

momo2
12-21-2008, 03:43 AM
this does not work at my forums, can it be it does not work on 3.7 versions ? also the footer showing ur site !!! how to get rid of it !!! its not like saying about ur hack, its more that driving traffic to ur site !!!! its not like saying your copy right but its more like getting 1 million visitors heading ur site.. hacked removed !!!!

MrZeropage
12-21-2008, 05:58 PM
TMS is the most useful thing I ever met.

You can buy a branding-free-license to remove the (linked) copyright-footer.

It works fine on vBulletin 3.7.4PL1 :)

Andreas
12-23-2008, 06:56 PM
@flypaper
Hmm, I havn't been able to reproduce this yet, but sounds like a JavaScript problem.

@momo2
It works just fine with 3.6.x, 3.7.x - I used it on dozens of production sites (both 3.6 and 3.7).
I did not extensively test it (yet), but it should also work just fin with 3.8 RC 2

momo2
01-04-2009, 12:02 AM
Adereas, it does work but not with all the skins, but my main, complaint is why u have tm showing in my footer, which i have no problem with as long it goes to this post, or to ur hack post in ur site, but than again u what i am saying..

Andreas
01-04-2009, 03:34 PM
TMS works with any style. However, if there are customized templates in your style you might have to customize the template modifications as well.

Stoebi
01-04-2009, 03:36 PM
Works fine with 3.8 RC2 also.

PhilMcKrackon
01-06-2009, 01:46 PM
This looks great. One question though.

I understand that only templates that have been customized (changed) can be added to the TMS. Lets say I have a template setup like this.

Master Style
-- Default Style
-- Custom Fluid
-- Custom Fixed

I want to remove all the custom edits to the fluid and fixed styles and add them to the TMS.

If I add the edits needed to the fixed and fluid styles to match the hand edits I have already done, is it necessary to revert the fixed and fluid styles? Or, does TMS simply apply the edits to the originals and output the template correctly?

The reason I ask, is after trying a simple edit - I reverted the template and the 'test' failed.

Thank you,

Andreas
01-06-2009, 04:25 PM
To convert manually modified templates to TMS:

1) Find out a single change in the affected template
2) In Template Modifications Manager select 'Add Template-Modification' from the MASTER style dropdown
3) Select the Template, enter a descriptive title (eg. Add link to Chat), a varname, search and replace text
4) Hit save

Repeat these steps as necessary.
Once you've done with all modifications, create a new style with no parent style.
Test the modifications. If they all pass, select the style in frontend and check if it does what it should do.
If so, you can revert the template.

PhilMcKrackon
01-06-2009, 04:33 PM
Thanks for the fast reply.

Just another clarification if I may ask.

Using the example above.

Master Style
-- Default Style
-- Custom Fluid
-- Custom Fixed

If I change the Master Style, won't it affect all three other styles (default, fluid and fixed)? They all have different customizations.

Sorry if these questions are a little mundane, I can PHP code pretty well but I had my site style designed by a third party.

Thank you,

Andreas
01-07-2009, 03:38 AM
Yes, it does. If you want different template modifications in different styles you must add or customized them there (whih means that the templates must be customized as well as otherwise the styles just use a virtual copy of the inherited template, eg. a real copy of the template does not exist in this case - which makes it impossible to apply modifications that are different from the inherited style).

PhilMcKrackon
01-07-2009, 08:42 AM
Yes, it does. If you want different template modifications in different styles you must add or customized them there (whih means that the templates must be customized as well as otherwise the styles just use a virtual copy of the inherited template, eg. a real copy of the template does not exist in this case - which makes it impossible to apply modifications that are different from the inherited style).
Thanks for the confirmation, this is a great product!

HossMon
01-07-2009, 06:03 PM
Amazing little tool!
One question...
What is the difference between the 1-1-4 and 1-1-5 engines?
It's not explained and I saw no real info on this anywhere in the thread.

Smitty
01-07-2009, 06:27 PM
See the first post - If you use MySQL 4.1 series, MySQL 4.1.10 or higher is required
If you use MySQL 5.0 seriesn, MySQL 5.0.3 or higher is required

Andreas
01-08-2009, 06:35 AM
@HossMon
Take a look at the first post @ Version History

dartho
01-14-2009, 09:33 AM
I've just upgraded my live site to vBulletin 3.8.0 and also upgraded to TMS 1.1.5. (from 1.0.0)

And it all went well! :)

I have a TMS rule at add the 'vbstatus' add-on code to my postbit_legacy template.

When I 'Test Template Modifications', it shows no tick in the test results column, and suggests I need to Edit this rule. However - the template edit rule is still being applied successfully. How can this be so? Even if I go in to edit it and save, still works even though I changed nothing and the test result is negative?

I'm sure I am missing something, but am unsure as to what...

KevinL
01-14-2009, 01:03 PM
This is probably one of the best mods ever made. I honestly don't know how it's not a default part of vb :confused:

Black Tiger
01-15-2009, 05:59 PM
I never asked before, but how does TMS effect the page load?

ragtek
01-15-2009, 06:21 PM
There is no code being executed in frontend, that means no performacne cost.
The code is only executed once in ACP.

So it is much better, then str_replace or $headinclude .= $mytemplate

Black Tiger
01-15-2009, 06:59 PM
Correct, but it changes templates in the acp, like building a kind of shell around it or whatever. It has to load the templates and then make the changes, correct?

So somewhere it must make an effort or do some work to get it right. Maybe a bit higher cpu usage then?

Or is there really no performance loss at all?
Is it equal to having template edits made? (beside from the benefits when using TMS, especially when upgrading).

KevinL
01-15-2009, 07:12 PM
I've noticed no performance loss at all.

Like I said before, it is really one of the best mods ever on .org

dartho
01-15-2009, 07:20 PM
I believe when you edit a template with TMS, teh ccompiled versiuon in the database gets updated with your changes so teh only server load at all is when you create your TMS changes. There is no 'run time' code execution when pages which use modified templates are viewed. Or something like that...

Black Tiger
01-15-2009, 07:39 PM
Oh man... that is even better then I thought!
I asked this for somebody else with a bit bigger forum then I have myself. Because I have TMS running for more then a year now and I'm SOOOOO happy Andreas made this.
If any... then -this- mod should simply be standard included in vBulletin.

Thank you all three, for your quick answers/help!

Andreas
01-16-2009, 03:23 PM
I believe when you edit a template with TMS, teh ccompiled versiuon in the database gets updated with your changes so teh only server load at all is when you create your TMS changes. There is no 'run time' code execution when pages which use modified templates are viewed. Or something like that...
Correct. TMS hooks into the compile process and modifies the templates before they are being saved to the database.
There is no single line of code being executed in frontend (eg. zero overhead), it behaves just as if the templates were modified manually.
TMS executes code soley within ACP, mainly when templates are being customized/edited, styles uploaded, products installed, etc.

Black Tiger
01-16-2009, 03:53 PM
Very cool! You really found a hole in the mod-market, best mod ever!:)
Thanks!

lgnd
01-18-2009, 02:44 PM
Sorry for my beginner question but how can I update from 1.1.4 to 1.1.5. without messing up something?
Thanks!

Rene Kriest
01-18-2009, 03:00 PM
Sorry for my beginner question but how can I update from 1.1.4 to 1.1.5. without messing up something?
Thanks!
Just mark "overwrite" while installing via AdminCP that's all.

Andreas
01-18-2009, 03:01 PM
As you would update any modification:
Overwrite the files, import the XML - done.

Black Tiger
01-18-2009, 03:07 PM
And when importing the xml, don't forget to put the "overwrite" selection to "yes: .;)

lgnd
01-18-2009, 03:42 PM
^^Thanks all for your quick reply! ^^

djbaxter
01-21-2009, 05:11 PM
Please see http://www.vbulletin.com/forum/project.php?issueid=27187 for details.

This bug is consistently reproducible on my installation of 3.80.

I have determined that it is this template that was producing the bug. Basically, with this add-on enabled, the list of templates shown from Edit Templates is abbreviated unless I click on "Expand all". When I disable the add-on, I can see the full list again.

This is an extremely useful add-on. I hope you can find a fix for this.

Andreas
01-21-2009, 06:43 PM
Sounds like yet another "strange gzip/output buffering configuration" problem.
Sorry, this can't be reproduced and I an therefore unable to help you.
Feel free to send me a PM with all required logins (ACP, FTP, PMA) and i'll take a look.

djbaxter
01-21-2009, 11:23 PM
Sounds like yet another "strange gzip/output buffering configuration" problem.

What does "strange gzip/output buffering configuration problem" mean? Does enabling gzip pose a problem for this add-on? What about eaccelerator?

Nadeemjp
01-21-2009, 11:34 PM
is this only for hack writers or everyone can use it? and can people like me with no knowledge at all of html or similar stuff, use this?

Andreas
01-22-2009, 04:29 AM
What does "strange gzip/output buffering configuration problem" mean? Does enabling gzip pose a problem for this add-on? What about eaccelerator?
No. But somewhat strange configurations (eg. gzip enabled in vBulletin and output_hander set to ob_gzhander(), zlib.output_compression enabled and mod_deflate enabled, output_buffer way to small, etc.) can cause such issues.
I am using TMS on about 80+ production forums with eAccelerator without a single problem.

RedeemedWarrior
01-22-2009, 04:31 AM
very cool mod :D

i'm using it on my forum very handy indeed

djbaxter
01-22-2009, 04:35 AM
No. But somewhat strange configurations (eg. gzip enabled in vBulletin and output_hander set to ob_gzhander(), zlib.output_compression enabled and mod_deflate enabled, output_buffer way to small, etc.) can cause such issues.
I am using TMS on about 80+ production forums with eAccelerator without a single problem.

With or without gzip enabled, enabling this add-on truncates the templates list,

Andreas
01-22-2009, 10:30 AM
As said, I can't reproduce the problem and am therefore unable to help you.
So I can only suggest to uninstall it.
Sorry, but that's the only thing I can do.

Feel free to PM me all necessary logins and i'll take a look.

imaroot
01-30-2009, 09:52 AM
bookmark!
btw you got 2 attachment there what's the difference?

brvheart
01-30-2009, 04:47 PM
I have a few templates that show as active in status but not showing with a "Check Mark" and nothing that I do is allowing the template changes to take affect - ideas?

puertoblack2003
01-30-2009, 05:06 PM
i think this mod is causing some issues with my live board and decided to test it on my test board.after clean install i installed it and got this error.

Database error in vBulletin 3.8.1:

Invalid SQL:
REPLACE INTO templateedit (varname, styleid, searchstr, searchstrregex, replacestr, product, version) VALUES ('tmsbranding', -1, '$vbphrase[powered_by_vbulletin]', '\\$vbphrase\\[powered_by_vbulletin\\]', '$vbphrase[powered_by_vbulletin]<br />
Template-Modifications by <a href="https://vborg.vbsupport.ru/misc.php?do=producthelp&amp;pid=tms">TMS</a>', 'vbulletin', '3.6.0');

MySQL Error : Unknown column 'searchstrregex' in 'field list'
Error Number : 1054
Request Date : Friday, January 30th 2009 @ 02:02:48 PM
Error Date : Friday, January 30th 2009 @ 02:02:49 PM
Script : http:///vbtest/admincp/plugin.php?do=productimport
Referrer : http:///vbtest/admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.30-community-log

i checked in database and its there. on my live board i was having issue with the edited field and i was able to fix that.

ragtek
01-31-2009, 09:18 AM
bookmark!
btw you got 2 attachment there what's the difference?
1.1.5 is newer;)

Version History
1.1.5

* Fixed Bug: Fixed incorrect variable type
* New Feature: Box 'Template-Modifications' (shown on editing a template) can now be collapsed/expanded


1.1.4

* Fixed Bug: Fixed HTML error/XSS in Template Modifications Manager

jeffinj
02-01-2009, 03:54 AM
Great hack. Installed and Nominated. :)

jeffinj
02-01-2009, 03:57 AM
I got this error on installation:


Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT templateid, searchstrregex, replacestr
FROM vb_templateedit AS templateedit
INNER JOIN vb_templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname )
INNER JOIN vb_template AS template ON (template.title=templateeditlocation.template)
LEFT JOIN vb_style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))
LEFT JOIN vb_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_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, January 31st 2009 @ 11:53:52 PM
Error Date : Saturday, January 31st 2009 @ 11:53:53 PM
Script : http://www.xxxxxxxxxxxxxx.com/admincp/plugin.php?do=productimport
Referrer : http://www.xxxxxxxxxxxxxx.com/admincp/plugin.php?do=productadd
IP Address : -------------
Username : Jeff
Classname : vB_Database
MySQL Version : 5.0.67-community


Any idea what it is?

Andreas
02-01-2009, 11:10 AM
Yes, it is an illegal mix of collations :)

Fix your database and the error will disappear.

brvheart
02-01-2009, 03:14 PM
I have a few templates that show as active in status but not showing with a "Check Mark" and nothing that I do is allowing the template changes to take affect - ideas?

Andreas - any help on this please? -

EDIT - Nevermind I figured it out

jeffinj
02-02-2009, 07:13 AM
Yes, it is an illegal mix of collations :)

Fix your database and the error will disappear.

Thank you Andreas. I am not an expert though.

Is it as simple as going to cpanel > MySQL databases > Repair DB ? Could you simplify it for me? I can pm you my cpanel login details if it is required.

During installation, a few steps have already been completed. Wouldn't that be a problem when I do a second installation?

TandyServices
02-10-2009, 09:15 PM
I had to turn your mod off and forgot to turn it back on. I done the style that I now read that your were not to do. I have Database errors now.. I can not turn your mod on.. It will just give me database errors when I try to go into the admincp and It will not un-install same database errors? Plus I have errors all over the board.. The back up of the database I have is the same way.. What can I do??

Thanks

Phaedrus
02-18-2009, 03:56 AM
What was your database error?

Is it missing a table?

Videx
02-18-2009, 10:44 AM
On one of my boards it installed fine, on the other I get the infamous "MySQL Error : Illegal mix of collations" error. I've seen it listed here several times, but has anyone actually figured out what causes this and how to fix it?

Andreas
02-18-2009, 03:09 PM
Inconsistent database configuration causes this.
All your tables, the db, server, cleint and connection character sets should be the same

Videx
02-19-2009, 01:20 AM
Yes, on the forum where the install worked, every collation is latin1_swedish_ci. But on my other forum, many mods have installed tables with other collations. A quick glance shows vbClassified, Who Has Read a Thread, Addon Chat, and many others using other collations, latin1_general_ci being the most common.

So, if this is the problem, at least two questions come to mind.

1) How to fix it? Is there some query that will change everything to one collation? And is this going to break things?

2) After this mod is in place, can I safely install a mod like AddonChat that uses a different collation? What's going to break?

lgnd
02-22-2009, 11:01 AM
I have a grey background style and the "Template Modification by TMS" text is barely visible.
Found a great article http://www.vbulletin.com/forum/showthread.php?t=288491 I fixed the standard vb copyright text. Any help would be aprreciated to fix the TMS copyright text color. Thanks!

TaMpE
02-22-2009, 07:45 PM
sorry if this question has been answered. Couldn't manage to find the answer in 33 pages :\

I have installed this mod and I'm about to edit my template for another mod which needs template editing.

The mod I'm installing has only product XML and a read me file which has instructions on what templates to edit. So since I've installed this mod, TMS, where do I start the editing?

I tried clicking on "Edit Template_Modification" but it's not loading anything :\ I'm running vBulletin v3.7.4 Patch Level 1.

Thanks

Andreas
02-23-2009, 09:20 AM
Click Add Template-Modification, select the template and product, enter a title and variable name, paste the search- and replace text form the instructions and you're done.

TaMpE
02-23-2009, 08:50 PM
Click Add Template-Modification, select the template and product, enter a title and variable name, paste the search- and replace text form the instructions and you're done.

I'm almost there but there is one thing I don't understand,

what do I put in varname?

What I have to do now is in template "navbar" I have to:

$cyb_frules_link

after

vbphrase[faq]</a></td>

so what might my varname be :confused:

Black Tiger
02-23-2009, 09:13 PM
You can choose one you like.
For example you could make varname "cybfruleslink" so thatway you know, when searching the templates later, for which mod you made the entry.

TaMpE
02-24-2009, 12:51 AM
You can choose one you like.
For example you could make varname "cybfruleslink" so thatway you know, when searching the templates later, for which mod you made the entry.

Thank you mate, now it works better. I got a DB error when I tried to guess lol

Videx
02-24-2009, 02:05 AM
Over the weekend I changed every single table to latin1_swedish_ci manually. The db is set to latin1_swedish_ci. So why am I still getting the same error?
Database error in vBulletin 3.8.1:

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
Request Date : Monday, February 23rd 2009 @ 11:01:11 PM
Error Date : Monday, February 23rd 2009 @ 11:01:12 PM
Script : admincp/plugin.php?do=productimport
Referrer : admincp/plugin.php?do=productadd
Classname : vB_Database
MySQL Version : 4.1.22-standard-log

Andreas
02-24-2009, 06:57 AM
So why am I still getting the same error?

Check the collations for


templateeditlocation.varname
templateedit.varname
template.title
templateeditlocation.template
product.productid
templateeditlocation.product


Are they all the same?

Videx
02-24-2009, 10:08 AM
All the varnames are latin1.bin. template.title and product.productid is still general, despite the table itself now being swedish. Silly me, thinking changing a table would of course change it's contents!

So, should I try changing yet more items manually?

Andreas
02-24-2009, 11:11 AM
Make sure the columns used in the conditions are compatible (eg. templateeditlocation.varname=templateedit.varname, template.title=templateeditlocation.template and product.productid=templateeditlocation.product)

Videx
02-24-2009, 07:31 PM
Done, but I still get an error:Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT plugin.*,
IF(product.productid IS NULL, 0, 1) AS foundproduct,
IF(plugin.product = 'vbulletin', 1, product.active) AS productactive
FROM plugin AS plugin
LEFT JOIN product AS product ON(product.productid = plugin.product)
WHERE plugin.active = 1
AND plugin.phpcode <> ''
ORDER BY plugin.executionorder ASC;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Worse, when I checked my inbox a whole slew of cron errors were there, so I've set product.productid back to general:Invalid SQL:

SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1235509743 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='I wonder if I shouldn't be thinking more in terms of converting this entire db to something? But what? And how?

Andreas
02-25-2009, 04:02 AM
Well, all I can say is: Fix your database.

product.productid must be the compatible with plugin.product and cron.product (and phrase.product, setting.product, productcode.productid, faq.product, ... you get the idea?)
All those standard fields really should already be the same (otherwise you would have gotten errors earlier).
With a standard MySQL installation they will most likely be latin1_swedish_ci

I suggest to export your DB schema and attach it here, that would make it a lot easier to point out which fields/tables do have the wrong collation.

redraider
03-08-2009, 08:08 PM
Hi andreas, Thanks for this great modification. I have suddenly started getting a strange problem - There are a few template modifications that do not show inside "Master Style", but only in my customized styles, but when I click on the modification I get this error:

"The Template-Modification called 'Remove Navbar' can not be customized in this style because the template 'VBDRUPAL' is not customized in this style."

BUT my master style doesnt have a REMOVE NAVBAR modification listed ... how do I edit this ??

Please help!

Videx
03-14-2009, 10:34 AM
I finally managed to fix my illegal mix of collations. I posted the solution here (http://www.vbulletin.com/forum/showthread.php?p=1708020#post1708020).

TheSupportForum
03-14-2009, 05:35 PM
is therea tutorials to add own template edits to work with thisa program