bitex Posted yesterday at 10:57 AM Share Posted yesterday at 10:57 AM 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now