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

XF 1.3 weird MySQL Errors in log after making switch to percona..

Discussion in 'Troubleshooting and Problems' started by XxUnkn0wnxX, Jul 21, 2014.

  1. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    ok ever since i switched to percona db software i been getting where mysql error's

    [​IMG]

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xF6"+onm...' for column 'full_url' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, 12 minutes ago
    Stack Trace
    
    #0 /public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `sf...', Array)
    #3 /public_html/forums/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('sf_customimgcap...', Array)
    #4 /public_html/forums/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
    #5 /public_html/forums/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 /public_html/forums/library/Tac/CustomImgCaptcha/Model/Log.php(40): XenForo_DataWriter->save()
    #7 /public_html/forums/library/Tac/CustomImgCaptcha/Model/Log.php(208): Tac_CustomImgCaptcha_Model_Log->logRegistrationAttempt(Array)
    #8 /public_html/forums/library/Tac/CustomImgCaptcha/Captcha/Captcha.php(18): Tac_CustomImgCaptcha_Model_Log->LogEvent(Array)
    #9 /public_html/forums/library/XenForo/Captcha/Abstract.php(129): Tac_CustomImgCaptcha_Captcha_Captcha->isValid(Array)
    #10 /public_html/forums/library/Tac/AnyApi/ControllerPublic/Register.php(20): XenForo_Captcha_Abstract::validateDefault(Object(XenForo_Input))
    #11 /public_html/forums/library/Tac/CustomImgCaptcha/ControllerPublic/Register.php(51): Tac_AnyApi_ControllerPublic_Register->actionRegister()
    #12 /public_html/forums/library/XenForo/FrontController.php(347): Tac_CustomImgCaptcha_ControllerPublic_Register->actionRegister()
    #13 /public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #14 /public_html/forums/index.php(13): XenForo_FrontController->run()
    #15 {main}
    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'donate.amount' in 'order clause' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, Today at 12:39 AM
    Stack Trace
    
    #0 /public_html/forums/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tSELECT don...')
    #1 /public_html/forums/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tSELECT don...')
    #2 /public_html/forums/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tSELECT don...')
    #3 /public_html/forums/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT don...', Array)
    #4 /public_html/forums/library/Merc/DonationManager/Model/Donor.php(23): Zend_Db_Adapter_Abstract->fetchAll('\n\t\t\t\tSELECT don...')
    #5 /public_html/forums/library/Merc/DonationManager/ControllerPublic/Donor.php(36): Merc_DonationManager_Model_Donor->getDonors(Array, Array)
    #6 /public_html/forums/library/XenForo/FrontController.php(347): Merc_DonationManager_ControllerPublic_Donor->actionIndex()
    #7 /public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #8 /public_html/forums/index.php(13): XenForo_FrontController->run()
    #9 {main}
    
    Request State
    
    array(3) {
      ["url"] => string(39) "http://portalcentric.net/forums/donors/"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(3) {
        ["direction"] => string(4) "desc"
        ["order"] => string(38) "'"()&%<ScRiPt >prompt(937162)</ScRiPt>"
        ["_xfToken"] => string(8) "********"
      }
    }
    
    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry 'HowariModz' for key 'username' - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Today at 12:05 AM
    Stack Trace
    
    #0 /public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /public_html/forums/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
    #4 /public_html/forums/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
    #5 /public_html/forums/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 /public_html/forums/library/MetaMirror/DataWriter/User.php(8): XenForo_DataWriter->save()
    #7 /public_html/forums/library/XenForo/ControllerPublic/Register.php(281): MetaMirror_DataWriter_User->save()
    #8 /public_html/forums/library/Nobita/AccountDetection/XenForo/ControllerPublic/Register.php(11): XenForo_ControllerPublic_Register->actionRegister()
    #9 /public_html/forums/library/Tac/AnyApi/ControllerPublic/Register.php(61): Nobita_AccountDetection_XenForo_ControllerPublic_Register->actionRegister()
    #10 /public_html/forums/library/Tac/CustomImgCaptcha/ControllerPublic/Register.php(51): Tac_AnyApi_ControllerPublic_Register->actionRegister()
    #11 /public_html/forums/library/XenForo/FrontController.php(347): Tac_CustomImgCaptcha_ControllerPublic_Register->actionRegister()
    #12 /public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #13 /public_html/forums/index.php(13): XenForo_FrontController->run()
    #14 {main}
    
    Request State
    
    array(3) {
      ["url"] => string(49) "http://portalcentric.net/forums/register/register"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(14) {
        ["username"] => string(10) "HowariModz"
        ["email"] => string(20) "********"
        ["password"] => string(8) "********"
        ["password_confirm"] => string(8) "********"
        ["dob_month"] => string(1) "5"
        ["dob_day"] => string(1) "5"
        ["dob_year"] => string(4) "****"
        ["gender"] => string(4) "male"
        ["timezone"] => string(16) "Australia/Sydney"
        ["public_uuid"] => string(25) "1a986e45cbd153cd1df8da3d1"
        ["custom_img_captcha_response_field"] => string(6) "switch"
        ["agree"] => string(1) "1"
        ["_xfToken"] => string(8) "********"
        ["reg_key"] => string(32) "88eb5f39f7f72f273e31a79ac458a834"
      }
    }
    
    should i be worried?

    and if not how do i stop this from being fed into my xenforo error log?
     
  2. MattW

    MattW Well-Known Member

    Was it a swap for the same version as the old MySQL (ie 5.5 to 5.5)?
     
  3. Mike

    Mike XenForo Developer Staff Member

    None of these look to be related to Percona - they look like add-on issues for the most part, mostly the custom image CAPTCHA and the donation manager.
     
  4. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    i was on mysql 5.6 community edition then i whent to percona 5.6 i re imported the data bases to properly convert them... so far web site has been running smooth and fast no issues just these annoying errors..

    well i have been getting other erros besides related to the addones like the
    Duplicate entry 'HowariModz' for key 'username' - library/Zend/Db/Statement/Mysqli.php:214

    i have gotten 5-6 pages full of em b4...
    its like the errors i am getting are not needed like extra debug logging mode or something has been enabled...
     
  5. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    just wow:

    22 pages:

    [​IMG]

    same errors with custom img caprica..
     

Share This Page