View Issue Details

IDProjectCategoryView StatusLast Update
0006187OXID eShop (all versions)4.01. Database handlingpublic2015-12-01 12:16
Status acknowledgedResolutionopen 
Product Version4.9.4 / 5.2.4 
Target VersionFixed in Version 
Summary0006187: sql mode allows dropping data without noticing it
DescriptionThe sql_mode is set to nothing, which allows to send invalid data to mysql without getting any notice of it. This is especially critical, when the data is too long for the given column and the column is the session field to store sessions in the database... in this case the session is reseted to an empty session without any possibility to track this issue down easily.

The sql_mode should at least be set to "STRICT_TRANS_TABLES" or even better "STRICT_ALL_TABLES", although this requires some cleanup of the some sql statements.
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionAll
Database VersionAll


There are no notes attached to this issue.