Resolved Error 500 after upgrade from Onyx to Obsidian

[Alrim]

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

 

[am3do]

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

 

[IgorG]

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

 

[Joan]

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

 

[IgorG]

Wrong segments.gen file format

Try to apply the solution from https://support.plesk.com/hc/en-us/articles/360007780053-Installing-updating-or-removing-extensions-in-Plesk-throws-error-file-segments-is-not-readable

 

[Joan]

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

 

[IgorG]

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
   

 

[Joan]

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.

 

[Joan]

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