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

MANY problems after upgrade from 8.2 to 9.2.1

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by elenlace, Jul 14, 2009.

  1. elenlace

    elenlace Guest

    0
     
    Hello,

    We migrated a server from 8.2 to 9.2.1 as we heard most issues when upgrading were ironed out.

    Unfortunately, we were wrong, we have had many severe issues and no one seems to be able to help (at Parallels at least):

    1) The main default pages come out blank, for Admin, Resellers, Clients and Domains. So basically as an admin you are unable to modify a domain as you can't see the dashboard.
    2) When entering as domain user using the domain password, you are able to modify things if you go directly to the "Settings" left menu option, but again the main/home page (dashboard) is blank.
    3) We get several errors such as these when modifying things:

    Notice: Undefined index: 8-132 in C:\Program Files\SWsoft\Plesk\admin\plib\dashboard\Dashboard.php on line 73

    4) When creating a new e-mail account we get the following error:

    <b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> The INSERT INTO statement contains the following unknown field name: 'disk_usage'. Make sure you have typed the name correctly, and try the operation again.
    ---------------------- Debug Info -------------------------------
    0: common_func.php3:160
    com->execute(string 'insert into [mail] ( [mail_name], [postbox], [account_id], [perm_id], [redirect], [redir_addr], [mail_group], [autoresponder], [mbox_quota], [disk_usage], [dom_id]) values( 'xxx', 'false', '2035', '0', 'false', '', 'false', 'false', '-1', '0', '132')', NULL null)
    1: common_func.php3:160
    db_query(string 'insert into [mail] ( [mail_name], [postbox], [account_id], [perm_id], [redirect], [redir_addr], [mail_group], [autoresponder], [mbox_quota], [disk_usage], [dom_id]) values( 'xxx', 'false', '2035', '0', 'false', '', 'false', 'false', '-1', '0', '132')')
    2: class.Table.php:328
    Table->insertData(array)
    3: class.Table.php:293
    Table->update(array)
    4: class.cObject.php:357
    cObject->update()
    5: MailName.php:1044
    Mailname->update()
    6: mail_name_preferences.php:98
    require(string 'C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\mail\mail_name_preferences.php')
    7: plesk.php:56

    5) When editing a current e-mail account, we get this error:

    ERROR: com_exception
    <b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> No value given for one or more required parameters.

    Additionally, an exception has occurred while trying to report this error: com_exception
    <b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> No value given for one or more required parameters.

    0: common_func.php3:160
    com->execute(string 'select [id], [mail_name], [postbox], [account_id], [perm_id], [redirect], [redir_addr], [mail_group], [autoresponder], [mbox_quota], [disk_usage], [dom_id] from [mail] where [id]=1273', NULL null)
    1: common_func.php3:160
    db_query(string 'select [id], [mail_name], [postbox], [account_id], [perm_id], [redirect], [redir_addr], [mail_group], [autoresponder], [mbox_quota], [disk_usage], [dom_id] from [mail] where [id]=1273')
    2: class.Table.php:186
    Table->select()
    3: class.cObject.php:484
    cObject->fetchAttrsFromTable_()
    4: MailName.php:96
    Mailname->Mailname(integer '1273')
    5: common_func.php3:3077
    objectMaker(string 'MailName', integer '1273')
    6: User.php:93
    User::getMailNameById(integer '1273')
    7: UserDomain.php:158
    UserDomain->checkManageMailname(integer '1273')
    8: client.domain.mail.mailname.php:28
    __plesk__client__domain__mail__mailname->validateItem(object of type UserDomain)
    9: UIPointer.php:1128
    UIPointer->validate()
    10: UIPointer.php:553
    UIPointer->access(string 'GET')
    11: plesk.php:43

    6) When clicking the Applications menu as a Domain Owner we get the following:

    <b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> The Microsoft Jet database engine cannot find the input table or query 'APSApplicationItems'. Make sure it exists and that its name is spelled correctly.
    ---------------------- Debug Info -------------------------------
    0: common_func.php3:160
    com->execute(string 'SELECT sa.id, sa.dom_type, sd.displayName, sa.install_prefix, sa.htdocs_directory, sapkg.name, sapkg.version, sa.app_release, sapkg.description, sapkg.access_level, sa_url.value, sapkg.package_type, sa.capp_item_id, sa.license_id, ai.license_type_id, lt.description FROM (((((SiteApps AS sa INNER JOIN APSClientApplicationItems csai ON (sa.capp_item_id=csai.id)) INNER JOIN APSApplicationItems ai ON (csai.app_item_id=ai.id)) LEFT JOIN APSLicenseTypes AS lt ON (ai.license_type_id=lt.id)) INNER JOIN SiteAppPackages AS sapkg ON (ai.pkg_id=sapkg.id)) LEFT JOIN subdomains AS sd ON (sd.id = sa.dom_id)) LEFT JOIN [Parameters] AS sa_url ON (sa.params_id=sa_url.id AND sa_url.parameter='application_url') WHERE (sa.dom_id=132 AND sa.dom_type='domain') OR (sd.dom_id=132 AND sa.dom_type='subdomain')', NULL null)
    1: common_func.php3:160
    db_query(string 'SELECT sa.id, sa.dom_type, sd.displayName, sa.install_prefix, sa.htdocs_directory, sapkg.name, sapkg.version, sa.app_release, sapkg.description, sapkg.access_level, sa_url.value, sapkg.package_type, sa.capp_item_id, sa.license_id, ai.license_type_id, lt.description FROM (((((SiteApps AS sa INNER JOIN APSClientApplicationItems csai ON (sa.capp_item_id=csai.id)) INNER JOIN APSApplicationItems ai ON (csai.app_item_id=ai.id)) LEFT JOIN APSLicenseTypes AS lt ON (ai.license_type_id=lt.id)) INNER JOIN SiteAppPackages AS sapkg ON (ai.pkg_id=sapkg.id)) LEFT JOIN subdomains AS sd ON (sd.id = sa.dom_id)) LEFT JOIN `Parameters` AS sa_url ON (sa.params_id=sa_url.id AND sa_url.parameter="application_url") WHERE (sa.dom_id=132 AND sa.dom_type="domain") OR (sd.dom_id=132 AND sa.dom_type="subdomain")')
    2: class.SiteAppsList.php:133
    SiteAppsList->fetchSiteAppsList()
    3: class.cList.php3:105
    cList->fetchList()
    4: class.cList.php3:124
    cList->init()
    5: SiteApplicationsUIPointer.php:108
    SiteApplicationsUIPointer->accessItem(string 'GET', NULL null)
    6: UIPointer.php:601
    UIPointer->access(string 'GET')
    7: plesk.php:43

    7) No icons show up to add or modify databases, both for MySQL or SQL Server

    8) And many other similar issues

    Any help is GREATLY appreciated.

    To Parallels: You should get your act together before Cpanel comes out with their software, it is a pitty that upgrading from 2 versions can give out so many issues.
     
  2. JeffT

    JeffT Guest

    0
     
    I had the same issue with no icons in the control panel. I am using IE8 and what I had to do is change IE to run in compatability mode for that server, or use Firefox.
     
  3. Maa

    Maa Guest

    0
     
    Seems like Plesk DB was not upgraded. Multiple DB queries searching for inexistent tables/rows. It is one but huge problem...

    You can verify this with the following query:
    "%plesk_bin%\dbclient.exe" --direct-sql --sql="select * from misc where param='version';"

    Any chance of restoring backup and re-trying the upgrade?
     
Loading...