View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006321OXID eShop (all versions)4.12. Subshop handlingpublic2016-02-01 09:462016-02-01 10:43
Reporter[email protected] Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionunable to reproduce 
Product Version4.7.9 / 5.0.9 
Summary0006321: Fields in oxarticles and oxfield2shop are inconsistent.
DescriptionThis problem exists probably also in newer versions. The field OXSTOCK in the table oxarticles is defined als DOUBLE. The same field in the table oxfield2shop is defined as INT(11).
Insert statement into oxfield2shop fails when oxstock has a higher value than INT(11).

Throws following error:
Data truncation: Out of range value for column 'OXSTOCK' at row 1

Both database fields should be of same type and size.


Steps To Reproduce1. Insert value 999999999971 into oxstock in oxarticles
2. Try to insert into oxfield2shop with select from oxarticles
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionAll
Database VersionAll

Activities

QA

2016-02-01 10:43

administrator   ~0011447

The field OXSTOCK in the table oxarticles is defined als DOUBLE. RIGHT
The same field in the table oxfield2shop is defined as INT(11). NOT EXISTENT

Thus the inconsistency is made by addind the field manually.
This field still not exist in a standard installation.