Database not migrated after upgrade (2.2.9->2.2.10)

Discussion in 'Installation/Configuration' started by okhayat, Mar 3, 2007.

  1. okhayat

    okhayat New Member

    After successfully upgrading my installation, I couldn't login to my control panel. I check the mysql server and I noticed that the db_ispconfig database is empty.
    When inspecting the logs, I found the following:
    Thu Mar 1 01:04:03 IRST 2007 - [ISPConfig] - /root/install_ispconfig/install.php, Line 795: WARNING: could not read in db_ispconfig.sql
    Thu Mar 1 01:04:04 IRST 2007 - [ISPConfig] - /root/install_ispconfig/install.php, Line 802: imported existing_db.sql
    I tried to restore the database manually from the mysql dump and I got an error:
    cpanel:~/install_ispconfig# mysql -p db_ispconfig < db_ispconfig.sql
    Enter password:
    cpanel:~/install_ispconfig# mysql -p db_ispconfig < /tmp/existing_db_02_27_2007__17_20_04.sql
    Enter password:
    ERROR 1062 at line 164: Duplicate entry '3' for key 1
    Part of the line that has the error is:
    INSERT INTO `doctype` (`doctype_id`, `userid`, `groupid`, `doctype_modul`, `doctype_name`, `doctype_title`, `doctype_def`, `doctype_tree`) VALUES (3,1,1,'sys','news','News','O:3:\"doc\":28:{s:6:\"userid\";s:1:\"1\";s:7:\"groupid\";s:1:\"1\";s:14:\"group_required\";s:1:\"0\";s:5:\"modul\";s:3:\"sys\"
    What's wrong?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    If you want to import the database dump, you must empty (but dont delete!) the tables in db_ispconfig before the import.
  3. okhayat

    okhayat New Member

    Is there any way to empty all table at once?

    Also, is this normal? I mean, shouldn't it import the data again once the software is upgraded?

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    If you have phpmyadmin installed, select all tables and then chose empty.

    That's not normal. I dont know why it has not imported your data. I'am doing ISPConfig installations and updates almost every day but it did not happen to me yet.

Share This Page