vb.org Archive
Page 19 of 22 « First 91718 19 2021 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - Template Modification System (https://vborg.vbsupport.ru/showthread.php?t=152931)

fly 12-30-2011 12:34 PM
Quote:
Originally Posted by franks (Post 2282092)
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 12-30-2011 05:16 PM
I'm pretty sure your user name is fly, not Maxii.

fly 12-30-2011 08:36 PM
Quote:
Originally Posted by franks (Post 2282266)
I'm pretty sure your user name is fly, not Maxii.
:confused:

OldSchoolDSL 01-01-2012 01:42 AM
Code:
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 01-01-2012 03:18 AM
Quote:
Originally Posted by fcherub (Post 2248028)
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 01-02-2012 07:02 AM
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 01-22-2012 01:11 AM
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 01-22-2012 06:54 PM
What version you tried to install?

As said in first post:

Quote:
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 01-23-2012 05:02 AM
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 01-23-2012 12:44 PM
Quote:
Originally Posted by TombstoneWarrior (Post 2291272)
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 01-23-2012 01:09 PM
Quote:
Originally Posted by tpearl5 (Post 2291390)
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 01-23-2012 01:52 PM
Quote:
Originally Posted by TombstoneWarrior (Post 2291403)
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 01-23-2012 02:10 PM
Quote:
Originally Posted by simonhind (Post 2291414)
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 01-24-2012 12:37 AM
Quote:
Originally Posted by TombstoneWarrior (Post 2291415)
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 01-28-2012 10:14 AM
Quote:
Originally Posted by simonhind (Post 2291414)
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
Quote:
Originally Posted by OldSchoolDSL (Post 2291576)
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 01-28-2012 07:50 PM
1 Attachment(s)
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 01-28-2012 08:25 PM
Quote:
Originally Posted by TombstoneWarrior (Post 2293392)
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 01-29-2012 06:22 AM
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 02-14-2012 03:38 PM
any update?

BlueCheri 03-01-2012 11:07 AM
Installed, let me check how it works.

G!

w8baby 03-01-2012 07:14 PM
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 03-01-2012 08:54 PM
seeing this error with VB 4.1.11 - everytime any style related stuff is changed, including cleanup etc.

Code:
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 03-02-2012 02:27 AM
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!

Quote:
Originally Posted by ndahiya (Post 2305172)
seeing this error with VB 4.1.11 - everytime any style related stuff is changed, including cleanup etc.

Code:
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 03-02-2012 02:02 PM
When modifying VB's advertising system the following DB error will occur during the save. Confirmed with Trevor via VB support ticket.

Code:
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/admin...l_below_navbar
IP Address : xx.xxx.xx.xxx
Username : UserName
Classname : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10

TnT 03-02-2012 05:19 PM
Quote:
Originally Posted by BlueCheri (Post 2305229)
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 03-03-2012 07:42 PM
Installed on 4.1.10

thecore762 03-05-2012 05:10 AM
Doesn't work properly with 4.1.11.
Will we be expecting this to be updated anytime soon by Andreas?

gothicuser 03-05-2012 05:21 AM
Quote:
Originally Posted by thecore762 (Post 2306292)
Doesn't work properly with 4.1.11.
Will we be expecting this to be updated anytime soon by Andreas?
Hopefully so bud.

cellarius 03-05-2012 05:26 AM
At vBGermany.org there's a Patch (first post, way down: tms_patch210b4.zip)

thecore762 03-05-2012 05:46 AM
Quote:
Originally Posted by cellarius (Post 2306299)
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?

gothicuser 03-05-2012 06:27 AM
Quote:
Originally Posted by thecore762 (Post 2306300)
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?
Registered ok, butunable to download the damn thing, suppose I have to prove my license or something :(
My translation skills aren't that good!

thecore762 03-05-2012 06:35 AM
Quote:
Originally Posted by gothicuser (Post 2306303)
Registered ok, butunable to download the damn thing, suppose I have to prove my license or something :(
My translation skills aren't that good!
I tried to verify my license too but it directed me to vb germany where it keeps telling me that I have to visit www.vbulletin.com

I guess we have to wait for Andreas to visit these forums.

Edit: I went ahead and sent Andreas an email, hopefully we will hear from him soon.

cellarius 03-05-2012 06:52 AM
Quote:
Originally Posted by gothicuser (Post 2306303)
Registered ok, butunable to download the damn thing, suppose I have to prove my license or something :(
My translation skills aren't that good!
You do that in your customer account on vb.com. Just tick the box for vBG.org, too (same as you did for vb.org), and you need to use same e-mail you use for your customer account.

gothicuser 03-05-2012 07:11 AM
Quote:
Originally Posted by cellarius (Post 2306307)
You do that in your customer account on vb.com. Just tick the box for vBG.org, too (same as you did for vb.org), and you need to use same e-mail you use for your customer account.
Sorted, many thanks :)

Katoona 03-08-2012 12:03 PM
Cant anybody post the file tms_patch210b4.zip here?

What does it solve? I have the TMS working fine with my default style, but I get database errors when its trying to update the Mobile style.

fly 03-08-2012 12:19 PM
Quote:
Originally Posted by cellarius (Post 2306307)
You do that in your customer account on vb.com. Just tick the box for vBG.org, too (same as you did for vb.org), and you need to use same e-mail you use for your customer account.
I don't even see where to do that on vb.com. I'm logged into the member area, but I don't see anywhere to change that.

cellarius 03-08-2012 02:16 PM
Quote:
Originally Posted by fly (Post 2307459)
I don't even see where to do that on vb.com. I'm logged into the member area, but I don't see anywhere to change that.
You must have done it once already, or you wouldn't be able to download stuff here :)

Go to: http://members.vbulletin.com/membersupport_priority.php
See "Site permissions" on the right side, tick the fourth option.

fly 03-08-2012 02:26 PM
Quote:
Originally Posted by cellarius (Post 2307496)
You must have done it once already, or you wouldn't be able to download stuff here :)

Go to: http://members.vbulletin.com/membersupport_priority.php
See "Site permissions" on the right side, tick the fourth option.
Yeah, I'm sure I did. Back in 2003. Thanks!

Katoona 03-08-2012 02:57 PM
I cant find the update file on VB Germany - can you give me a link?

Hostboard 03-08-2012 03:44 PM
Quote:
Originally Posted by Katoona (Post 2307511)
I cant find the update file on VB Germany - can you give me a link?
http://www.vbulletin-germany.org/sho...System/page124

Post #1234


All times are GMT. The time now is 05:22 AM.
Page 19 of 22 « First 91718 19 2021 Last »
Show 40 post(s) from this thread on one page

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

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