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
Activity
| Field | Original Value | New Value |
|---|---|---|
| Sprint | 5.10.0 Sprint 9 [ 198 ] |
| Rank | Ranked higher |
| Fix Version/s | 5.10.0-b1 [ 11905 ] |
| Assignee | Abdy Franco [ abdy ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 1 hour, 7 minutes [ 4020 ] | |
| Worklog Id | 16936 [ 16936 ] |
| Status | In Progress [ 3 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Status | In Review [ 5 ] | Closed [ 6 ] |
