1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Can't run plesk101_preupgrade_checker

Discussion in 'Plesk 10.x for Windows Issues, Fixes, How-To' started by Louis-DavidP, Jan 11, 2011.

  1. Louis-DavidP

    Louis-DavidP Guest

    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?

  2. AlexN

    AlexN Guest

    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
    Last edited by a moderator: Jan 11, 2011
  3. Louis-DavidP

    Louis-DavidP Guest

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

  4. Louis-DavidP

    Louis-DavidP Guest

    It finally didn't ran through all of it:

    [2011-01-11 07:50:09][INFO] ==> STEP 4: Calculate clients who have default permi
    <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
  5. Louis-DavidP

    Louis-DavidP Guest

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