View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006187 | OXID eShop (all versions) | 4.01. Database handling | public | 2015-07-13 11:55 | 2022-02-01 13:50 |
| Reporter | GhostGambler | Assigned To | |||
| Priority | low | Severity | feature | Reproducibility | N/A |
| Status | confirmed | Resolution | open | ||
| Product Version | 4.9.4 / 5.2.4 | ||||
| Summary | 0006187: sql mode allows dropping data without noticing it | ||||
| Description | The 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. | ||||
| Tags | No tags attached. | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | All | ||||
| Database Version | All | ||||
