Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.10.0-b1
-
Component/s: None
-
Labels:None
Description
We've had a couple people report the following error (https://www.blesta.com/forums/index.php?/topic/25430-upgrade-bug/)
general.ERROR: PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'client_id' at row 8 in ..../vendors/minphp/db/src/PdoConnection.php:196 Stack trace: #0 ..../vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array) #1 ..../components/upgrades/tasks/upgrade5_8_1.php(87): Minphp\Db\PdoConnection->query('ALTER TABLE `co... ') #2 ..../components/upgrades/tasks/upgrade5_8_1.php(54): Upgrade5_8_1->setContactPermissio nClientId() #3 ..../components/upgrades/upgrades.php(294): Upgrade5_8_1->process('setContact Permi...') #4 .../components/upgrades/upgrades.php(103): Upgrades->processObject(Object(Upg rade5_8_1), NULL) #5 ..../app/controllers/admin_upgrade.php(109): Upgrades->start('5.8.0-b1' , '5.9.3') #6 ..../vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminUpgrade->process( ) #7 ..../index.php(21): Dispatcher::dispatch('/admin/upgrade/...') #8 {main}
To resolve we should update the setContactPermissionClientId method to delete the orphaned records. Something like the query mentioned in the task