What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Bug Fixed server error on update to 4.2.1 from 4.1.1

moshbit

moshbit

Member
unfortunately while trying to upgrade i get the following error when uploading the xml file:

Code: 
Server Error

Mysqli statement execute error : Duplicate column name 'xfa_ec_transition'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XFA/ExtendedCover/Install/Upgrade/904020090.php at line 34
XFA_ExtendedCover_Install_Upgrade_904020090::run() in XFA/ExtendedCover/Install/Upgrade.php at line 68
XFA_ExtendedCover_Install_Upgrade::run() in XFA/ExtendedCover/Installer.php at line 25
XFA_ExtendedCover_Installer::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in ThemeHouse/InstallUpgrade/Extend/XenForo/Model/AddOn.php at line 135
ThemeHouse_InstallUpgrade_Extend_XenForo_Model_AddOn->installAddOnXml() in ConvEss/Model/AddOn.php at line 24
ConvEss_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in ThemeHouse/InstallUpgrade/Extend/XenForo/Model/AddOn.php at line 65
ThemeHouse_InstallUpgrade_Extend_XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237
XenForo_ControllerAdmin_AddOn->actionUpgrade() in ThemeHouse/InstallUpgrade/Extend/XenForo/ControllerAdmin/AddOn.php at line 192
ThemeHouse_InstallUpgrade_Extend_XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/nginx/domains/squattheplanet.com/public/admin.php at line 13

i see some references to themehouse's install and upgrade plugin, which i am using. is that's what's causing the issue? thanks!
 
moshbit

moshbit

Member
i just tried uploading the xml with the above plugin disabled and i'm getting a different server error that seems to have some references to Xon's conversation essentials plugin:

Code: 
Server Error

Mysqli statement execute error : Duplicate column name 'xfa_ec_transition'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XFA/ExtendedCover/Install/Upgrade/904020090.php at line 34
XFA_ExtendedCover_Install_Upgrade_904020090::run() in XFA/ExtendedCover/Install/Upgrade.php at line 68
XFA_ExtendedCover_Install_Upgrade::run() in XFA/ExtendedCover/Installer.php at line 25
XFA_ExtendedCover_Installer::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in ConvEss/Model/AddOn.php at line 24
ConvEss_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/nginx/domains/squattheplanet.com/public/admin.php at line 13
 
Fred

Fred

Administrator
Staff member
Hum it's strange because you shouldn't have xfa_ec_transition column in xf_user table if you upgrade from 4.1.1 to 4.2.1
So you have 2 method to fix it
  • you can delete xfa_ec_transition column in xf_user_table and restart upgrade script
  • you can edit XFA/ExtendedCover/Install/Upgrade/904020090.php and comment
    PHP: 
     $db->query("ALTER TABLE `xf_user` ADD `xfa_ec_transition` varchar(50) null default 'scale'");
    and restart upgrade script
 
moshbit

moshbit

Member
Fredxd said:
Hum it's strange because you shouldn't have xfa_ec_transition column in xf_user table if you upgrade from 4.1.1 to 4.2.1
So you have 2 method to fix it
  • you can delete xfa_ec_transition column in xf_user_table and restart upgrade script
  • you can edit XFA/ExtendedCover/Install/Upgrade/904020090.php and comment
    PHP: 
     $db->query("ALTER TABLE `xf_user` ADD `xfa_ec_transition` varchar(50) null default 'scale'");
    and restart upgrade script
Click to expand...

okay, i did that and it seems to have installed/upgraded correctly. thank you! will i need to do this on each upgrade? (i went with option two, but i can remove the column in option one if need be).
 
You must log in or register to reply here.
Top