View Single Post
Old 14th March 2011, 16:51
borispapin borispapin is offline
Junior Member
Join Date: Mar 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

Thank you very much for your answer.

First a few precisions that may be useful :
- The svn version of ispconfig has been installed on this server a while ago.
- Before the upgrade, column document_root_www exists and has only NULL entries
- After the upgrade, document_root_www doesn't exist.

Trying to follow your advices, I create it manually with :
$ mysql -root -p dbispconfig
mysql> ALTER TABLE web_domain ADD document_root_www VARCHAR(255);
Query OK, 0 rows affected (0.21 sec)
Records: 0 Duplicates: 0 Warnings: 0

When importing the database directly i get :
$ mysql -u root -p dbispconfig </root/ispconfig_db_backup_2011-03-14_02-15.sql
Enter password:
ERROR 1062 (23000) at line 33: Duplicate entry '1' for key 1

... if I empty each table (TRUNCATE) and try to import it again, it raises no error, all data seems here.

But still the problem remains and I can't login to the web interface ;

Do you see what I am doing wrong ?
Should I better start over with fresh install (and backup/restore the web site data , passwd files, etc.)

Thank you for your help,

Reply With Quote