Sirous problems after updating Ispconfig 3.1 to 3.2

Yes.

 

Yes, I told you that several times now.

But I'm not sure if you can select a different database on upgrade.

What might work is changing the database in /usr/local/ispconfig/interface/lib/config.inc.php, then running the update script and reconfigure services. So

Code:

nano /usr/local/ispconfig/interface/lib/config.inc.php

and then change

Code:

$conf['db_database'] = 'dbispconfig';

to

Code:

$conf['db_database'] = 'dbispconfig2';

and

Code:

nano /usr/local/ispconfig/server/lib/config.inc.php

and then change

Code:

$conf['db_database'] = 'dbispconfig';

to

Code:

$conf['db_database'] = 'dbispconfig2';

After that, run

Code:

cd /tmp
wget https://www.ispconfig.org/downloads/ISPConfig-3.2.tar.gz
tar xvfz ISPConfig-3.2.tar.gz
cd ispconfig3_install/install
php -q update.php

and select "yes" for reconfigure services.

 

Did you change the files I mentioned?

 

Please don't use caps and stay friendly. I am trying to help you.

It might be that the SQL updates haven't been run for your second database.
Log in to your database as root and then run the updates from install/sql/incremental/upd_0089.sql and install/sql/incremental/upd_0090.sql manually.

 

dbispconfig2 if that's your correct ISPConfig DB.

 

You told us that it used to be dbispconfig2, because you changed it, and that now, when using dbispconfig, data is missing. So then it should be dbispconfig2.

 

Run

Code:

ALTER TABLE `web_domain` ADD `server_php_id` INT(11) UNSIGNED NOT NULL DEFAULT 0;

manually on the DB. If that fixes this, you have not ran the .sql files correctly.

 

If you made a backup when updating, there is a backup in /var/backup. But never updating is not a good idea ofcourse. It's better to resolve this. You can also hire professional business support ofcourse.

 

You selected dbispconfig, while you told us before dbispconfig2 was the correct database and you changed your setup to use dbispconfig2. You asked me which db to select for the sql updates and I told you dbispconfig2 and why.

So again, you should run the updates for dbispconfig2 when you are using dbispconfig2.