Column not found: 1054 Unknown column 'pleskId' in 'where clause'

[Kamin1]

I upgraded my control panel from 8.6 to 10.0 then 10.4.4 and then up to 11.0.9. After the upgrade I am receiving this error "Column not found: 1054 Unknown column 'pleskId' in 'where clause' "

I have attached a screenshot to better show the error. Can anyone help with this?

 

[abdi]

Please try repairing and upgrading the database with bootstrapper:

/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair

 

[Kamin1]

I ran the command, but no luck. The error persists.


I am also seeing this error and cant clear it. "New files of configuration for Apache web server were not built due to errors in configuration templates: Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhostIpDefault.php, error = SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pleskId' in 'where clause'. The detailed error message was e-mailed to you, so please check the e-mail, fix the errors, and click here to retry generating broken configuration or click here to retry generating of all configurations."


I have searched the forums and google for answers without any luck.

 

[abdi]

Sounds like your database did not get upgraded successfully. First of all backup all your data somewhere safe, and try re-running the installer again and install any missing component ..(that could help to upgrade your plesk db).

If that also fails, then plesk re-installation might be a quicker solution ...Re-installing plesk does not make you loose any of your data, actually ALL data is intact (ie DBs, emails, sites and etc).

 

[Kamin1]

I've tried the autoinstaller 4 times and it wont add the missing fields. I have backed everything up and wiping plesk. I am now reinstalling from scratch. It may seem drastic, but at this point I just want the thing to work.

 

[abdi]

Alright, just let me know if that resolves the problem ...

 

[Kamin1]

Well the re-install went well. I converted the 8.6 backups using the pre9 and pre10 converters, but the converted backups don't show up in the backup manager. Do I have to recreate the clients by hand first?

 

[abdi]

Did you move the backup files to /var/lib/psa/dumps/ folder?

 

[Kamin1]

I was able to get things working, now I need to get php 5.2 installed since zend optimizer wont work with php 5.3. I tried the new zend guard but the site that needs it wont work with zend guard.

 

[abdi]

Great about that, to downgrade to php 5.2 is pretty easy, just run the commands below:

yum downgrade php*

 

[Kamin1]

I tried that but it wouldnt downgrade further than 5.3.3. It just keeps returning "Nothing to do"

 

[abdi]

Try adding this repo first:

wget -q -O - http://www.atomicorp.com/installers/atomic.sh | sh

Then you run that downgrade yum ...

 

[Kamin1]

[root@www /]# yum downgrade php*
Loaded plugins: rhnplugin, security
Setting up Downgrade Process
No Match for available package: php-5.1.6-5.el5.i386
No Match for available package: php-Smarty-2.6.13-1.el5.art.noarch
No Match for available package: php-adodb-4.52-1.el5.art.noarch
No Match for available package: php-bcmath-5.1.6-5.el5.i386
No Match for available package: php-cli-5.1.6-5.el5.i386
No Match for available package: php-common-5.1.6-5.el5.i386
No Match for available package: php-dba-5.1.6-5.el5.i386
No Match for available package: php-devel-5.1.6-5.el5.i386
No Match for available package: 1:php-eaccelerator-5.2.17_0.9.6.1-1.el5.art.i386
No Match for available package: php-embedded-5.2.17-1.el5.art.i386
No Match for available package: php-enchant-5.3.8-2.el5.art.i386
No Match for available package: php-fpdf-1.53-1.el5.art.noarch
No Match for available package: php-fpm-5.3.8-2.el5.art.i386
No Match for available package: php-gd-5.1.6-5.el5.i386
No Match for available package: php-imap-5.1.6-5.el5.i386
No Match for available package: php-intl-5.3.8-2.el5.art.i386
No Match for available package: 1:php-ioncube-loader-3.3.7-1.el5.art.i386
No Match for available package: php-jpgraph-2.2-1.el5.art.noarch
No Match for available package: php-ldap-5.1.6-5.el5.i386
No Match for available package: php-mbstring-5.1.6-5.el5.i386
No Match for available package: php-mcrypt-5.2.17-1.el5.art.i386
No Match for available package: php-mhash-5.2.17-1.el5.art.i386
No Match for available package: php-mssql-5.2.17-1.el5.art.i386
No Match for available package: php-mysql-5.1.6-5.el5.i386
No Match for available package: php-mysqlnd-5.3.9-3.el5.art.i386
No Match for available package: php-ncurses-5.1.6-5.el5.i386
No Match for available package: php-odbc-5.1.6-5.el5.i386
No Match for available package: php-pdo-5.1.6-5.el5.i386
No Match for available package: 1:php-pear-1.4.9-4.noarch
No Match for available package: php-pear-Console-Getargs-1.3.4-1.el5.art.noarch
No Match for available package: php-pear-Crypt-CBC-0.4-1.el5.art.noarch
No Match for available package: php-pear-Crypt-GPG-1.0.0-1.el5.art.noarch
No Match for available package: php-pear-Image-Canvas-0.3.1-3.el5.el5.art.noarch
No Match for available package: php-pear-Image-Color-1.0.2-6.el5.art.noarch
No Match for available package: php-pear-Image-Graph-0.7.2-5.el5.art.noarch
No Match for available package: php-pear-Mail-1.1.14-2.el5.art.noarch
No Match for available package: php-pear-Numbers-Roman-1.0.2-3.el5.art.noarch
No Match for available package: php-pear-Numbers_Words-0.15.0-1.el5.art.noarch
No Match for available package: php-pecl-Fileinfo-1.0.4-2.el5.art.i386
No Match for available package: php-pecl-apc-3.1.9-3.el5.art.i386
No Match for available package: php-pecl-apc-devel-3.1.9-3.el5.art.i386
No Match for available package: php-pecl-memcache-3.0.6-1.el5.art.i386
No Match for available package: php-pgsql-5.1.6-5.el5.i386
No Match for available package: php-process-5.2.17-1.el5.art.i386
No Match for available package: php-pspell-5.2.17-1.el5.art.i386
No Match for available package: php-recode-5.2.17-1.el5.art.i386
No Match for available package: php-snmp-5.1.6-5.el5.i386
No Match for available package: php-soap-5.1.6-5.el5.i386
No Match for available package: php-sqlite-5.3.8-2.el5.art.i386
No Match for available package: php-sqlite2-5.3.9-1.el5.art.i386
No Match for available package: php-suhosin-0.9.29-1.el5.art.i386
No Match for available package: php-tidy-5.2.17-1.el5.art.i386
No Match for available package: php-xml-5.1.6-5.el5.i386
No Match for available package: php-xmlrpc-5.1.6-5.el5.i386
No Match for available package: php-zend-guard-loader-5.5.0-1.el5.art.i386
No Match for available package: 1:php-zend-optimizer-3.3.9-1.el5.art.i386
No Match for available package: php-zts-5.2.17-1.el5.art.i386
Only Upgrade available on package: php53-5.3.3-1.el5.i386
No Match for available package: php53-bcmath-5.3.3-1.el5.i386
Only Upgrade available on package: php53-cli-5.3.3-1.el5.i386
Only Upgrade available on package: php53-common-5.3.3-1.el5.i386
No Match for available package: php53-dba-5.3.3-1.el5.i386
No Match for available package: php53-devel-5.3.3-1.el5.i386
Only Upgrade available on package: php53-gd-5.3.3-1.el5.i386
Only Upgrade available on package: php53-imap-5.3.3-1.el5.i386
No Match for available package: php53-intl-5.3.3-1.el5.i386
No Match for available package: php53-ldap-5.3.3-1.el5.i386
Only Upgrade available on package: php53-mbstring-5.3.3-1.el5.i386
Only Upgrade available on package: php53-mysql-5.3.3-1.el5.i386
No Match for available package: php53-odbc-5.3.3-1.el5.i386
Only Upgrade available on package: php53-pdo-5.3.3-1.el5.i386
No Match for available package: php53-pgsql-5.3.3-1.el5.i386
No Match for available package: php53-process-5.3.3-1.el5.i386
No Match for available package: php53-pspell-5.3.3-1.el5.i386
No Match for available package: php53-snmp-5.3.3-1.el5.i386
No Match for available package: php53-soap-5.3.3-1.el5.i386
Only Upgrade available on package: php53-xml-5.3.3-1.el5.i386
No Match for available package: php53-xmlrpc-5.3.3-1.el5.i386
No Match for available package: phpMyAdmin-2.11.9-1.el5.art.noarch
No Match for available package: phpgacl-3.3.7-1.el5.art.noarch
Nothing to do

This is what I get after installing that new package. It's the same error as before.

 

[abdi]

Will these threads help:

http://forum.parallels.com/showthread.php?t=110631
http://forum.parallels.com/showthread.php?t=113464
http://forum.parallels.com/showthread.php?t=110631