Upgrade fails: imscp-1.1.0-rc3 to 1.1.14

    imscp-1.1.0-rc3 to 1.1.14
    Apache FCGID


    just migrated to a new server w/o problems until I'll run an upgrade to latest I get this error message:


    Code
    1. 1062 Duplicate entry 'test' for key 'sqld_name'



    Some information are still missing, but I think not really relevant.
    i-MSCP bugs - Reporting rules


    Please add them to the thread.


    To your problem:
    It looks like you have an orphaned entry in your database. Please delete one of the test entries in your sql_database table of your imscp db.


    With following command you should get the two entries:

    Code
    1. mysql -u root -p -e 'SELECT * FROM sql_database WHERE sqld_name = "test"' imscp


    After that have a look which could be the orphaned one and delete it:

    Code
    1. mysql -u root -p -e 'DELETE FROM sql_database WHERE sqld_id = ID_ORPHANED' imscp


    PS: May the db name is ispcp instead of imscp...
    PS²: DO BACKUPS!!!