• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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