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

Installation hangs when upgrading from 8.64 to 9.5.2

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by ncc@sgcom.com.s, Jun 28, 2010.

  1. ncc@sgcom.com.s

    ncc@sgcom.com.s Basic Pleskian

    23
    57%
    Joined:
    Mar 25, 2004
    Messages:
    44
    Likes Received:
    0
    We are trying to upgrade from Plesk 8.6.4 to 9.5.2 using the full installer. However, every time the installation reaches the part, "Applying security for D:\.....\Plesk\Mail Servers", the installation doesn't move on.

    We have MailEnable 3.63.

    Is there way to see the problem and resolve the problem. We have also try to create a log the file for the installation but there was nothing useful explain in the log file.

    Can someone help us?

    Thanks!
     
    Last edited: Jun 29, 2010
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Did you tried to repair Plesk with reconfigurator?
     
  3. ncc@sgcom.com.s

    ncc@sgcom.com.s Basic Pleskian

    23
    57%
    Joined:
    Mar 25, 2004
    Messages:
    44
    Likes Received:
    0
    Did that... but still the installation still get hanged at that stage.

    Since it hangs there, you cannot restart the computer with the same terminal session. We have to open another terminal session to reboot the computer.

    Once the computer is restarted, we use the AutoUpdater to check. It shows that everything is properly updated.

    I believe everything is updated except the PSA database. This can be clearly explained when we access the Plesk Panel, the followings are displayed before the login page:



    ERROR: com_exception
    <b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> The Microsoft Jet database engine cannot find the input table or query 'ip_pool'. Make sure it exists and that its name is spelled correctly.

    Additionally, an exception has occurred while trying to report this error: com_exception
    <b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> The Microsoft Jet database engine cannot find the input table or query 'PersistentCache'. Make sure it exists and that its name is spelled correctly.

    0: common_func.php3:161
    com->execute(string 'select c1.id, c1.type
    from (((clients c1
    inner join clients c2 on c1.parent_id=c2.id)
    inner join ip_pool p1 on c1.pool_id = p1.id)
    inner join ip_pool p2 on c2.pool_id = p2.id)
    inner join IP_Addresses ip on ip.id = p1.ip_address_id
    where p2.type='exclusive' and ip.ip_address = '210.193.7.250' and p2.ip_address_id = p1.ip_address_id', NULL null)

    1: common_func.php3:161
    db_query(string 'select c1.id, c1.type
    from (((clients c1
    inner join clients c2 on c1.parent_id=c2.id)
    inner join ip_pool p1 on c1.pool_id = p1.id)
    inner join ip_pool p2 on c2.pool_id = p2.id)
    inner join IP_Addresses ip on ip.id = p1.ip_address_id
    where p2.type="exclusive" and ip.ip_address = "210.193.7.250" and p2.ip_address_id = p1.ip_address_id')

    2: common_func.php3:208
    db_query_ex(string 'select c1.id, c1.type
    from (((clients c1
    inner join clients c2 on c1.parent_id=c2.id)
    inner join ip_pool p1 on c1.pool_id = p1.id)
    inner join ip_pool p2 on c2.pool_id = p2.id)
    inner join IP_Addresses ip on ip.id = p1.ip_address_id
    where p2.type="exclusive" and ip.ip_address = "?(ip)" and p2.ip_address_id = p1.ip_address_id', array)

    3: elements.php3:1144
    getCustomPageTitle(object of type UserNone)

    4: elements.php3:1117
    getPleskTitle()

    5: login.php3:28



    A check on the PSA database shows that the "ip_pool" table does not existed. The fields for "clients" table are not available or parent_id, type, overuse.

    How can I upgrade the PSA database manually?

    Any way that can be solved?
     
    Last edited: Jun 29, 2010
  4. ncc@sgcom.com.s

    ncc@sgcom.com.s Basic Pleskian

    23
    57%
    Joined:
    Mar 25, 2004
    Messages:
    44
    Likes Received:
    0
    Since it is so hard to upgrade Plesk, I think I may consider giving it up totally on the products.
     
  5. TIBS-FNQ

    TIBS-FNQ Guest

    0
     
    Ever get a reply to this? I am considering upgrade (but only if .net 4 ever becomes available), but don't want to even attempt it if there are these types of issues.
     
Loading...