• 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!
  • 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.

Resolved Error 500 after upgrade from Onyx to Obsidian

Alrim

New Pleskian
Hello,
I updated Plesk to Obsidian yesterday, and since then I can not access the TLS / SSL certificates and PHP Composer modules.

I get the following error for TLS/SSL certificates: Server Error 500 - Zend_Db_Table_Exception - A table must have a primary key, but none was found for table 'Orders'
And that one for PHP Composer: Server Error 500 - Zend_Db_Table_Exception - A table must have a primary key, but none was found for table 'Application'

I tried plesk repair installation, and I updated all linux package.
What can I do to correct the problem?

Thanks,

Alrim
 
Hi! Same here, after update today:

Server Error
500
Zend_Db_Table_Exception

Type Zend_Db_Table_Exception
Message A table must have a primary key, but none was found for table 'Orders'
File Abstract.php
Line 889

I have updated all packages as well, restarted the server. The issue is still present. I'd appreciate any help.

Thanks
am3do
 
Usually, it is caused by a corrupted database of the SSL It! extension.
Just reinstall this extension with:

# plesk bin extension -u sslit
# plesk bin extension -i sslit
 
Hello,
I'm having the same issue. Even after follow your advise.
I had this message:

exit status 1
root@localhost:~# plesk bin extension -i sslit
Wrong segments.gen file format
exit status 3
root@localhost:~#

When I went to ssl /tls certificates the next message appears:

Server Error
500
Zend_Db_Table_Exception
A table must have a primary key, but none was found for table 'Orders'
Type Zend_Db_Table_Exception
Message A table must have a primary key, but none was found for table 'Orders'
File Abstract.php
Line 889


Thank you for your help
 

Attachments

  • Captura de pantalla 2019-12-11 a las 11.54.15.png
    Captura de pantalla 2019-12-11 a las 11.54.15.png
    43.6 KB · Views: 1
Hello IgorG
Thank you for your help. But unfortunately it didn't work.
I try reinstalling, plesk and all the services, but nothing works.
Also I have this error:
Failed to update Plesk. Autoinstaller
And these are the lines of the log: (I don't know if booth problems are related.

Registering i386 architecture support
Synchronizing the Debian APT package index files...
Reading package lists...
E: Could not get lock /var/lib/apt/lists/lock - open (11: Resource temporarily unavailable)
E: Unable to lock directory /var/lib/apt/lists/
Warning: there are errors in 'apt-get update'
Detecting installed product components.
OK
Synchronizing the Debian APT package index files...
Reading package lists...
E: Could not get lock /var/lib/apt/lists/lock - open (11: Resource temporarily unavailable)
E: Unable to lock directory /var/lib/apt/lists/
Warning: there are errors in 'apt-get update'
Retrieving information about the installed license key...
Launching component and product checkers...
Downloading file pool/PSA_18.0.21_1659/examiners/disk_space_check.sh: 0%
Downloading file pool/PSA_18.0.21_1659/examiners/disk_space_check.sh: 100% was finished.
Checking whether the package dependencies are resolved.
Installing packages
Installing the package PHP Composer 1.0.3-178

ERROR: Failed to install or upgrade the extension 'PHP Composer' (package: composer):
Wrong segments.gen file format
 
Unable to lock directory /var/lib/apt/lists/
Looks like hanged processes. Try to do following:
  1. Execute:
    # ps aux | grep "fsmng --fix-plesk-packages"

  2. Kill process(es) from the output:
    # kill -9 109
 
This second problem is ok.
But I stay with the first one.
One of the strange things is that I cannot found any Orders table.
 
Finally!
For me what works was removing and installing againg SSL it! Plesk Extension.
I though I did it by command, but maybe not or simply didn't work.
I did it with add and remove product components tool and it works.
Thank you for your answers
 
Back
Top