View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007799 | OXID eShop (all versions) | 2.7. Customer info | public | 2025-06-03 10:44 | 2025-06-18 08:32 |
| Reporter | b.blasius | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | confirmed | Resolution | open | ||
| Product Version | 7.1.0 | ||||
| Summary | 0007799: Media gallery picture upload fails on master/slave setup | ||||
| Description | oxid-esales/media-library-module (all versions) vendor/oxid-esales/media-library-module/src/Media/Repository/MediaRepository.php uses executeQuery instead of executeStatement for insert, update and delete statements. this leads to the following error on master/slave setups. SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement [] [] | ||||
| Steps To Reproduce | QA -SG- addition: 1. have a server with replication database (master + slave) 2. have replication server with read only (e.g. read_only=1 in .cnf file of database) 3. have shop connected to both databases (master per normal config, slave per aSlaveHost) 4. have modul media-library active 5. try to create a folder in the media gallery (Customer Info -> Media Gallery -> New folder) | ||||
| Additional Information | In vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:608: Be aware that Connection::executeQuery is a method specifically for READ operations only. This is especially important in master-slave Connection | ||||
| Tags | No tags attached. | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
