vb.org Archive

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

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?


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

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02250 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete