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

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



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?
 

Mike

XenForo developer
Staff member
#3
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
Was it a swap for the same version as the old MySQL (ie 5.5 to 5.5)?
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..

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