?
avatar andrepereiradasilva
andrepereiradasilva
17 Mar 2016

Steps to reproduce the issue

This is similar issue as the one solved in #9380 and to the issue described in #9455.

Find languages

  1. Use latest staging or RC4 with a MySql server 5.6.6+
  2. Set the database driver as "PDO (MySQL)" in global configuration.
  3. Go to "Extensions" -> "Install languages".
  4. Click "Find Languages".

Install language
1. Use latest staging or RC4 with a MySql server 5.6.6+
2. Set the database driver as "PDO (MySQL)" in global configuration.
3. Go to "Extensions" -> "Install languages".
4. Select a language and install it.

Note

If you don't have MySql 5.6.6+ you can emulate the error by setting the sql_mode in pdomydriver file. For that, add, after this line https://github.com/joomla/joomla-cms/blob/staging/libraries/joomla/database/driver/pdomysql.php#L155 the following code:

$this->connection->query("SET @@SESSION.sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION';");

Expected result

Languages found / Language installed.

Actual result

Doesn't work:
image

image

System information (as much as possible)

Latest staging / RC 4.

avatar andrepereiradasilva andrepereiradasilva - open - 17 Mar 2016
avatar brianteeman brianteeman - change - 17 Mar 2016
Category SQL
avatar brianteeman brianteeman - change - 17 Mar 2016
Labels Added: ?
avatar zero-24
zero-24 - comment - 17 Mar 2016

I guess we need to add that field here with default values:
https://github.com/joomla/joomla-cms/blob/staging/libraries/cms/installer/adapter/language.php#L286

I guess we need similiar fixes to the other install adapters.

avatar jppcel
jppcel - comment - 18 Mar 2016

I guess the problem is with the table '_updates'.

I have modified the date atribute on database to can receive null values and the problem about the list of languages is solved, but i think the problem must be solved of other form...


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

avatar wilsonge
wilsonge - comment - 20 Mar 2016

Temporary fix has been to force strict mode off (to match mysql and mysqli drivers). But I want this issue to remain open so we can implement the "correct" fix one day

avatar brianteeman brianteeman - change - 10 May 2016
Status New Confirmed
avatar andrepereiradasilva
andrepereiradasilva - comment - 23 Aug 2016

ok i made a PR for this install languages problems so i will close this.
Any other problems with "PDO (MySQL)" in strict mode shoudl have an issue.

avatar andrepereiradasilva andrepereiradasilva - change - 23 Aug 2016
Status Confirmed Closed
Closed_Date 0000-00-00 00:00:00 2016-08-23 16:20:32
Closed_By andrepereiradasilva
avatar andrepereiradasilva andrepereiradasilva - close - 23 Aug 2016
avatar andrepereiradasilva andrepereiradasilva - edited - 23 Aug 2016
avatar andrepereiradasilva
andrepereiradasilva - comment - 23 Aug 2016

PR is #11763 BTW ?

avatar andrepereiradasilva andrepereiradasilva - change - 24 Aug 2016
The description was changed
avatar andrepereiradasilva andrepereiradasilva - edited - 24 Aug 2016

Add a Comment

Login with GitHub to post a comment