ERROR while trying to check database version

[FleurW]

Hi,

I am new to Plesk and Linux, just been trying to upgrade from Plesk 9.2.3 to 10.1.

When I try and upgrade using autoinstall, it gets so far into the process and comes back with this:

ERROR while trying to check database version
Check the error reason(see log file: /tmp/pp10.9.0-bootstrapper.110118.16.23.log), fix
and try again

Then, when I got to repair the database, it gives me this:

Parallels Plesk Panel 9.2.3

**** Product repair failed.

***** problem report *****
ERROR while trying to execute SQL query, the query was: ALTER TABLE Templates ADD UNIQU
E(uuid)

Please can somebody help and tell me how to fix this?

Thanks.

 

[IgorG]

What sort of error in the mentioned /tmp/pp10.9.0-bootstrapper.110118.16.23.log ?

Also you can check that you really have database version with following sql query:

select * from misc where param='version';

 

[FleurW]

I typed vi /tmp/pp10.9.0-bootstrapper.110118.16.23.log and it gave me the same error e.g. error trying to get database version that I pasted into my last message, I am really sorry but I am new so do forgive me! I am a little out of my depth here.

I pasted the command to find out the sql version verbatim and got an error - yikes! I do know that I have done an SQL upgrade so it must be the latest release.

Started a new job so sorry for the delay in repies, if you could tell me how to get at the bootstrapper log in simplistic terms I will paste in on here.

Many, many thanks for your reply.