1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySQL Upgrade Problems

Discussion in 'Plesk for Linux - 8.x and Older' started by cclever, May 11, 2006.

  1. cclever

    cclever Guest

    Have just upgraded MySQL 3.23 to 4.1.18 on a Fedora Core 2 server with Plesk 8. All was OK with the MySQL upgrade until attempting to access Plesk - I received this string of errors:

    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_bf2_servers` MODIFY `hosting_address` varchar(255) CHARACTER SET binary NOT NULL default ''')
    1: /usr/local/psa/admin/plib/mysql41/mysql41.php:39
    mysql41_adopt_column(string 'module_bf2_servers', string 'hosting_address', string 'varchar(255)', string ' NOT NULL default ''', array)
    2: /usr/local/psa/admin/plib/mysql41/mysql41.php:112
    3: /usr/local/psa/admin/plib/SQLParser.php:99
    SQLParser->_parseLineInTable(string ' `hosting_address` varchar(255) NOT NULL default '',')
    4: /usr/local/psa/admin/plib/SQLParser.php:45
    SQLParser::parseLine(string ' `hosting_address` varchar(255) NOT NULL default '',', integer '3')
    5: :
    array_walk(array, array)
    6: /usr/local/psa/admin/plib/SQLParser.php:25
    7: /usr/local/psa/admin/plib/mysql41/mysql41.php:67
    mysql41_adopt_table(string 'module_bf2_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
    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

    I previously did the same MySQL upgrade on another FC2 server running Plesk 7.5 Reloaded with no problems. Anyone have any idea what would be causing these errors?

    Thanks in advance.

  2. elmister

    elmister Guest

    I had the same issue today with Plesk 8 on Centos 3.7 after upgrading to mysql 4.1.19

    After some investigation, i realized that the problem was in the plesk database, so you'll have to make this change.

    use mysql console, or install phpmyadmin in one of the sites.

    Database: psa
    table: module_bf2_servers

    USE psa;
    ALTER TABLE `module_bf2_servers` CHANGE `srv_bandwidth` `srv_bandwidth` ENUM( '0', '8', '16', '32', '64', '128', '256', '512' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0';

    or simply add a default value of "0" to field srv_bandwidth on that table, the error comes because there is no default value.

    Of course, before modifying the database, i recommend you to make backups.

    It worked for me, hope it works for you.