error upgrading from 9.2.3 to 9.3

[HernanM]

I leave the default upgrade checkboxes checked and after a while this error shows:

ERROR: PleskMainDBException
MySQL query failed: MySQL server has gone away

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed: MySQL server has gone away

0: common_func.php3:168
db_query(string 'select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=6')
1: class.Table.php:183
Table->select()
2: class.cObject.php:479
cObject->fetchAttrsFromTable_()
3: DashboardPreset.php:29
DashboardPreset->__construct(integer '6')
4: common_func.php3:3110
objectMaker(string 'DashboardPreset', integer '6', boolean false, NULL null)
5: common_func.php3:3119
objectMakerEx(string 'DashboardPreset', integer '6')
6: UserAdmin.php:205
UserAdmin->getDashboardCustomPreset()
7: Favorites.php:100
Favorites::renderFavoritesDropDown(boolean false)
8: class.Form.php:286
Form->assign()
9: AutoInstallerInstallForm.php:124
AutoInstallerInstallForm->assignComponent(object of type AutoInstallerRelease, object of type AutoInstallerComponent, boolean true, array)
10: AutoInstallerInstallForm.php:66
AutoInstallerInstallForm->assign(object of type AutoInstallerRelease, array, array, array, boolean false, boolean false, string '', boolean false)
11: autoinstaller_install.php:132

 

[IgorG]

It looks like psa database inconsistency for DashboardPreset table. Database correction is required there. If you can't correct it by yourself, please contact support team.

 

[HernanM]

I've never touched psa db nor anything else from plesk core. Why could the db be broken ? I ask to avoid the same problem in the future.

 

[IgorG]

I've never touched psa db nor anything else from plesk core. Why could the db be broken ? I ask to avoid the same problem in the future.

Actually, it is very difficult to say anything without deep investigation of this issue directly on your server. It is complex problem and I not sure that it can be investigated in the forum's format.