View Issue Details

IDProjectCategoryView StatusLast Update
0005581OXID eShop (all versions)4.01. Database handlingpublic2015-05-04 14:40
Reportermpienkny 
PriorityurgentSeveritycriticalReproducibilityalways
Status resolvedResolutionduplicate 
Product Version 
Target VersionFixed in Version 
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
ThemeBoth
BrowserAll
PHP Versionany
MySQL Versionany

Relationships

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. 

Activities

svetlana

2013-12-18 16:38

reporter   ~0009365

This bug was fixed with other changes with related bug 0005582