?
avatar adambako
adambako
20 Jul 2016

Steps to reproduce the issue

i install demo package from yootheme.. its joomla 3.6.0.
if i go to Extensions: Install Languages there are no languages.
i download joomla 3.6.0 full package from joomla.org and over-install it through backend.
still cant install any language
i try discover
i try fix database
i clear all caches

Expected result

there should be a list of all languages

Actual result

list is empty

System information (as much as possible)

in attachment

Additional comments

Votes

# of Users Experiencing Issue
0/1
Average Importance Score
3.00

avatar adambako adambako - open - 20 Jul 2016
avatar adambako adambako - change - 20 Jul 2016
The description was changed
avatar infograf768
infograf768 - comment - 20 Jul 2016

Do you get an error message?

The servers were out this morning early (europe time). They work fine now.

avatar adambako
adambako - comment - 20 Jul 2016

hi,
no errors.. even if i enable developer mode for reporting.. its just missing list of languagesscreen shot 2016-07-20 at 05 00 44systeminfo-2016-07-20T11-52-46+02-00.txt


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

avatar infograf768
infograf768 - comment - 20 Jul 2016

Please post a screenshot of the Update Sites page.

avatar adambako
adambako - comment - 20 Jul 2016

second shot is after hit "rebuild".. languages still dont show.

screen shot 2016-07-20 at 05 07 06!

screen shot 2016-07-20 at 05 07 06


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

avatar adambako
adambako - comment - 20 Jul 2016

if it helps i can send you somewhere logins.. ?


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

avatar infograf768
infograf768 - comment - 20 Jul 2016

The database is missing stuff... I am not astonished as you are using a demo...

It should contain at least this:

screen shot 2016-07-20 at 12 27 21

avatar ggppdk
ggppdk - comment - 20 Jul 2016

This is the 3rd or 4th time i see this question coming up ?

  • Language are not listed because package "English (United Kingdom)'" was not created

Missing languages, is 1 of the problems of joomla installations have

  • if upgraded by extracting J3.6.0 package files into the folder, ("non-supported upgrade method")

Clicking Extensions/Installer/Database/Fix
will only run the database schema-changing queries our of:
administrator\components\com_admin\sql\updates\

  • that means that only "ALTER" queries are executed

you will need to run manually the queries of:
administrator/components/com_admin/sql/updates/3.6.0.*.sql

  1. Do not try to run the queries that create the installer plugins, if you have already clicked "discover" and install in plugin manager
  2. Do not try to run the ALTER queries if you already clicked "Fix" Database

To create the needed package run file: 3.6.0-2016-04-08.sql in phpmyadmin (replace # __ with you DB prefix)

-- Insert the missing en-GB package extension.
INSERT INTO `#__extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`)
 VALUES (802, 'English (United Kingdom)', 'package', 'pkg_en-GB', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);

-- Change update site extension id to the new extension.
UPDATE `#__update_sites_extensions`
SET `extension_id` = 802
WHERE `update_site_id` IN (
            SELECT `update_site_id`
            FROM `#__update_sites`
            WHERE `name` = 'Accredited Joomla! Translations'
            AND `type` = 'collection'
            )
AND `extension_id` = 600;

You may notify yootheme about this, to fix their packages

avatar ggppdk
ggppdk - comment - 20 Jul 2016

@mbabker
i am not expert on joomla upgrade, is the following possible

How much effort would it be to detect upgrade via file extraction ?

  • compare DB version to version returned by ? JVersion ?

and immediately ask backend user to run the sql queries by clicking a button or something ?
or at least some backend warning ?
or something else ?

Also 1 more FAQ article for none in "Install Languages" ? like
https://docs.joomla.org/J3.x:Missing_Installer_Tabs

avatar andrepereiradasilva
andrepereiradasilva - comment - 20 Jul 2016

Again, manual updade method is only a valid updade method if you run @mbabker post updade script immediatly after (See https://gist.github.com/mbabker/d7bfb4e1e2fbc6b7815a733607f89281).

Among other things, a manual update does not runs the querys in sql folder (see https://github.com/joomla/joomla-cms/tree/staging/administrator/components/com_admin/sql/updates/mysql)

Yes, you can add the database schema changes with the Database -> Fix later, but the Database -> Fix will not run, for instance, the UPDATE/INSERT sql syntax and so you will have issues like this.

avatar adambako
adambako - comment - 20 Jul 2016

ok.. so the issue comes from joomla demo package from yootheme? they use wrong method to upgrade to j3.6.0.?


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

avatar ggppdk
ggppdk - comment - 20 Jul 2016

@adambako
Most probably yes,

If you have not run the queries yet, you can check it like this:

  • if "English" Language package is missing then "Install languages" will not listed any language

package_en

avatar adambako
adambako - comment - 20 Jul 2016

ok.. thanks you guys.
@ggppdk your query fix my issue.


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

avatar brianteeman brianteeman - change - 20 Jul 2016
Status New Closed
Closed_Date 0000-00-00 00:00:00 2016-07-20 11:43:11
Closed_By brianteeman
avatar brianteeman brianteeman - close - 20 Jul 2016
avatar brianteeman
brianteeman - comment - 20 Jul 2016

Closed as not an issue in the Joomla core


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

avatar b2z b2z - change - 20 Jul 2016
Category Language & Strings Language & Strings UI/UX
avatar b2z b2z - change - 20 Jul 2016
Category Language & Strings UI/UX Language & Strings
avatar elkuku elkuku - change - 20 Jul 2016
Category Language & Strings CLI Language & Strings
avatar elkuku elkuku - change - 20 Jul 2016
Category Language & Strings CLI Language & Strings
avatar sitte
sitte - comment - 7 Feb 2018

I manually added records to database but no result (there was update server but installation wasn't successful). Solution was to find and install language package from repository: https://community.joomla.org/translations/joomla-3-translations.html

Add a Comment

Login with GitHub to post a comment