Unable to update WordPress installation via Application Vault

Created:

2016-11-16 13:08:38 UTC

Modified:

2017-04-24 11:56:30 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to update WordPress installation via Application Vault

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux

Symptoms

When trying to upgrade WordPress installation for particular domain on Websites & Domains page, following error is shown:

Internal error: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound

Message SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
File Pdo.php
Line 234
Type Zend_Db_Statement_Exception

Cause

Missing record for WordPress 3.8.3 in 'psa.smb_apsPackages' table:

mysql> select id,name,version,release,registryUid from smb_apsPackages;
+----+-----------+---------+---------+--------------------------------------+
| id | name | version | release | registryUid |
+----+-----------+---------+---------+--------------------------------------+
| 8 | WordPress | 3.8.2 | 30 | c1112ac1-660b-4ad3-90ca-b6b334b01000 |
| 13 | WordPress | 3.9.1 | 37 | 7d95247b-094b-4a8e-998b-05bf3b5c5466 |
+----+-----------+---------+---------+--------------------------------------+

mysql> select id,registry_object_id,name,version from apsc.aps_package;
+----+--------------------+-----------+---------+
| id | registry_object_id | name | version |
+----+--------------------+-----------+---------+
| 8 | 26 | WordPress | 3.8.2 |
| 9 | 27 | WordPress | 3.8.3 |
| 13 | 31 | WordPress | 3.9.1 |
+----+--------------------+-----------+---------+

Resolution

Take ' registryUid ' from table ' aps_registry_object ':

select id,uid,type from apsc.aps_registry_object where id='27';

+----+--------------------------------------+-----------------+
| id | uid | type |
+----+--------------------------------------+-----------------+
| 27 | 419ed245-de42-4726-842d-e2bf14103361 | aps.package |
+----+--------------------------------------+-----------------+

Insert record manually:

insert into smb_apsPackages values(9,"WordPress","3.8.3","31","WordPress.org","http://wordpress.org/","Glowtouch Technologies","http://www.glowtouch.com/","",NULL,0,0,"419ed245-de42-4726-842d-e2bf14103361",0,0);
Have more questions? Submit a request
Please sign in to leave a comment.