Multilangual site: main language stays unpublished Topic is solved

General questions regarding the use of languages in Joomla! 4.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Fri Aug 18, 2023 9:29 am

And if you press the button at the top of Multilingual Status in the main menu, something like my picture will appear.
And have you tried to select the main menu nl-nl all and then click the rebuild button?
And I also don't know if in the main menu en-nl it matters that the stat page with flag is as submenu.
You do not have the required permissions to view the files attached to this post.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2744
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Multilangual site: main language stays unpublished

Post by ceford » Fri Aug 18, 2023 9:58 am

Do you have Main menu items for each language and no Menu items for All languages?

You are supposed to have a Main menu for each language!

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilingual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 11:01 am

Leen57 wrote:
Fri Aug 18, 2023 9:29 am
And if you press the button at the top of Multilingual Status in the main menu, something like my picture will appear.
And have you tried to select the main menu nl-nl all and then click the rebuild button?
And I also don't know if in the main menu en-nl it matters that the stat page with flag is as submenu.
In the Multilingual status nl-NL is not a 'Published Content Language', all else is ok.
I did a rebuild of all of the main menu's without succes.
About the start page of the respective main menu's: the functioning of the flags of English and German is ok. These main menu's are build exactly the same as the Dutch menu.
Last edited by 1menno on Fri Aug 18, 2023 11:08 am, edited 1 time in total.

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilingual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 11:02 am

ceford wrote:
Fri Aug 18, 2023 9:58 am
Do you have Main menu items for each language and no Menu items for All languages?
You are supposed to have a Main menu for each language!
The main menu's Nederlands, English and Deutsch are set in their languages.
The original Main menu is not set for a language (that is: All).
Last edited by 1menno on Fri Aug 18, 2023 11:08 am, edited 1 time in total.

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilingual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 11:07 am

The difference between the localhost testsite and our problemsite is that the localhost testsite is build on a bare Joomla 4 installation and the problemsite was an upgrade from a bare Joomla 3.10 installation. Could that explain the difference in function?

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2744
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Multilangual site: main language stays unpublished

Post by ceford » Fri Aug 18, 2023 11:19 am

Check whether you have a Main menu item (set for All languages) pointing to the same article as a Main (nl) menu item. If so, unpublish the former. And unpublish the original Main menu module.

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilangual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 11:33 am

ceford wrote:
Fri Aug 18, 2023 11:19 am
Check whether you have a Main menu item (set for All languages) pointing to the same article as a Main (nl) menu item. If so, unpublish the former. And unpublish the original Main menu module.
The original Joomla Main menu is set to all languages and is pointing to a separate Dutch page (in case the site is out of order I publish this page). I just published this Main menu on position 7: that position is not visible on the site. But: no change compared to this Main menu unpublished.

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Fri Aug 18, 2023 11:47 am

maybe a strange question, but you do have a Dutch menu module in the right position?
You do not have the required permissions to view the files attached to this post.

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilangual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 11:52 am

Leen57 wrote:
Fri Aug 18, 2023 11:47 am
maybe a strange question, but you do have a Dutch menu module in the right position?
The Dutch menu is in the same position as in the English and German menu's: 'menu' position in Cassiopeia.

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Fri Aug 18, 2023 12:36 pm

what I also find strange is when I click on language flag, for example German, then German comes but the flag disappears
this also applies to flag english when I click on it comes english language but flag disappears.
at my site that is not so wonder if you are at
Modules: Language Switcher tab Menu Assignment
show on all pages?
You do not have the required permissions to view the files attached to this post.

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilangual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 12:42 pm

Leen57 wrote:
Fri Aug 18, 2023 12:36 pm
what I also find strange is when I click on language flag, for example German, then German comes but the flag disappears
this also applies to flag english when I click on it comes english language but flag disappears.
at my site that is not so wonder if you are at
Modules: Language Switcher tab Menu Assignment
show on all pages?
That flag behaviour is normal behaviour on my test site.
(In Joomla 3.x you could see all flags)
Language switcher is already assigned to 'On all pages'.

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Fri Aug 18, 2023 1:07 pm

you can look in the administrator section Extensions: Manage
there search by language and compare with my found files ?
And maybe you can delete the Dutch language first and install it again?
You do not have the required permissions to view the files attached to this post.

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilangual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 1:58 pm

Leen57 wrote:
Fri Aug 18, 2023 1:07 pm
you can look in the administrator section Extensions: Manage
there search by language and compare with my found files ?
And maybe you can delete the Dutch language first and install it again?
Maybe you have a point here.

In my System->Manage->Extensions: language there there is no Dutch package to find. English and German are there.
But in Content languages it is impossible to delete the Dutch language (it is there, but empty in the details tab. I can fill in the details but is not accepted by save: language already installed), and I can't install a new Dutch one (messages: 'no language selected' (which I did of course) or 'language already installed'.

So there is a discrepancy between the installed extensions and the content languages.

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Fri Aug 18, 2023 2:31 pm

Can you install this language pack?
https://joomlacommunity.nl/downloads/jo ... omla-4-3-3
If that doesn't help either, there's an error in the database

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilingual site: main language stays unpublished

Post by 1menno » Fri Aug 18, 2023 2:56 pm

Leen57 wrote:
Fri Aug 18, 2023 2:31 pm
Can you install this language pack?
https://joomlacommunity.nl/downloads/jo ... omla-4-3-3
If that doesn't help either, there's an error in the database
I installed the pack.
Nothing changes.

I had a look in the database concerning languages: all seems ok (see a former post on this thread).

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Fri Aug 18, 2023 4:23 pm

Have you checked whether it will be Extensions: Manage and also enabled
Otherwise you can look with phpmyadmin at extension
and there check all show and let search on dutch
can you see if it is enabled.
if not you can click them one by one and click on change
and then set enabled to 1 and save
You do not have the required permissions to view the files attached to this post.

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilangual site: main language stays unpublished

Post by 1menno » Sat Aug 19, 2023 8:20 am

Leen57 wrote:
Fri Aug 18, 2023 4:23 pm
Have you checked whether it will be Extensions: Manage and also enabled
Otherwise you can look with phpmyadmin at extension
and there check all show and let search on dutch
can you see if it is enabled.
if not you can click them one by one and click on change
and then set enabled to 1 and save
The multilingual status:
Image

The manage->languages:
Image

The manage->content languages. Note 1: can't change the status of Dutch, and can't trash. Note 2: the Details tab of the Dutch languages is empty. Can fill, but not save (Save failed with the following error: A content language already exists with this Language Tag):
Image

I checked the database table (extensions->dutch) and the first three rows are exactly the same as you showed, including enabled. The database has no other rows for 'dutch'.
Image

Maybe I should set them to 0 (zero) in the database and then try to install the Dutch language in Joomla again?
Last edited by 1menno on Sat Aug 19, 2023 9:20 am, edited 4 times in total.

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Sat Aug 19, 2023 9:13 am

Hello I did a test on my local language testing site.
there I have those the 3 Dutch language files in phpmyadmin
selected and deleted. then the site only works in German and English language with flags (Dutch flag was immediately gone)
then installed the nl-NL_joomla_lang_full_4.3.3v1 language package again and here the website works again as usual with Dutch language with flag
so you could try that.
PS
are all your extension_id number that high ? or could it be that those dutch high numbers have been left behind now upgrade from joomla 3 to 4 ?

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilangual site: main language stays unpublished

Post by 1menno » Sat Aug 19, 2023 9:48 am

Leen57 wrote:
Sat Aug 19, 2023 9:13 am
Hello I did a test on my local language testing site.
there I have those the 3 Dutch language files in phpmyadmin
selected and deleted. then the site only works in German and English language with flags (Dutch flag was immediately gone)
then installed the nl-NL_joomla_lang_full_4.3.3v1 language package again and here the website works again as usual with Dutch language with flag
so you could try that.
PS
are all your extension_id number that high ? or could it be that those dutch high numbers have been left behind now upgrade from joomla 3 to 4 ?
So I deleted in the database table all three dutch rows. Installed in Joomla dutch language again. And ... no progression. Same screens as in my screenshots today.

The first extensions with id number 100xx were the dutch files, which were the first I installed in Joomla 4

1menno
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sat Feb 12, 2011 8:29 pm

Re: Multilangual site: main language stays unpublished

Post by 1menno » Sat Aug 19, 2023 12:11 pm

Thanks to Leen57 there is the solution:
- in de database I changed in extensions->dutch: the id from 0 to 3
- in Joomla manage->content languages: now I could change the status of the Dutch language to: publish.

Now the site is working as it should be.

Thank you all for your support, it saved me a lot of time!

Leen57
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 121
Joined: Thu Mar 20, 2014 1:29 pm

Re: Multilangual site: main language stays unpublished

Post by Leen57 » Sat Aug 19, 2023 12:41 pm

just to be clear it was at 'jouprefix_languages`
and change from NL dutch de > lang_id from 0 to 3


Post Reply

Return to “Language - Joomla! 4.x”