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

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

K

Kamin1

Guest
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?
 

Attachments

  • pleskerror.jpg
    pleskerror.jpg
    59 KB · Views: 6
Please try repairing and upgrading the database with bootstrapper:

/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair
 
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.
 
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).
 
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.
 
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?
 
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.
 
Great about that, to downgrade to php 5.2 is pretty easy, just run the commands below:

yum downgrade php*
 
I tried that but it wouldnt downgrade further than 5.3.3. It just keeps returning "Nothing to do"
 
Code: 
[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.
 
You must log in or register to reply here.

Similar threads

Edi Duluman
Resolved Access denied for user 'admin'@'localhost' after dist-upgrade
Replies
2
Views
775
Edi Duluman
Edi Duluman
G
Issue DB query failed - Deadlock
Replies
2
Views
248
Sebahat.hadzhi
Sebahat.hadzhi
I
Issue New mail queue showing widget showing items, but nothing in the mail queue
Replies
2
Views
494
inspyred
I
M
Issue Plesk Update 18.0.34 to 18.0.57 Database 'psa' not found
Replies
10
Views
3K
musa.sc
M
S
Issue 500 Plesk\Exception\Database || DB query failed: SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client.
Replies
1
Views
2K
Peter Debik
P
Back
Top