Jump to content

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-885' for key 'ps_access.PRIMARY'


bitex

Recommended Posts

i tried to upgrade 8.1.5 to 9.0.1. but i the last step to update the database i got an error on query left 172. if i try to delete the 1-885 entry i have access problems. any idea to solve it to get an 100% good update result?


Update database in progress. 172 queries left
/var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/classes/db/DbPDO.php line 149 - PrestaShopException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-885' for key 'ps_access.PRIMARY'
#0 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/classes/db/Db.php(381): DbPDOCore->_query('UPDATE ps_acces...')
#1 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/classes/db/Db.php(571): DbCore->query('UPDATE ps_acces...')
#2 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/modules/autoupgrade/classes/Database/DbWrapper.php(49): DbCore->execute('UPDATE ps_acces...', true)
#3 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/modules/autoupgrade/upgrade/php/add_missing_unique_key_from_authorization_role.php(59): PrestaShop\Module\AutoUpgrade\Database\DbWrapper::execute('UPDATE ps_acces...')
#4 [internal function]: add_missing_unique_key_from_authorization_role()
#5 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(429): call_user_func_array('add_missing_uni...', Array)
#6 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(356): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->runPhpQuery('8.1.7-catchup', '/* PHP:add_miss...')
#7 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/modules/autoupgrade/classes/Task/Update/UpdateDatabase.php(174): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->runQuery('8.1.7-catchup', '/* PHP:add_miss...')
#8 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/modules/autoupgrade/classes/Task/Update/UpdateDatabase.php(61): PrestaShop\Module\AutoUpgrade\Task\Update\UpdateDatabase->updateDatabase(Object(PrestaShop\Module\AutoUpgrade\Progress\Backlog))
#9 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/modules/autoupgrade/classes/Task/Runner/ChainedTasks.php(66): PrestaShop\Module\AutoUpgrade\Task\Update\UpdateDatabase->run()
#10 /var/www/vhosts/hosting118602.a2f87.netcup.net/bitex-fanshop.de/httpdocs/**admin_folder**/autoupgrade/ajax-upgradetab.php(58): PrestaShop\Module\AutoUpgrade\Task\Runner\ChainedTasks->run()
#11 {main}
It seems there was an issue with the server. This type of error usually happens when:
The server is temporarily unavailable.
There's a misconfiguration or unexpected problem on the server.
HTTP request failed. Type: ERR_BAD_RESPONSE - HTTP Code: 500

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...