Fixed Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '385bd7c80...

[Hornstar]

I've only just installed and done the import this week and I am getting this error in my server log:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '385bd7c80cc5ef71de32faa65ad57e71' for key 'url_hash' - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Today at 4:16 PM
Stack Trace
#0 /home/***/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/***/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/***/public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/***/public_html/forums/library/XenForo/Model/ImageProxy.php(283): Zend_Db_Adapter_Abstract->insert('xf_image_proxy', Array)
#4 /home/***/public_html/forums/library/XenForo/Model/ImageProxy.php(31): XenForo_Model_ImageProxy->_fetchAndCacheImage('https://lh4.goo...')
#5 /home/***/public_html/forums/library/XenForo/ProxyOutput.php(197): XenForo_Model_ImageProxy->getImage('https://lh4.goo...')
#6 /home/***/public_html/forums/library/XenForo/ProxyOutput.php(129): XenForo_ProxyOutput->_outputImage(false)
#7 /home/***/public_html/forums/library/XenForo/ProxyOutput.php(341): XenForo_ProxyOutput->output()
#8 /home/***/public_html/forums/proxy.php(12): XenForo_ProxyOutput::run()
#9 {main}
Request State
array(3) {
["url"] => string(232) "http://www.***.net/forums/proxy.php?image=https%3A%2F%2Flh4.googleusercontent.com%2F-Ncmu0KT--JE%2FUAeBfCiUdTI%2FAAAAAAAANco%2FjtM6kg_plwk%2Fs912%2Fdont%252520have%252520gamelauncher.jpg&hash=0415f59d490157ad06adb374e0a92836"
["_GET"] => array(2) {
["image"] => string(122) "https://lh4.googleusercontent.com/-Ncmu0KT--JE/UAeBfCiUdTI/AAAAAAAANco/jtM6kg_plwk/s912/dont%2520have%2520gamelauncher.jpg"
["hash"] => string(32) "0415f59d490157ad06adb374e0a92836"
}
["_POST"] => array(0) {
}
}

 

[Mike]

Looks like a race condition, though it should generally be quite a small window -- this is the first I've heard it reported at least. In general, it's safe to ignore it (assuming it's really only happened once).

 

[Hornstar]

Looks like a race condition, though it should generally be quite a small window -- this is the first I've heard it reported at least. In general, it's safe to ignore it (assuming it's really only happened once).

Thanks. I'm going through the log now. Found some more.

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '8384b207b94592154f36a93ba31b46a5' for key 'url_hash' - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Monday at 2:39 AM
Stack Trace
#0 /home/***/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/***/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/***/public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/***/public_html/forums/library/XenForo/Model/ImageProxy.php(283): Zend_Db_Adapter_Abstract->insert('xf_image_proxy', Array)
#4 /home/***/public_html/forums/library/XenForo/Model/ImageProxy.php(31): XenForo_Model_ImageProxy->_fetchAndCacheImage('http://i121.pho...')
#5 /home/***/public_html/forums/library/XenForo/ProxyOutput.php(197): XenForo_Model_ImageProxy->getImage('http://i121.pho...')
#6 /home/***/public_html/forums/library/XenForo/ProxyOutput.php(129): XenForo_ProxyOutput->_outputImage(false)
#7 /home/***/public_html/forums/library/XenForo/ProxyOutput.php(341): XenForo_ProxyOutput->output()
#8 /home/***/public_html/forums/proxy.php(12): XenForo_ProxyOutput::run()
#9 {main}
Request State
array(3) {
["url"] => string(160) "http://www.***.net/forums/proxy.php?image=http%3A%2F%2Fi121.photobucket.com%2Falbums%2Fo222%2FSlugsnack%2F6-15.png&hash=51ab803369e48470c795b5189cda9395"
["_GET"] => array(2) {
["image"] => string(58) "http://i121.photobucket.com/albums/o222/Slugsnack/6-15.png"
["hash"] => string(32) "51ab803369e48470c795b5189cda9395"
}
["_POST"] => array(0) {
}
}

And

 

[Mike]

I'm quite surprised exactly how frequently that's happened for you, but regardless I have added a code to prevent it in the future.

 

[anitasoni409]

Hello Everyone
can you help me
Zend VERSION = '1.11.11';

I am go to login show the error in captcha

error find
[Tue Aug 04 03:48:18.130219 2020] [:error] [pid 21888] [client 223.225.71.78:35278] PHP Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Duplicate entry '8c0ajgte3fk890l7v0hm0qquh7-/var/lib/php/session-PHPSESSID' for key 'PRIMARY'' in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php:214\nStack trace:\n#0 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)\n#1 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)\n#2 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(575): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array)\n#3 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Table/Abstract.php(1076): Zend_Db_Adapter_Abstract->insert('session', Array)\n#4 /var/www/baid.openclouderp.com/public_html/library/Zend/Session/SaveHandler/DbTable.php(356): Zend_Db_Table_Abstract->insert(Array)\n#5 [internal function]: Zend_Session_SaveHandler_DbTabl in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php on line 214, referer: http://sharda.opencloudcrm.in/user/login
[Tue Aug 04 03:49:57.325266 2020] [:error] [pid 31715] [client 223.225.71.78:47589] PHP Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Duplicate entry '8c0ajgte3fk890l7v0hm0qquh7-/var/lib/php/session-PHPSESSID' for key 'PRIMARY'' in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php:214\nStack trace:\n#0 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)\n#1 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)\n#2 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(575): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array)\n#3 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Table/Abstract.php(1076): Zend_Db_Adapter_Abstract->insert('session', Array)\n#4 /var/www/baid.openclouderp.com/public_html/library/Zend/Session/SaveHandler/DbTable.php(356): Zend_Db_Table_Abstract->insert(Array)\n#5 [internal function]: Zend_Session_SaveHandler_DbTabl in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php on line 214, referer: http://sharda.opencloudcrm.in/user/login
[Tue Aug 04 04:40:39.981186 2020] [:error] [pid 22360] [client 223.225.71.78:25736] PHP Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Duplicate entry '8c0ajgte3fk890l7v0hm0qquh7-/var/lib/php/session-PHPSESSID' for key 'PRIMARY'' in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php:214\nStack trace:\n#0 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)\n#1 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)\n#2 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(575): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array)\n#3 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Table/Abstract.php(1076): Zend_Db_Adapter_Abstract->insert('session', Array)\n#4 /var/www/baid.openclouderp.com/public_html/library/Zend/Session/SaveHandler/DbTable.php(356): Zend_Db_Table_Abstract->insert(Array)\n#5 [internal function]: Zend_Session_SaveHandler_DbTabl in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php on line 214, referer: http://sharda.opencloudcrm.in/user/login
[Tue Aug 04 04:41:07.274727 2020] [:error] [pid 23417] [client 223.225.71.78:8153] PHP Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Duplicate entry '8c0ajgte3fk890l7v0hm0qquh7-/var/lib/php/session-PHPSESSID' for key 'PRIMARY'' in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php:214\nStack trace:\n#0 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)\n#1 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)\n#2 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Adapter/Abstract.php(575): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array)\n#3 /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Table/Abstract.php(1076): Zend_Db_Adapter_Abstract->insert('session', Array)\n#4 /var/www/baid.openclouderp.com/public_html/library/Zend/Session/SaveHandler/DbTable.php(356): Zend_Db_Table_Abstract->insert(Array)\n#5 [internal function]: Zend_Session_SaveHandler_DbTabl in /var/www/baid.openclouderp.com/public_html/library/Zend/Db/Statement/Mysqli.php on line 214, referer: http://sharda.opencloudcrm.in/user/login
please any solutions

 

[Chris D]

To post in the customer support forums you need to first have linked your customer account to your forum username.

You can do this by going to the “Forum users” section in the Account area and adding your forum username there.

That will then allow you to post in the correct forum.