Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
You are trying to set your site as the 'production' site and remove the 'development site' notice. You used the site key from the staging site during development and now need to update it, but the 'Plugin installation' screen is disabled because you update plugins via Composer, not the WP administration interface. You are considering changing it directly in the database.
Solution:
First, locate the site key in your database. You can find it in the

wp_options

table under the option name 'icl_sitepress_settings'. Use the following SQL query to locate it:

SELECT * FROM `wp_options` WHERE option_name='icl_sitepress_settings'

In the results, look for 'site_key' within the large string and modify the value, ensuring it is exactly 10 characters long.
Alternatively, you can remove the current key and generate a new one that is not set as a dev site by visiting https://wpml.org/account/sites/. After generating the new key, go to your website's backend > Plugins > Add new > Commercial, and unregister WPML from the current dev key and register it with the new key. If you do not have access to this area, consider using the CSS alternative provided in the forum post here.

If this solution does not apply to your case, or if it seems outdated, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If you still need assistance, please open a new support ticket here.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 2 replies, has 2 voices.

Last updated by alexandreP-37 2 years, 4 months ago.

Assisted by: Mihai Apetrei.

Author Posts
December 5, 2022 at 8:50 am #12589037

alexandreP-37

Tell us what you are trying to do?

I want to set my site as the "production" site and get rid of the "development site" notice.
The problem is that during development i used the sitekey of the staging site, and now i cannot find where I can change it.
I see in the documentation that i can do it on the "Plugin installation" screen, but this is disabled by default in our instance as we only update plugins via composer, not via the WP administration interface.

I'm ok to change it directly in the database if you tell me where exactly it is stored.

Is there any documentation that you are following?
I used this forum entries for posts about the sitekey update

What is the link to your site?
hidden link

December 5, 2022 at 9:40 am #12589525

Mihai Apetrei
WPML Supporter since 03/2018

Languages: English (English )

Timezone: Europe/Bucharest (GMT+03:00)

Hi there.

Please use the steps I recommended here (https://wpml.org/forums/topic/how-to-remove-in-the-footer/#post-10162473) and that will properly make that area disappear for you so that it won't get in your way any longer 🙂

Or you can go here (https://wpml.org/account/sites/) > remove the current key > generate a new key that will not be set as dev site > copy the new key > go to your website's backend > Plugins > Add new > Commercial > unregister WPML from the current dev key and register WPML with the new key (in case you don't have access to that area due to the setup that you mentioned, you can use the CSS alternative of fixing this).

Kind regards,
Mihai Apetrei

December 5, 2022 at 7:00 pm #12594425

alexandreP-37

so: the key is stored in wp_options, as a field: icl_sitepress_settings.

SELECT *
FROM `wp_options` where option_name='icl_sitepress_settings'

the field value is a huge string. look for "site_key" and modified the value, making sure its length is exactly 10 characters.
Done!