Cannot upgrade from 9.2.2

[scottthepotter]

I am currently running Plesk 9.2.2 on a Centos 5.4 64-bit box. When I go to 'Updates' in the Plesk control panel it currently indicates (yellow icon) that there are updates to my 9.2.2 version, even though there are none. If I go ahead and 'install' all updates for 9.2.2 it reports a 'success'. However whenever I try to update to 9.2.3 or 9.3.0 I get the following:

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`=5')
1: class.Table.php:183 Table->select()
2: class.cObject.php:479 cObject->fetchAttrsFromTable_()
3: DashboardPreset.php:29 DashboardPreset->__construct(integer '5')
4: common_func.php3:3115 objectMaker(string 'DashboardPreset', integer '5', boolean false, NULL null)
5: common_func.php3:3124 objectMakerEx(string 'DashboardPreset', integer '5')
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

I have restarted the MySQL server, and run an extended database check on the 'PSA' database and it reports that all tables are 'OK'

So what now?

 

[IgorG]

Did you tried to execute this sql select directly in Plesk database?

select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=5;

Seems you haven't this record there. Check it.

 

[scottthepotter]

Forgot to mention, that was the first thing I checked, here is the row:

id='5'
name='1-0'
uri='/plesk/dashboard'
type='admin'

All values are present

 

[IgorG]

There is "MySQL server has gone away" error. Try to increase wait_timeout in /etc/my.cnf:

wait_timeout 20000

Restart MySQL after that.

 

[scottthepotter]

Thanks! that did it!