This is similar issue as the one solved in #9380 and to the issue described in #9455.
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.
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';");
Languages found / Language installed.
Latest staging / RC 4.
Category | ⇒ | SQL |
Labels |
Added:
?
|
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...
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
Status | New | ⇒ | Confirmed |
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.
Status | Confirmed | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-08-23 16:20:32 |
Closed_By | ⇒ | andrepereiradasilva |
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.