• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Specified column "name" is not in the row

A

alreadytaken

New Pleskian
When calling the new Wordpress Management Option from the 'Websites&Domains' page in Plesk (Version: 12.0.18 Update #4, OS: Ubuntu 12.04.4 LTS), the page that is supposed to show the list of Wordpress installations (/smb/wordpress/list) shows an error "Specified column "name" is not in the row".

Exact output:
Internal error: Specified column "name" is not in the row
Message Specified column "name" is not in the row
File Abstract.php
Line 179
Type Zend_Db_Table_Row_Exception​

I already tried bootstrapper repair without success. Other functions in Plesk seem to work, there are at least two Wordpress installation on the server (one through Plesk, one manual installation). How can I get rid of this error without risking my Plesk settings?
 
Looks like database inconsistency. Missed "name" field in one of tables. Check "WordpressInstanceProperties" at least.
Is it upgraded Plesk or fresh installation?
 
Thanks your help, IgorG. This is an upgraded Plesk installation.

I've tried Plesk Database Inconsistency Checker (Beta) and Plesk Database Schema Checker, but both do not seem to work with Plesk 12. Couldn't find "WordpressInstanceProperties" manually ... might be missing or I'm just unable to find it?

I'm still able to revert to Plesk 11.5 by restoring a full backup. Maybe thats the best solution?
 
It seems upgrade procedure was not completed successfully. Try to run it again with

# /usr/local/psa/admin/sbin/autoinstaller --select-product-id plesk --select-release-current --reinstall-patch --install-component base
 
Tried that, but I'm getting the following warning and the error in the backend about the missing column remains:

Warning: following component(s) not found in product plesk: 'base'
 
Make sure that you have line

Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
Click to expand...

after running

# /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair
 
IgorG said:
Make sure that you have line

"Cumulative upgrade and repair of Plesk database (revertable stage) has been completed."

after running

# /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair
Click to expand...
The line was there, but still get he error when going to the WordPress page.

is "WordpressInstanceProperties" a database table? Where can I find it?
 
On my test Plesk 12 server I see:

mysql> desc WordpressInstanceProperties;
+---------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+------------------+------+-----+---------+-------+
| wordpressInstanceId | int(10) unsigned | NO | PRI | NULL | |
| name | varchar(255) | NO | PRI | NULL | |
| value | mediumblob | NO | | NULL | |
+---------------------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
 
Having run the bootstrapper repair

r# ./bootstrapper.sh repair
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative APS controller database (apsc) upgrade and repair has been started.
===> Cumulative upgrade and repair of APS controller database has been completed.
===> Cumulative APS controller upgrade and repair (final stage) has been started.
===> Cumulative upgrade and repair of APS controller (final stage) has been completed.
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
===> Cumulative Plesk upgrade and repair (final stage) has been started.
===> Preparing Plesk upgrade (final stage).
===> Cumulative upgrade and repair of Plesk (final stage) has been completed.
Reconfiguring mail subsystem...
Reconfiguring Apache web server...
Reconfiguring ProFTPD FTP server...
Reconfiguring AWStats web statistics...
Reconfiguring WatchDog...
Restoring SELinux contexts...
Regenerating web servers' configuration files...
Cleaning active Panel sessions...

Bootstrapper repair finished.
If problems persist, please check installer logs ('/var/log/plesk/install/plesk_12.0.18_repair.log' and '/var/log/plesk/install/plesk_12.0.18_repair_problems.log') for errors.
If you can't resolve the issue on your own, please address Parallels support.

The log file suggests no errors.

mysql> desc WordpressInstanceProperties;
+---------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+------------------+------+-----+---------+-------+
| wordpressInstanceId | int(10) unsigned | NO | PRI | NULL | |
| name | varchar(255) | NO | PRI | NULL | |
| value | mediumblob | NO | | NULL | |
+---------------------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql>


I can confirm that even with these things complete that the wordpress toolkit does not work? Any more suggestions?
 
Guys, could you please shed a light on following questions:

1. When WP was installed? On 11.5 or on 12 version?
2. When upgrade to 12 version was performed? Immediately after WP installation or not?
3. What do you have in wordpressInstances and wordpressInstanceProperties tables?
4. Have you started Scan from admin's interface or only from customer's login?
5. Do you have this error message after first click on WP Toolkit or it worked fine for some time before?
 
For myself this is the first time I have clicked this since upgrade to 12.0.18.

Upgrade from 11.5 -> 12.0.18
Login, click button for Wordpress Toolkit

Get the above mentioned error.

I am unable to run a scan as it never gets that far as to show me the scan button.
 
What about content of wordpressInstances and wordpressInstanceProperties tables?
 
As possible workaround you can try to clear cache for WP instance with following method:

Get list with ID of instances with

# /usr/local/psa/bin/wp_instance --get-list

Then clear cache with

# /usr/local/psa/bin/wp_instance --clear-cache <wp-instance-id>

I hope it will help.
 
Hi Igor

Running the first command I get the following

# /usr/local/psa/bin/wp_instance --get-list
Specified column "url" is not in the row
root@tdns:~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2753771
Server version: 5.5.37-0ubuntu0.12.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from wordpressInstances;
ERROR 1146 (42S02): Table 'psa.wordpressInstances' doesn't exist
mysql> select * from wordpressInstances;
ERROR 1146 (42S02): Table 'psa.wordpressInstances' doesn't exist
mysql> desc WordpressInstanceProperties;
+---------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+------------------+------+-----+---------+-------+
| wordpressInstanceId | int(10) unsigned | NO | PRI | NULL | |
| name | varchar(255) | NO | PRI | NULL | |
| value | mediumblob | NO | | NULL | |
+---------------------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> quit;
Bye
root@tdns:~#


What would be the safe way of creating these tables?

Regards,
 
Sorry, correct name of table is WordpressInstances but not wordpressInstances. Please check it.
Find all ids there and use them for

# /usr/local/psa/bin/wp_instance --clear-cache <wp-instance-id>
 
I ran:
# /usr/local/psa/admin/sbin/autoinstaller --select-product-id plesk --select-release-current --reinstall-patch --install-component base
# /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair

I also tried:
/usr/local/psa/bin/wp_instance --get-list
I received this error:
Specified column "url" is not in the row

I looked up the instance IDs manually and cleared them all one by one with the command:
# /usr/local/psa/bin/wp_instance --clear-cache <wp-instance-id>


Any other suggestions?
 
Once again - What about requested previously content of WordpressInstances and WordpressInstanceProperties tables?
 
You must log in or register to reply here.

Similar threads

S
Issue Specified column is not in the row
Replies
1
Views
240
Peter Debik
P
G
Issue Database Malware or False Positive?
Replies
2
Views
402
Gene Steinberg
G
Lenny
Resolved Seeking Assistance with API Communication Issues via SSL on Plesk
Replies
4
Views
702
Lenny
Lenny
M
Issue Migration feedback - a bunch of comments
Replies
14
Views
6K
M_N
M
S
Resolved ERR_CONNECTION_REFUSED after update
Replies
5
Views
2K
sistemsb
S
Back
Top