Can't find or install languages (with PDO driver in MySQL 5.6.6+)

[andrepereiradasilva]

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:

System information (as much as possible)

Latest staging / RC 4.

[zero-24]

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.

[jppcel]

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.}

[wilsonge]

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

[andrepereiradasilva]

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.

[andrepereiradasilva]

PR is #11763 BTW 😄