Skip Navigation

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 11 replies, has 2 voices.

Last updated by Andreas W. 1 year, 7 months ago.

Assisted by: Andreas W..

Author Posts
September 12, 2023 at 6:06 am #14380291

janH-80

Hi

I switched a multisite to life. Every site within the multisite network runs under it's own domain. I am confused on how to change WPML from "development" to "production" for several different domains within the same multisite network.

Thank you.
Jan

September 12, 2023 at 6:20 am #14380313

janH-80

I get this message when trying to update to "productive"

Screen Shot 2023-09-12 at 07.17.49.png
September 13, 2023 at 2:04 am #14386665

Andreas W.
WPML Supporter since 12/2018

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

On a WordPress Multisite, each site in the network has its own database, which means that WPML is an independent install with proper language setup and translated content on each side of your network.

This means, that you will not be able to run for example one language on each site of the network and connect them with each other if this is what you were expecting to do.

Guide:
https://wpml.org/documentation/support/multisite-support/

About your screenshot:

If you push to live and the site URL will change, then you need to register a new site URL on wpml.org.

Each site URL needs to be registered and has its unique WPML site key.

Guide:
https://wpml.org/faq/install-wpml/

This means, that actually pushing between development and live site would usually only make sense, if you keep using the same site URL.

Let me know if you do have any further questions.

Best regards
Andreas

September 13, 2023 at 8:32 am #14388061

janH-80

Hello Andreas

Thank you for getting back. It is not true that each subsite has it's onw database in a wordpress multisite install. A WP multisite is one instance of WordPress and therefore running in one DB. You can read about ut here: hidden link and here: hidden link

Therefore there is one single WPML install which can be activated on the different sites within the multiste. Now my issue is that each site in my multisite network has it's onw domain (not sub-domain, it's onw different domain: lofthotel.ch, sagibeiz.ch, azibene.ch). So I suppose I have to register the URL of the main site to switch to productive. This main site URL has not changed and still is: multisitech.kinsta.cloud. But that's where I get the error. which I sent in the screenshot.

Kind regards,
Jan

September 13, 2023 at 12:25 pm #14390173

Andreas W.
WPML Supporter since 12/2018

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello Jam

My apologies for the inconvenience but I am a WordPress Developer with more than five years of experience in WPML support and I have to say to let you know, that what you are saying is not correct.

From your linked documentation:

While, for example, when a new site is created, the site-specific tables, similar to the single site install, are created. Each set of tables for a site is created with the site ID (blog_id) as part of the table name. These are the tables that would be created for site with ID 2 :

wp_2_commentmeta
wp_2_comments
wp_2_links
wp_2_options
wp_2_postmeta
wp_2_posts
wp_2_terms
wp_2_termmeta
wp_2_term_relationships
wp_2_term_taxonomy

This means there are various databases, each with a suffix for the site ID.

Those are different databases and they are independent from each other.

WPML can only manage each sub-site individually and will not be able to build language connections between those sub-sites.

For more details about how to use WPML on a Multisite please read this:
https://wpml.org/documentation/support/multisite-support/

Best regards
Andreas

September 14, 2023 at 10:29 am #14395809

janH-80

Hello Andreas, I did not mean to attack you personally. Mabe there is a misunderstanding.

In my understanding, what you are referring to is tables, not databases. I attached a screenshot of our multisite database where you see the database "multisitech" ("Datenbank" - my panel is in german). You also see on the left - as an example - the options tables of each site within the multisite which contain the site ID within the table name. These tables are all contained in the same single database "multisitech".

Also from my linked documentation: "The sites with the WordPress multisite network can have their own domain or URL and are recognized by search engines as separate, fully-fledged websites. They share the same database, but every site has its own subset of database tables."

The last sentence is what I mean when I say that it is not true that each subsite has it's own database. As stated there and - in my opinion - shown in the screenshot, they share the same DB.

Could you please elaborate what you mean by multible databases?

Thank you
Kind regards,
Jan

Screenshot at Sep 14 11-20-58.png
September 14, 2023 at 11:54 am #14396625

Andreas W.
WPML Supporter since 12/2018

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello Jan,

My apologies, no offense taken and I hope my reply was not too harsh. In fact, you are technically right there - this is one database.

Only due to the fact that we have separate tables for each subsite, they actually behave in terms of WordPress like individual databases for each site and we can not connect them to each other.

Each subsite even has its proper WordPress tables, which means the WordPress Options on each substite can be different.

WPML is installed on each subsite and uses only the tables of each subsite respectively.

This means you will be able to have different WordPress and WPML options, different language settings, even different language URL formats, and different translations for each subsite.

An example:
You could actually have original content on wp_posts that does not exist on wp_2_ posts.

In this case, WPML will not be able to connect a translation from wp_posts to wp_2_posts as the original content does not exist on wp_2_posts.

I hope this makes sense.

Best regards
Andreas

September 14, 2023 at 6:26 pm #14399295

janH-80

Hi Andreas,

I'm glad we're on the same page. Now I still have the issue which I tried to describe at the start. I can register WPML only on the main site of the multisite. I cannot register it on each subsite. This is described here: https://wpml.org/documentation/support/multisite-support/#:~:text=Registering%20WPML%20on%20a%20Multisite%20Setup,-Registering%20your%20main&text=Activate%20the%20OTGS%20Installer%20plugin,WPML%20Installer%20and%20register%20WPML.&text=After%20registering%2C%20you%20can%20download%20WPML%20Multilingual%20CMS%20to%20your%20network.

That means I need to be able to register my main site as "live". URL: hidden link. But there I get the error message which I sent in the first message. Or do I understand something wrong here?

Thanks!
Kind regards
Jan

September 14, 2023 at 10:33 pm #14399761

Andreas W.
WPML Supporter since 12/2018

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

About the screenshot of your first message:

According to the dialog you need to confirm that you are pushing the same site URL from development to production.

Guide:
https://wpml.org/documentation/translating-your-contents/advanced-translation-editor/using-advanced-translation-editor-when-you-move-or-use-a-copy-of-your-site/

This on your screenshot is not an error message, as it is only a dialog that asks you for confirmation so that WPML can remove the development site banner from the site.

You do not need to change the site key when switching from development to production or vice versa.

Also, this means that the site URL will not change, as you will remain using the same site URL for this multisite.

For the registration:

Indeed, you register WPML network-wide, so there is one site key for the whole multisite, and updates for WPML run network-wide to.

WPML itself then will get configured on each subsite individually.

https://wpml.org/documentation/support/multisite-support/#configuring-wpml-on-subsites

Best regards
Andreas

September 15, 2023 at 7:30 am #14400951

janH-80

And how do I confirm it? This mesage comes after I press the "publish" button. When I press it again, nothing happens...

September 15, 2023 at 7:35 am #14400981

janH-80

Actually I now managed to get it publsihed. The problem was that I used https instead of http in the URL...could have been easy. Thank you Andreas.

September 15, 2023 at 3:10 pm #14404131

Andreas W.
WPML Supporter since 12/2018

Languages: English (English ) Spanish (Español ) German (Deutsch )

Timezone: America/Lima (GMT-05:00)

Hello,

Indeed, so sorry - I did not realize that.

Yes, the site was running on http:// and is registered on wpml.org like this:

hidden link

If any further assistance is needed or you have any questions please let me know.

Best regards
Andreas