Resource icon

Template Modification System (TMS) 1.3.1

No permission to download
Overview Updates (16) Reviews (63) History Discussion
Having some nasty errors with RC2. I updated the plugin from the github files and when trying to manually edit a template I get this error.
Code: 
The following error occurred:

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT template.* FROM xf_template_map AS template_map INNER JOIN xf_t' at line 1
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in TMS/Model/Template.php at line 232
TMS_Model_Template->fetchAllKeyed() in XenForo/Model/Template.php at line 285
XenForo_Model_Template->getUniqueTemplatesByMapIds() in XenForo/Model/Template.php at line 1323
XenForo_Model_Template->compileMappedTemplatesInStyleTree() in XenForo/DataWriter/Template.php at line 384
XenForo_DataWriter_Template->_recompileTemplate() in XenForo/DataWriter/Template.php at line 364
XenForo_DataWriter_Template->_postSave() in XenForo/DataWriter.php at line 1397
XenForo_DataWriter->save() in XenForo/ControllerAdmin/Template.php at line 670
XenForo_ControllerAdmin_Template->actionSaveMultiple() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/html/admin.php at line 13
So when trying to disable the plugin I get this error.
Code: 
The following error occurred:

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT template.* FROM xf_template_map AS template_map INNER JOIN xf_t' at line 1
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in TMS/Model/Template.php at line 232
TMS_Model_Template->fetchAllKeyed() in XenForo/Model/Template.php at line 285
XenForo_Model_Template->getUniqueTemplatesByMapIds() in XenForo/Model/Template.php at line 1323
XenForo_Model_Template->compileMappedTemplatesInStyleTree() in TMS/DataWriter/AddOn.php at line 45
TMS_DataWriter_AddOn->_postSave() in XenForo/DataWriter.php at line 1397
XenForo_DataWriter->save() in XenForo/ControllerAdmin/Abstract.php at line 131
XenForo_ControllerAdmin_Abstract->_getToggleResponse() in XenForo/ControllerAdmin/AddOn.php at line 314
XenForo_ControllerAdmin_AddOn->actionToggle() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/html/admin.php at line 13

Oh I can't disable any plugins.
 
With the latest ver of xenforo and tms I get this error :

Server Error
Mysqli prepare error: Unknown column 'template_map.template_final' in 'field list'

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
  5. XenForo_Model->fetchAllKeyed() in TMS/Model/Template.php at line 228
  6. TMS_Model_Template->fetchAllKeyed() in XenForo/Model/Template.php at line 431
  7. XenForo_Model_Template->getOutdatedTemplates() in XenForo/ControllerAdmin/Home.php at line 26
  8. XenForo_ControllerAdmin_Home->actionIndex() in XenForo/FrontController.php at line 337
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  10. XenForo_FrontController->run() in /home4/anytopix/public_html/admin.php at line 13
 
I'm using 1.2 RC2 and I downloaded the TMS add-on directly from here https://github.com/guiltar/TMS
You'll notice the latest comment (1 month ago) indicates he was working on 1.2
No idea if it's complete, but I can say it's working fairly smooth so far.

I haven't got an error yet and I've been running it for little over an hour.
I've been able to do profile posts, save preferences, create new threads, create replies, initiate new conversations, and use a couple TMS dependent add-ons :)

End of Day 1 - with no issues or errors due to TMS

------
Survived the weekend with no errors. I'd say it's safe enough for most boards to upgrade to his github version.
 
Last edited:
0xym0r0n said:
I'm using 1.2 RC2 and I downloaded the TMS add-on directly from here https://github.com/guiltar/TMS
You'll notice the latest comment (1 month ago) indicates he was working on 1.2
No idea if it's complete, but I can say it's working fairly smooth so far.

I haven't got an error yet and I've been running it for little over an hour.
I've been able to do profile posts, save preferences, create new threads, create replies, initiate new conversations, and use a couple TMS dependent add-ons :)

End of Day 1 - with no issues or errors due to TMS

------
Survived the weekend with no errors. I'd say it's safe enough for most boards to upgrade to his github version.
Click to expand...

The real question is, did you upgrade your boards with the TMS and then tried to install the update? Did you convert a copy of your live board?
 
I updated my board to 1.2 RC2 and was given a ton of errors involving TMS add-ons. I temporarily disabled the add-ons and TMS. I uninstalled TMS and the installed the github version. I then enabled everything and haven't got an error since then.

I just tried to add my own TMS and I was given this error
Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT template.* FROM xf_template_map AS template_map INNER JOIN xf_tem' at line 1
[LIST=1]
[*]Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
[*]Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
[*]Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
[*]Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
[*]XenForo_Model->fetchAllKeyed() in TMS/Model/Template.php at line 232
[*]TMS_Model_Template->fetchAllKeyed() in XenForo/Model/Template.php at line 285
[*]XenForo_Model_Template->getUniqueTemplatesByMapIds() in XenForo/Model/Template.php at line1323
[*]XenForo_Model_Template->compileMappedTemplatesInStyleTree() inTMS/DataWriter/Modification.php at line 211
[*]TMS_DataWriter_Modification->_recompileAssociatedTemplates() in TMS/DataWriter/Modification.phpat line 195
[*]TMS_DataWriter_Modification->_postSaveAfterTransaction() in XenForo/DataWriter.php at line 1411
[*]XenForo_DataWriter->save() in TMS/ControllerAdmin/Modification.php at line 173
[*]TMS_ControllerAdmin_Modification->actionSave() in XenForo/FrontController.php at line 337
[*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
[*]XenForo_FrontController->run() in /home/reddeadu/public_html/admin.php at line 13
[/LIST]

So I suppose installing/updating/adding AFTER the 1.2 RC2 is not going to work until it has an official TMS fix/add-on developer fix? Or maybe this is just related to my hosting? lol
 
0xym0r0n said:
I updated my board to 1.2 RC2 and was given a ton of errors involving TMS add-ons. I temporarily disabled the add-ons and TMS. I uninstalled TMS and the installed the github version. I then enabled everything and haven't got an error since then.

I just tried to add my own TMS and I was given this error
Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT template.* FROM xf_template_map AS template_map INNER JOIN xf_tem' at line 1
[LIST=1]
[*]Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
[*]Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
[*]Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
[*]Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
[*]XenForo_Model->fetchAllKeyed() in TMS/Model/Template.php at line 232
[*]TMS_Model_Template->fetchAllKeyed() in XenForo/Model/Template.php at line 285
[*]XenForo_Model_Template->getUniqueTemplatesByMapIds() in XenForo/Model/Template.php at line1323
[*]XenForo_Model_Template->compileMappedTemplatesInStyleTree() inTMS/DataWriter/Modification.php at line 211
[*]TMS_DataWriter_Modification->_recompileAssociatedTemplates() in TMS/DataWriter/Modification.phpat line 195
[*]TMS_DataWriter_Modification->_postSaveAfterTransaction() in XenForo/DataWriter.php at line 1411
[*]XenForo_DataWriter->save() in TMS/ControllerAdmin/Modification.php at line 173
[*]TMS_ControllerAdmin_Modification->actionSave() in XenForo/FrontController.php at line 337
[*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
[*]XenForo_FrontController->run() in /home/reddeadu/public_html/admin.php at line 13
[/LIST]

So I suppose installing/updating/adding AFTER the 1.2 RC2 is not going to work until it has an official TMS fix/add-on developer fix? Or maybe this is just related to my hosting? lol
Click to expand...

Thanks for the clarification, just want to make sure other users are fully aware of what's going on here.
If there is no updated within 2-3 weeks of 1.2 going gold then I will most likely have to uninstall TMS then upgrade.
My 1.1 upgrade to 1.2 RC otherwise was super smooth without errors except TMS.
 
On install of the new version:

Server Error
Mysqli statement execute error : Duplicate column name 'style_id'

  1. Zend_Db_Statement_Mysqli->_execute() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\Zend\Db\Statement.php at line 317
  2. Zend_Db_Statement->execute() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\Zend\Db\Adapter\Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\TMS\Install.php at line 72
  4. TMS_Install->_installVersion4() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\TMS\Install.php at line 59
  5. TMS_Install::build()
  6. call_user_func() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\XenForo\Model\AddOn.php at line 215
  7. XenForo_Model_AddOn->installAddOnXml() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\XenForo\Model\AddOn.php at line 169
  8. XenForo_Model_AddOn->installAddOnXmlFromFile() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\AddOnInstaller\ControllerAdmin\AddOn.php at line 263
  9. AddOnInstaller_ControllerAdmin_AddOn->actionInstallUpgrade() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\XenForo\FrontController.php at line 337
  10. XenForo_FrontController->dispatch() in C:\Program Files (x86)\Zend\Apache2\htdocs\library\XenForo\FrontController.php at line 134
  11. XenForo_FrontController->run() in C:\Program Files (x86)\Zend\Apache2\htdocs\admin.php at line 13
 
That'll probably work..

I'm just wondering why I had a style_id column there in the first place...
 
I am using 1.2 beta5 and I get:

Server Error
This version of TMS requires XenForo 1.2 or higher.

  1. TMS_Install::build()
  2. call_user_func() in XenForo/Model/AddOn.php at line 215
  3. XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
  4. XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 187
  5. XenForo_ControllerAdmin_AddOn->actionInstall() in XenForo/FrontController.php at line 337
  6. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  7. XenForo_FrontController->run() in /var/www/domains/domain.co.il/public/admin.php at line 13
 
Alexey.P said:
I am using 1.2 beta5 and I get:

Server Error
This version of TMS requires XenForo 1.2 or higher.

  1. TMS_Install::build()
  2. call_user_func() in XenForo/Model/AddOn.php at line 215
  3. XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
  4. XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 187
  5. XenForo_ControllerAdmin_AddOn->actionInstall() in XenForo/FrontController.php at line 337
  6. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  7. XenForo_FrontController->run() in /var/www/domains/domain.co.il/public/admin.php at line 13
Click to expand...
Obviously you need xf 1.2.0
 
What about the upgrade process?

Is this correct?
  • Disable all addons
  • Upgrade xf 1.2
  • Upgrade TMS
  • Enable all addons
 
Error got when installing the plugin.
Code: 
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate column name 'style_id' - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Locknlol, 3 minutes ago
Stack Trace
#0 /var/www/html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/html/library/TMS/Install.php(72): Zend_Db_Adapter_Abstract->query('??            A...')
#3 /var/www/html/library/TMS/Install.php(59): TMS_Install->_installVersion4()
#4 [internal function]: TMS_Install::build(false, Array, Object(SimpleXMLElement))
#5 /var/www/html/library/XenForo/Model/AddOn.php(215): call_user_func(Array, false, Array, Object(SimpleXMLElement))
#6 /var/www/html/library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#7 /var/www/html/library/XenForo/ControllerAdmin/AddOn.php(187): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phpDZJgVe')
#8 /var/www/html/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_AddOn->actionInstall()
#9 /var/www/html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/html/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
  ["url"] => string(46) "http://thecoremc.net/admin.php?add-ons/install"
  ["_GET"] => array(1) {
    ["add-ons/install"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

Then dropped "style_id" from "xf_template_modifcation" and got this error.

Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'xenforo.tms_modification' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Locknlol, 3 minutes ago
Stack Trace
#0 /var/www/html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT *??...')
#1 /var/www/html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT *??...')
#2 /var/www/html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT *??...')
#3 /var/www/html/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('?????SELECT *??...', Array)
#4 /var/www/html/library/TMS/Install.php(85): Zend_Db_Adapter_Abstract->fetchAll('?????SELECT *??...')
#5 /var/www/html/library/TMS/Install.php(59): TMS_Install->_installVersion5()
#6 [internal function]: TMS_Install::build(false, Array, Object(SimpleXMLElement))
#7 /var/www/html/library/XenForo/Model/AddOn.php(215): call_user_func(Array, false, Array, Object(SimpleXMLElement))
#8 /var/www/html/library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#9 /var/www/html/library/XenForo/ControllerAdmin/AddOn.php(187): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phpK7qmcG')
#10 /var/www/html/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_AddOn->actionInstall()
#11 /var/www/html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /var/www/html/admin.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
  ["url"] => string(46) "http://thecoremc.net/admin.php?add-ons/install"
  ["_GET"] => array(1) {
    ["add-ons/install"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 
Last edited:
You must log in or register to reply here.

Similar threads

El Porcharo
  • Question Question
XF 2.2 Debug a not working template modification
Replies
0
Views
308
El Porcharo
El Porcharo
kirsty
XF 2.2 Template tags not matching in template modification
Replies
6
Views
930
kirsty
kirsty
Nulumia
[OzzModz] Template Modification List Tweaks [Deleted]
Replies
4
Views
1K
Ozzy47
Ozzy47
electrogypsy
  • Question Question
XF 2.1 style-specific template modifications?
Replies
3
Views
1K
DragonByte Tech
DragonByte Tech
Live Free
XF 1.5 Suspected Template Modification or Permissions Issue for Custom Add-On (stuck)
Replies
0
Views
707
Live Free
Live Free
Top Bottom