Can't upgrade from VHCS2 due to failed database schema update

[Cojones]

Hello,

I was trying to upgrade from VHCS2 to ispCP 1.0.5 but got following error:
ispCP main configuration file
Loading old ispCP configuration file Please enter path to your ispcp.old.conf [/etc/ispcp/ispcp.old.conf]: /etc/vhcs2/vhcs2.conf
Done
Update ispCP configuration file: Done
Check ispCP configuration file: Done

ispCP database
Update ispCP database schema Failed

FATAL: An error was occured during update process!
Correct it and re-run this program.

You can find help at http://isp-control.net/forum

I tried to look for it already but I couldn't find a log or anything like that would tell me more than just "Failed". Does anyone know how to figure out what exactly went wrong?

Thanks!

[mr.x]

Hi,

(06-03-2010 03:13 AM)Cojones Wrote:  Hello,

I was trying to upgrade from VHCS2 to ispCP 1.0.5 but got following error:
ispCP main configuration file
Loading old ispCP configuration file Please enter path to your ispcp.old.conf [/etc/ispcp/ispcp.old.conf]: /etc/vhcs2/vhcs2.conf
Done
Update ispCP configuration file: Done
Check ispCP configuration file: Done

ispCP database
Update ispCP database schema Failed

FATAL: An error was occured during update process!
Correct it and re-run this program.

You can find help at http://isp-control.net/forum

I tried to look for it already but I couldn't find a log or anything like that would tell me more than just "Failed". Does anyone know how to figure out what exactly went wrong?

Thanks!

In have also done an update from vhcs 2.7.1 to ispcp 1.0.x a few days ago
and it failed too. What i have done was the installation of 1.0.5 as normal installation and then integrated all the old accounts, pwds and setting over the DB and file system.

but in your case you can activate DEBUGing in /etc/ispcp/ispcp.conf and run the job again. Please post your output here.

/Mr.X

[Cojones]

Too late, did it just like you

[mr.x]

Hi,

(06-03-2010 08:03 PM)Cojones Wrote:  Too late, did it just like you

ok, i see

/Mr.X

[slowjack2k]

A little bit late, but I'm first starting migrating to ispcp. I got the same issue. The ispcp wiki seams a little bit out of date. After some hour's

while error
try
google
end

I found a solution for me:

-1. bring vhcs2 uptodate
1. install ispcp version 1.0.0 (not 1.0.5), follow all steps in docs/System/INSTALL
2. execute the update script and select vhcs2
3. install iscp 1.0.5 follow all steps in docs/System/INSTALL
(use update section, not install) stop before perl ispcp-update
4. I had have problems with db connect, when i executed ispcp-update
(update from 1.0.0 to 1.0.5). my work around was to execute
ispcp-db-passwd, before I executed perl ispcp-update (is the update
describtion in Install missing some thing or have I done some thing wrong?)
5. execute perl ispcp-update

this worked for me. maybe it can help others too.

Regards
Jack

[mr.x]

Hi Jack,

Thanks for your feedback !

(07-18-2010 12:56 AM)slowjack2k Wrote:  2. execute the update script and select vhcs2

One comment: Its important to choose the right vhcs2 version while executing the update toispcp-

BR
Mr.X