J
Jamesj999
Guest
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:
Any ideas? Thanks in advance
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:
Code:
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