1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by gotski, Nov 14, 2014.

  1. gotski

    gotski Member

    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) "********"
    }
    }
     
  2. gotski

    gotski Member

    I wrote to my hoster, he checked and fixed database, but it not helped to me ;(
     
  3. gotski

    gotski Member

    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.
     
  4. Insy

    Insy Well-Known Member

    gotski likes this.

Share This Page