Issue Error on upgrade to Obsidian

[Steve Tozer]

Hi All,

Im just upgrading a server to Obsidian from Onyx and getting the below error. Wondering if anyone has come across this and how to resolve

Migration failed: 17.9.6/2019-04-23-11-14-00_add_recovery_email.php
Query failed: ALTER TABLE `smb_users` ADD COLUMN `externalEmail` varchar(255)
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
*****  problem report *****
===> Plesk database scheme was not upgraded completely.

Thanks
Steve

 

[RomanLed]

I have the same problem:

Migration failed: 17.9.6/2019-04-23-11-14-00_add_recovery_email.php
Query failed: ALTER TABLE `smb_users` ADD COLUMN `externalEmail` varchar(255)
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

 

[RomanLed]

I solved the problem myself, changed it in the table "smb_users" in database PSA:
- contactName: varchar(255) to TEXT
- companyName: varchar(255) to TEXT
- country: varchar(255) to TEXT

 

[Monty]

Please also have a look here: MySQL database import fails: ERROR 1118 (42000): Row size too large

 

[Steve Tozer]

@RomanLed - All sorted for me thanks