Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#9455] - Can't create a Banner (with PDO driver in MySQL 5.6.6+)

?
avatar andrepereiradasilva
andrepereiradasilva
17 Mar 2016

Steps to reproduce the issue

This is similar issue as the one solved in #9380.

  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. Create or edit a banner.
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#L149 the following code:

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

Expected result

Banner saved.

Actual result

Doesn't work:
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 wilsonge
wilsonge - comment - 17 Mar 2016

PR in #9461

avatar wilsonge wilsonge - change - 17 Mar 2016
Status New ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2016-03-17 21:19:49
Closed_By ⇒ wilsonge
avatar wilsonge wilsonge - close - 17 Mar 2016

Add a Comment

Login with GitHub to post a comment