Jake B.
Well-known member
Some errors @Jake B.
No idea what triggers this,
Code:Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'uix_collapse_user_info' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77 Generated By: Solidus, A moment ago
Code:#0 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_user...') #1 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_user...') #2 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_user...') #3 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array) #4 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1640): Zend_Db_Adapter_Abstract->update('xf_user_option', Array, 'user_id = 56') #5 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1609): XenForo_DataWriter->_update() #6 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save() #7 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/ControllerPublic/Account.php(761): XenForo_DataWriter->save() #8 /var/www/vhosts/wweforums.net/httpdocs/library/Audentio/UIX/ControllerPublic/Account.php(11): XenForo_ControllerPublic_Account->actionPreferencesSave() #9 /var/www/vhosts/wweforums.net/httpdocs/library/CTA/FeaturedThreads/ControllerPublic/Account.php(18): Audentio_UIX_ControllerPublic_Account->actionPreferencesSave() #10 /var/www/vhosts/wweforums.net/httpdocs/library/NFLJ/Sportsbook/ControllerPublic/Account.php(38): CTA_FeaturedThreads_ControllerPublic_Account->actionPreferencesSave() #11 /var/www/vhosts/wweforums.net/httpdocs/library/MasterBadge/ControllerPublic/Account.php(45): NFLJ_Sportsbook_ControllerPublic_Account->actionPreferencesSave() #12 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(347): MasterBadge_ControllerPublic_Account->actionPreferencesSave() #13 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #14 /var/www/vhosts/wweforums.net/httpdocs/index.php(13): XenForo_FrontController->run() #15 {main}
This is triggered by checking collapse user info in preferences and hitting save,
Code:Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'uix_collapse_user_info' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77 Generated By: Solidus, A moment ago
Code:#0 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_user...') #1 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_user...') #2 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_user...') #3 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array) #4 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1640): Zend_Db_Adapter_Abstract->update('xf_user_option', Array, 'user_id = 56') #5 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1609): XenForo_DataWriter->_update() #6 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save() #7 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/ControllerPublic/Account.php(761): XenForo_DataWriter->save() #8 /var/www/vhosts/wweforums.net/httpdocs/library/Audentio/UIX/ControllerPublic/Account.php(11): XenForo_ControllerPublic_Account->actionPreferencesSave() #9 /var/www/vhosts/wweforums.net/httpdocs/library/CTA/FeaturedThreads/ControllerPublic/Account.php(18): Audentio_UIX_ControllerPublic_Account->actionPreferencesSave() #10 /var/www/vhosts/wweforums.net/httpdocs/library/NFLJ/Sportsbook/ControllerPublic/Account.php(38): CTA_FeaturedThreads_ControllerPublic_Account->actionPreferencesSave() #11 /var/www/vhosts/wweforums.net/httpdocs/library/MasterBadge/ControllerPublic/Account.php(45): NFLJ_Sportsbook_ControllerPublic_Account->actionPreferencesSave() #12 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(347): MasterBadge_ControllerPublic_Account->actionPreferencesSave() #13 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #14 /var/www/vhosts/wweforums.net/httpdocs/index.php(13): XenForo_FrontController->run() #15 {main}
i got apache 2.2.2 and php 5.4...
Also this, no users can register,
Code:Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'uix_collapse_user_info' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77 Generated By: Unknown Account, A moment ago
Code:#0 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...') #1 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...') #2 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...') #3 /var/www/vhosts/wweforums.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array) #4 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user_option', Array) #5 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert() #6 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save() #7 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save() #8 /var/www/vhosts/wweforums.net/httpdocs/library/UserEss/ControllerPublic/Register.php(68): XenForo_ControllerPublic_Register->actionRegister() #9 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(347): UserEss_ControllerPublic_Register->actionRegister() #10 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #11 /var/www/vhosts/wweforums.net/httpdocs/index.php(13): XenForo_FrontController->run() #12 {main}
Actually, there is 1 more that isn't fixed,
Code:ErrorException: Undefined index: uix_last_sticky_action - library/Audentio/UIX/ControllerPublic/Forum.php:30 Generated By: Pop Tatari, 1 minute ago
Code:#0 /var/www/vhosts/wweforums.net/httpdocs/library/Audentio/UIX/ControllerPublic/Forum.php(30): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/vhosts...', 30, Array) #1 /var/www/vhosts/wweforums.net/httpdocs/library/Waindigo/SocialGroups/Extend/XenForo/ControllerPublic/Forum.php(29): Audentio_UIX_ControllerPublic_Forum->actionForum() #2 /var/www/vhosts/wweforums.net/httpdocs/library/CTA/FeaturedThreads/ControllerPublic/Forum.php(143): Waindigo_SocialGroups_Extend_XenForo_ControllerPublic_Forum->actionForum() #3 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(347): CTA_FeaturedThreads_ControllerPublic_Forum->actionForum() #4 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #5 /var/www/vhosts/wweforums.net/httpdocs/index.php(13): XenForo_FrontController->run() #6 {main}
Please run these queries one at a time in phpMyAdmin, and if one gives an error skip it and move to the next one:
Code:
ALTER TABLE `xf_user_option` ADD `uix_collapse_user_info` INT(3) UNSIGNED NOT NULL DEFAULT '1' ;
ALTER TABLE `xf_forum` ADD `uix_last_sticky_action` INT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `xf_user_option` CHANGE `uix_collapse_stuck_threads` `uix_collapse_stuck_threads` INT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `xf_user_option` ADD `uix_collapse_signature` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' AFTER `uix_collapse_user_info`;
