• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

MANY problems after upgrade from 8.2 to 9.2.1

E

elenlace

Guest
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.
 
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.
 
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?
 
Back
Top