• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Problem with MYSQL after upgrade from 1.3.2 to 1.4.2

#1
First time after upgrade I have a problems.... Don't work spam cleaner, don't work user delete,
I can't create posts in some threads.



Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
5 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
6 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
6 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
6 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
7 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
7 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
7 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
10 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
11 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
11 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
12 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction


Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Admin, 30 minutes ago
Stack Trace
#0 /home/**********/community/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/**********/community/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/**********/community/library/XenForo/Model/User.php(2782): Zend_Db_Adapter_Abstract->query('???????UPDATE I...', 56659)
#3 /home/**********/community/library/XenForo/DataWriter/User.php(1339): XenForo_Model_User->changeContentUser(56659, 'Bignasty69', NULL, 0)
#4 /home/**********/community/library/XenForo/DataWriter.php(1779): XenForo_DataWriter_User->_postDelete()
#5 /home/**********/community/library/XenForo/Controller.php(1019): XenForo_DataWriter->delete()
#6 /home/**********/community/library/XenForo/ControllerAdmin/User.php(606): XenForo_Controller->_deleteData('XenForo_DataWri...', 'user_id', 'admin.php?users...')
#7 /home/**********/community/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_User->actionDelete()
#8 /home/**********/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/**********/community/admin.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(73) "http://**********/community/admin.php?users/bignasty69.56659/delete"
["_GET"] => array(1) {
["users/bignasty69_56659/delete"] => string(0) ""
}
["_POST"] => array(2) {
["_xfConfirm"] => string(1) "1"
["_xfToken"] => string(8) "********"
}
}
 
#3
Hoster not helped me, I'm create dump a forum database, then created new empty database and loaded dump, it helped me....
I don't know why it work, but I very glad.