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: Code: 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: Code: 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: Code: 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?
If you want to import the database dump, you must empty (but dont delete!) the tables in db_ispconfig before the import.
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? Thanks,
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.
