Plesk 8.1.0 and Mysql 5 post-upgrade problem

[linuxcrazy]

Hi,
I upgraded my CentOS 4 using "yum upgrade" and everything went fine. With other updates Mysql version was upgraded to 5.0.51 as shown by execution of command

rpm -qa mysql
mysql-5.0.51-1.el4.art

logon to mysql database server via command prompt works fine but logging on to Plesk admin panel is yielding the following error:

ERROR: PleskFatalException
bad column in table: `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',

0: /usr/local/psa/admin/plib/common_func.php3:153
psaerror(string 'bad column in table: `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',')
1: /usr/local/psa/admin/plib/SQLParser.php:119
SQLParser->parseError(string ' `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',')
2: /usr/local/psa/admin/plib/SQLParser.php:105
SQLParser->_parseLineInTable(string ' `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',')
3: /usr/local/psa/admin/plib/SQLParser.php:52
SQLParser::parseLine(string ' `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',', integer '7')
4: :
array_walk(array, array)
5: /usr/local/psa/admin/plib/SQLParser.php:23
SQLParser->getArray(array)
6: /usr/local/psa/admin/plib/SQLParser.php:30
SQLParser->handleDatabase()
7: /usr/local/psa/admin/plib/MySQL5FixBinaryColumns.php:36
MySQL5FixBinaryColumns::run()
8: /usr/local/psa/admin/auto_prepend/auth.php3:93

I tried to google for similar error and solution but no luck.

Can anybody suggests the reason and possible solution to this problem? Your help is highly appreciated.

Thanks

[linuxcrazy]

any one to shed some light or put some insights on the cause and solution to this problem?

I've gone with recompilation of PHP 5.2.5 but that didn't work either.

Thanks

[scott]

Thats because PHP has nothing to do with the plesk daemon. Its a completely separate and independent instance of apache and php.

That looks to me like your plesk databases are screwed up. According to how I've marked up the package (its been a long time since I checked) 8.1 should be compatible with MySQL 5.0. Older versions definitely were not. You might want to try rolling back to whatever you were using before, upgrading plesk, and then upgrading to 5.0.51 again.

[linuxcrazy]

Thanks Scott for your response. Sorry but i don't know how can i rollback the mysql back to its previous version which Plesk 8.1 was using. I've found this is the only Mysql upgrade which is causing Plesk admin panel un-usable.

I did made a backup of plesk using pleskbackup utility while giving it all switch and restoration isn't working as well.

Your insights on how to revert back to previous state will be highly appreciated.

Thanks again.

[scott]

grab the old packages, install them with rpm -Uvh --oldpackage

[linuxcrazy]

Thank you so much Scott for pointing that Plesk db could be screwed up and you know what? I just dropped and re-created the psa db by using previously backed up dump and bingooo .

Thanks to myself as i made a complete backup of databases before proceeding with upgrade.

Thanks again.

[scott]

Hey thats great news, and thanks for the follow up. Hopefully everyone does that, if they dont then there is another running 7 day backup of the PSA dbs in /var/lib/psa/.

[linuxcrazy]

Thanks Scott,
for another piece of pearl for me. "7 day backup of the PSA dbs in /var/lib/psa/".

Thanks.