View Issue Details

IDProjectCategoryView StatusLast Update
0005581OXID eShop (all versions)4.01. Database handlingpublic2015-05-04 14:40
Reportermpienkny Assigned To 
Status resolvedResolutionduplicate 
Summary0005581: Failure in database query should be reported, not just ignored
DescriptionIf any SQL statement fails (e.g. different collations on columns) this must be examined, and not just go on with empty record set.
Steps To ReproduceThis is just an _example_ - this topic is anywhere accessing the database

Database is MySQL 5.5 - collation of database is utf8_general_ci
Column oxarticles.oxefichecksum has collation latin1_general_ci

When eFire search for new products in where-clause is something like "oxefichecksum != MD5(...." - this crashes silently and so no new or updated products are sent to eFire anymore.
TagsCollation, Database
PHP Versionany
Database Versionany


related to 0005582 resolvedmantas.vaitkunas There is no check for errors in database queries when production mode turned on. This leads to unpredictable Shop state. 



2013-12-18 16:38

reporter   ~0009365

This bug was fixed with other changes with related bug 0005582