Can't run plesk101_preupgrade_checker

[Louis-DavidP]

I'm planning to upgrade a big Plesk 9.3 installation to the latest version, and I can't run the upgrade checker on the original server:


[2011-01-11 03:59:46][INFO] ==> Installed Plesk version/build: 9.3.0 Windows 2003/2008 20091222.06

[2011-01-11 03:59:54][INFO] ==> Detect system configuration
[2011-01-11 03:59:54][INFO] OS: Windows
[2011-01-11 03:59:57][INFO] Arch: x86_64
[2011-01-11 04:00:08][FATAL_ERROR] [JET ERROR] Unable to connect to JET database. DSN: Provider='Microsoft.Jet.OLEDB.4.0';Data Source=C:\Parallels\Plesk\admin\db\psa.mdb


(The server is a Windows 2008 SP2 x64).

Any clue to get through this issue?

Thanks

 

[AlexN]

Are you using latest version of script ?
Try to download it from http://kb.odin.com/en/9436. Use not zipped file

I hope it will help

 

[Louis-DavidP]

Taking the .php file fixed my issue.... I originally took the .zip file.

Thanks

 

[Louis-DavidP]

It finally didn't ran through all of it:

[2011-01-11 07:50:09][INFO] ==> STEP 4: Calculate clients who have default permi
ssions
<br />
<b>Warning</b>: (null)(): Invoke() failed: Exception occurred.
<b>Source</b>: Microsoft JET Database Engine <b>Description</b>: Syntax error (
missing operator) in query expression 'perm_id is NULL AND id!=1'. in <b>C:\ples
k101_preupgrade_checker.php</b> on line <b>1205</b><br />
[2011-01-11 07:50:34][FATAL_ERROR] [JET ERROR] Unable to execute sql query SELEC
T clients.pname FROM clients WHERE perm_id is NULL AND id!=1

 

[Louis-DavidP]

Oh... Microsoft Jet doesn't support != operator.... changing it with a <> fixed the problem.