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

XxUnkn0wnxX

XxUnkn0wnxX

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

al2mD.png


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?
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
MattW said:
Was it a swap for the same version as the old MySQL (ie 5.5 to 5.5)?
Click to expand...

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

Mike said:
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.
Click to expand...

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...
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

jb9826
  • Question Question
XF 1.5 Batch Update Threads Timeout
Replies
0
Views
319
jb9826
jb9826
jb9826
  • Question Question
XF 1.5 Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
Replies
0
Views
534
jb9826
jb9826
jb9826
  • Question Question
XF 1.5 An unexpected error occurred. "The memcache extension must be loaded for using this backend"
Replies
3
Views
319
Paul B
Paul B
K
  • Question Question
XF 1.5 Email Transport Method SMTP errors (connection timed out, invalid auth)
Replies
11
Views
1K
TPerry
TPerry
G
XF 1 Fix deadlock in conversations
Replies
6
Views
1K
masterking
masterking
Top Bottom