I am attempting to upgrade from 4.0.1 to 4.3.2 following the instructions in the documentation. I uploaded all the files, overwriting existing. Then in the browser I began the upgrade process. However, I get the following error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5-13' for key 'PRIMARY'
I have tried various searches, but I can't find that key and the only place I can find any version of '5-13' is in dates in data fields. I am now stuck in mid upgrade! Can someone help me figure out how to fix this?
NOTE: I have already tried reverting the database back to the version backed up just prior to the upgrade, but I get stuck at the same place.
This morning I tried doing the update from SSH command line. This expanded on the error a bit more:
[2018-09-13 17:21:12] general.ERROR: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5-13' for key 'PRIMARY'' in /home/setupserver/applications/clientarea/public/vendors/minphp/db/src/PdoConnection.php:196
Stack trace:
#0 /home/setupserver/applications/clientarea/public/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array)
#1 /home/setupserver/applications/clientarea/public/components/upgrades/tasks/upgrade4_1_1.php(100): Minphp\Db\PdoConnection->query('INSERT INTO `se...', Array)
#2 /home/setupserver/applications/clientarea/public/components/upgrades/tasks/upgrade4_1_1.php(54): Upgrade4_1_1->addServiceInvoiceAssociations()
#3 /home/setupserver/applications/clientarea/public/components/upgrades/upgrades.php(266): Upgrade4_1_1->process('addServiceInvoi...')
#4 /home/setupserver/applications/clientarea/public/components/upgrades/upgrades.php(101): Upgrades->processObject(Object(Upgrade4_1_1), Array)
#5 /home/setupserver/applications/clientarea/public/app/controllers/admin_upgrade.php(141): Upgrades->start('4.0.0-b6', '4.3.2', Array)
#6 /home/setupserver/applications/clientarea/public/app/controllers/admin_upgrade.php(92): AdminUpgrade->processCli()
#7 /home/setupserver/applications/clientarea/public/vendors/minphp/bridge/src/Lib/Dispatcher.php(143): AdminUpgrade->index()
#8 /home/setupserver/applications/clientarea/public/vendors/minphp/bridge/src/Lib/Dispatcher.php(61): Dispatcher::dispatch('/admin/upgrade/', true)
#9 /home/setupserver/applications/clientarea/public/index.php(24): Dispatcher::dispatchCli(Array)
#10 {main} [] []
Can this help with troubleshooting?