View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003090 | OXID eShop (all versions) | 4.07. Source code, Test | public | 2011-07-27 14:04 | 2012-12-10 13:44 |
| Reporter | Helmut L. | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.5.0 revision 34568 | ||||
| Fixed in Version | 4.5.9 revision 43186 | ||||
| Summary | 0003090: fieldExists does not work with fields with lowercase letters | ||||
| Description | If you add a field to a table which contains lowercase letters and check in your code with oxdbmetadatahandler->fieldExists if it exists, you always get false as return value. | ||||
| Steps To Reproduce | Add a field with lowercase letters to a table: alter table oxcategories add test_field varchar(10); Check with PHP if it exists: $handler = oxNew('oxdbmetadatahandler'); $handler->fieldExists('test_field', 'oxcategories'); | ||||
| Additional Information | In the fieldExists method strtoupper is always used on the $sFieldName parameter and thus does no more match with the field name retrieved from the db. You should simply uppercase also the field names retrieved from the db: $aTableFields = array_map('strtoupper', $aTableFields); | ||||
| Tags | No tags attached. | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
