[#11771] - [PDO Mysql Strict Mode] Unable to save content if finder plugins enabled.
- Closed
- 27 May 2017
- Medium
- Build: master
- # 11771
Steps to reproduce the issue
This is similar issue as the one solved in #9380, #9455 and #9457.
- Use latest staging
- Set the database driver as "PDO (MySQL)" in global configuration.
- Set "PDO (MySQL)" to strict mode (See note below)
- Make sure finder plugins are enabled
- Go to "Content" -> "Articles" and try to edit and save a content.
- Error. can't save.
Set "PDO (MySQL)" to strict mode
Replace this line: https://github.com/joomla/joomla-cms/blob/staging/libraries/joomla/database/driver/pdomysql.php#L155
With the following code:
$this->connection->query("SET @@SESSION.sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION';");Expected result
Content saved,
Actual result
System information (as much as possible)
Latest staging.
The statement is not executed at all in the Framework.
brianteeman
- | Category | ⇒ | SQL |
The statement is not executed at all in the Framework.
AFAIK that means that in the framework you get the default value for strict mode in which mysql version you're using.
Yep
On Wednesday, August 24, 2016, andrepereiradasilva notifications@github.com
wrote:
The statement is not executed at all in the Framework.
AFAIK that means that in the framework you get the default value for
strict mode in which mysql version you're using.—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#11771 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAWfoVNux5eZEGPjSjKMGQeuZ3J1-gO-ks5qjFKJgaJpZM4Jr6Zg
.
| Status | New | ⇒ | Information Required |
@andrepereiradasilva should this issue stay open?
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/11771.
| Labels |
Added:
?
|
||
| Status | Closed - No Reply | ⇒ | Closed |
| Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
| Status | Information Required | ⇒ | Closed - No Reply |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-05-27 10:24:54 |
| Closed_By | ⇒ | franz-wohlkoenig |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/11771
This has been closed due to lack of response to the requests above – it can always be reopened in the future if it is updated.
@zero-24 @alikon @waader transfered the discussion about the pdo mysql strict mode here.
Maybe a deprecated 4.0 comment?
@mbabker what do you think? The joomla framework still uses the strict mode right?