PleskMainDBException

[Jamesj999]

PleskMainDBException *SOLVED*

Hey guys, I did a yum update on the server, which broke httpd (now fixed, was the ionCube problem). But then I stupidly tried to upgrade to plesk 8 when the httpd was still broken. I have tried to do the upgrade again via shell using the script provided, but nothing. I don't really want to remove plesk and install it again, unless that won't remove any of my existing settings...

Anyway, now I surf to where plesk should be and I get:

ERROR: PleskMainDBException
MySQL query failed: Invalid default value for 'srv_bandwidth'

0: /usr/local/psa/admin/plib/common_func.php3:229
	db_query(string 'ALTER TABLE `module_bf1942_servers` MODIFY `rcon_username` varchar(32) CHARACTER SET binary  NOT NULL default ''')
1: /usr/local/psa/admin/plib/mysql41/mysql41.php:39
	mysql41_adopt_column(string 'module_bf1942_servers', string 'rcon_username', string 'varchar(32)', string ' NOT NULL default ''', array)
2: /usr/local/psa/admin/plib/mysql41/mysql41.php:112
	MySQL41TableUpgrader->_handleColumn(array)
3: /usr/local/psa/admin/plib/SQLParser.php:99
	SQLParser->_parseLineInTable(string '  `rcon_username` varchar(32) NOT NULL default '',')
4: /usr/local/psa/admin/plib/SQLParser.php:45
	SQLParser::parseLine(string '  `rcon_username` varchar(32) NOT NULL default '',', integer '4')
5: :
	array_walk(array, array)
6: /usr/local/psa/admin/plib/SQLParser.php:25
	SQLParser->getArray(array)
7: /usr/local/psa/admin/plib/mysql41/mysql41.php:67
	mysql41_adopt_table(string 'module_bf1942_servers', array, string 'utf8', string 'utf8_general_ci')
8: /usr/local/psa/admin/plib/mysql41/mysql41.php:29
	mysql41_adopt_database(array, string 'utf8', string 'utf8_general_ci')
9: /usr/local/psa/admin/plib/mysql41/MySQL41PSADBUpgrader.php:47
	MySQL41PSADBUpgrader->run()
10: /usr/local/psa/admin/plib/mysql41/mysql41_psa.php:28
	mysql41_adopt_psa_database(string 'php://stderr', boolean  false)
11: /usr/local/psa/admin/auto_prepend/auth.php3:88

Any ideas? Thanks in advance

 

[otsego]

http://forum.swsoft.com/showthread.php?s=&threadid=32164

 

[Jamesj999]

Omg, thanks mate

Was searching for a post like that in the forums, but couldn't find it!

Thanks so much, works fine now