Plesk update [11.5.3 > 12.0.18] ERROR

[puntable]

Hello

I have 2 VPS running with Plesk software. They are hosted on different servers at different company's. Yesterday i started getting notification about update problems. You can see log under here.
This must be bug in Plesk, since i get error from both installations at same time?

This is original error log:

Execution failed.
Command: autoinstaller
Arguments: Array
(
    [0] => --select-product-id
    [1] => plesk
    [2] => --select-release-current
    [3] => --upgrade-installed-components
    [4] => --include-components-from-class
    [5] => vendor=parallels
    [6] => --include-components-from-class
    [7] => patched
)

Details: Doing restart of Parallels Installer...
File downloading products.inf3: 100% was finished.
File downloading plesk.inf3: 11%..22%..34%..40%..50%..64%..71%..83%..92%..100% was finished.
File downloading ppsmbe.inf3: 100% was finished.
File downloading sitebuilder.inf3: 100% was finished.
File downloading sso.inf3: 100% was finished.
File downloading setemplates.inf3: 100% was finished.
File downloading pp-sitebuilder.inf3: 18%..38%..53%..74%..94%..100% was finished.
File downloading billing.inf3: 14%..30%..41%..57%..73%..94%..100% was finished.
File downloading mysql.inf3: 100% was finished.
File downloading apache.inf3: 100% was finished.
File downloading nginx.inf3: 100% was finished.
Checking for installed packages... 
File downloading PSA_11.5.30/plesk-11.5.30-cos6-x86_64.inf3: 22%..47%..64%..71%..97%..100% was finished.
File downloading PSA_11.5.30/plesk-patches-11.5.30-cos6-x86_64.inf3: 11%..24%..32%..49%..62%..75%..88%..90%..100% was finished.
File downloading SITEBUILDER_11.5.10/sitebuilder-11.5.10-rhall-all.inf3: 100% was finished.
File downloading BILLING_11.5.30/billing-11.5.30-rhall-all.inf3: 100% was finished.
File downloading NGINX_1.5.0/nginx-1.5.0-cos6-x86_64.inf3: 100% was finished.
Loaded plugins: fastestmirror
Determining fastest mirrors
 * atomic: mir01.syntis.net
 * base: mirror.checkdomain.de
 * extras: mirror.checkdomain.de
 * updates: mirror.checkdomain.de

atomic                                                   | 3.4 kB     00:00     
atomic/primary_db         42% [======         ]  0.0 B/s | 367 kB     --:-- ETA 
atomic/primary_db         91% [=============- ] 699 kB/s | 800 kB     00:00 ETA 

atomic/primary_db                                        | 871 kB     00:00     

base                                                     | 3.7 kB     00:00     

extras                                                   | 3.4 kB     00:00     

updates                                                  | 3.4 kB     00:00     


Detecting installed product components.
Gathering information about installed license key...
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: mir01.syntis.net
 * base: mirror.checkdomain.de
 * extras: mirror.checkdomain.de
 * updates: mirror.checkdomain.de

PPB_11_5_30-dist                                         |  951 B     00:00     

PPB_11_5_30-thirdparty                                   |  951 B     00:00     

PSA_11_5_30-dist                                         | 2.9 kB     00:00     

PSA_11_5_30-thirdparty                                   | 2.9 kB     00:00     

SITEBUILDER_11_5_10-dist                                 |  951 B     00:00     

SITEBUILDER_11_5_10-thirdparty                           |  951 B     00:00     
+ psa-proftpd-xinetd
+ psa-proftpd

Following amount of diskpace required in directories:
/usr/local: 1200.00 Mb.
Total required: 1200.00 Mb, available 27064.00 Mb.

Installing packages
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: mir01.syntis.net
 * base: mirror.checkdomain.de
 * extras: mirror.checkdomain.de
 * updates: mirror.checkdomain.de
(1/2): psa-proftpd-1.3 (23%) 23% [==-         ]  0.0 B/s | 363 kB     --:-- ETA 
(1/2): psa-proftpd-1.3 (46%) 47% [=====-      ] 562 kB/s | 731 kB     00:01 ETA 
(1/2): psa-proftpd-1.3 (64%) 65% [=======-    ] 583 kB/s | 1.0 MB     00:00 ETA 
(1/2): psa-proftpd-1.3 (80%) 80% [=========-  ] 593 kB/s | 1.2 MB     00:00 ETA 
(1/2): psa-proftpd-1.3 (96%) 97% [===========-] 607 kB/s | 1.5 MB     00:00 ETA 

(1/2): psa-proftpd-1.3.5-6.el6.art.x86_64.rpm            | 1.5 MB     00:01     

(2/2): psa-proftpd-xinetd-1.3.5-6.el6.art.x86_64.rpm     |  14 kB     00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA1 Signature, key ID 4520afa9: NOKEY
Fatal error during packages installation: The GPG keys listed for the "CentOS / Red Hat Enterprise Linux 6 - atomicrocketturtle.com" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.
YumBaseError: The GPG keys listed for the "CentOS / Red Hat Enterprise Linux 6 - atomicrocketturtle.com" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.

ERROR: Failed to run the Yum utility.
The Yum utility failed to install the required packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

After searching on the web i tried this solution to fix the problem (yum update). After this fix i restart server and when i login to panel i now see this error:

ERROR: PleskMainDBException
MySQL query failed: Unknown column 's.click_time' in 'field list'

http://screencast.com/t/aHd4iHjjbN0F

Any ideas how to fix update AND new problem?

Kind regards

 

[IgorG]

Please use forum search before posting.

http://forum.parallels.com/showthread.php?304144

 

[Krullone]

I have the same issue and I did search the forum first:

Result by search for: MySQL query failed: Unknown column "s.click_time" in "field list"
Found 0 articles.

Igor, I checked out and did what was asked in the article you linked to and I still get the same error.


ERROR: PleskMainDBException

MySQL query failed: Unknown column 's.click_time' in 'field list'

 

[puntable]

Hi Krullone

I managed to fix by removing atomic repo, dropping PSA database and importing the backup that was created when you tried to upgrade the panel. After this you can access to panel again.
I then had to restore full backup of all sites because they all stopped working. All sites were showing the default plesk page.

Good luck

 

[Krullone]

Hello Puntable

Thank you for the information, it sounds like a lot more fun than I was hoping for!

 

[barnrose]

Hi Guys,

I had the same issue with failed update and also

ERROR: PleskMainDBException

MySQL query failed: Unknown column 's.click_time' in 'field list'

This thread pointed me in the right direction to solve it.

I updated via SSH by doing the following:

/usr/local/psa/admin/sbin/autoinstaller

I just followed step by step and installed Parallels 12.0.18 and now it all works.

Hope it works for you too.

 

[Krullone]

Thank you, barnrose! That did the trick and was much less painful than the alternative. I knew if I stalled long enough the solution would present itself

 

[BunyaminV]

thanks barnrose, i guess the the only solution of this problem is this for now...