Can't create a Banner (with PDO driver in MySQL 5.6.6+)

[andrepereiradasilva]

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:

System information (as much as possible)

Latest staging / RC 4.

[wilsonge]

PR in #9461