Prefix specified for tables is not used for creating tables in wordpress database

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 12:57:48 UTC

Modified:

2016-12-21 19:38:39 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Prefix specified for tables is not used for creating tables in wordpress database

Symptoms

'Prefix of tables' value/entry is not used for creating tables in Wordpress database. Random value is taken in wp-cofig.php as well as in tables of database.

Cause

Bug #PPPM-2056 . It is fixed in Plesk Onyx.

Resolution

Upgrade to the latest Plesk version .

If upgrade is not possible:

Plesk generates random prefix only if 'Wordpress Toolkit' is enabled (it depends on license key or setings in panel.ini ):

Linux:

#cat /usr/local/psa/admin/conf/panel.ini
..
[wpToolkit]
enabled=off
...

Windows: %plesk_dir%\\admin\\conf\\panel.ini

The possible workaround is to disable Wordpress Toolkit.In this case table name will be 'myprefix' + 'wp_' + 'tablename'. For example:

mysql> show tables
myprefixwp_comments

This is because configuration script in the Wordpress package has the following line:

$db_modify_hash['@@DB_MAIN_PREFIX@@'].='wp_'; // Means that db prefix will be "myprefixwp_".

There should not be any technical problems to remove adding 'wp_' from Wordpress configuration script.

Have more questions? Submit a request
Please sign in to leave a comment.