?
avatar infograf768
infograf768
10 Jun 2017

Install a new 4.0 joomla and choose multilingual.
#16609 is first merged.

  1. When installing languages we get
    The most recent request was denied because it contained an invalid security token. Please refresh the page and try again.
    Clicking OK in the Alert and Next again does work and languages are installed.

  2. Impossible to go further when choosing Activate the multilingual feature
    Going back and trying again. Nope.
    Choosing no Multilngual install gives the default site and admin set and
    Warning

Joomla was unable to automatically create the French (FR) menu.
Joomla was unable to automatically create the English (en-GB) menu.

The Main menus ARE created.
The langswitcher modules are created but NOT tagged to the languages
The menu items are NOT created.
The language filter plugin is enabled.
The Content Languages are created.
The articles and categories are NOT created
If I try to display the articles manager I get a 500
'340.a.modified' isn't in GROUP BY '340.a.modified' isn't in GROUP BY

avatar infograf768 infograf768 - open - 10 Jun 2017
avatar joomla-cms-bot joomla-cms-bot - change - 10 Jun 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 10 Jun 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 10 Jun 2017
Status New Confirmed
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 10 Jun 2017

Issue confirmed.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/16610.

avatar franz-wohlkoenig franz-wohlkoenig - change - 10 Jun 2017
Category Installation Multilanguage
avatar andrepereiradasilva
andrepereiradasilva - comment - 10 Jun 2017

If I try to display the articles manager I get a 500
'340.a.modified' isn't in GROUP BY '340.a.modified' isn't in GROUP BY

the sql in 4.0 needs a full group by clause by forcing the ONLY_FULL_GROUP_BY sql mode in mysql (the other db already force it in default).

Any sql queries across the core that does not uses full group by queries will give that error.
See #12494 for more info

side note: this SQL ONLY_FULL_GROUP_BY change (among the other sql modes forced in 4.0) should be in the 4.0 B/C breaks doc page.

avatar infograf768
infograf768 - comment - 10 Jun 2017

nice, and then what? ?

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 11 Jun 2017

installed latest staging with same Result as @infograf768 described.

avatar infograf768
infograf768 - comment - 11 Jun 2017

@andrepereiradasilva
adding a.modified there solves that specific issue.
For the rest, all is still broken

avatar andrepereiradasilva
andrepereiradasilva - comment - 11 Jun 2017

Yes, there are several diferent issues. I just comment about one.

Btw probably that issue exists in PostgreSQL and sql server too on 3.7.3, becauses the PR that causes that was merged for 3.7.3. see #15825

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 5 Aug 2017

Would be nice to test 4.0 multilangugage.

avatar franz-wohlkoenig franz-wohlkoenig - change - 7 Nov 2017
Status Confirmed Discussion
avatar C-Lodder
C-Lodder - comment - 6 Dec 2017

@infograf768 is this still an issue with the new installer?

avatar infograf768
infograf768 - comment - 6 Dec 2017

The new installer does not propose the choice between installed lang for sites and admin, and neither the choice to install a multilang sample data.
Therefore this issue is not present now. Closing.

avatar infograf768 infograf768 - change - 6 Dec 2017
Status Discussion Closed
Closed_Date 0000-00-00 00:00:00 2017-12-06 17:10:33
Closed_By infograf768
avatar infograf768 infograf768 - close - 6 Dec 2017

Add a Comment

Login with GitHub to post a comment