View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0000317OXID eShop (all versions)4.03. 3rd party librariespublic2008-10-21 09:502008-10-26 08:44
Reportersarunas_valaskevicius Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version4.0.0.0 revision 13895 
Summary0000317: no handling for wrong parentid cat while saving
Descriptionwhile inserting category, it tries to load its parent, does not check if loaded, and passes its fields to update statements, forming bad sql. (this happens if setting not existant id as parent for a new categorie)
TagsNo tags attached.
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.33

Activities

sarunas_valaskevicius

2008-10-21 09:51

reporter   ~0000188

example of wrong sql:

UPDATE oxcategories SET OXLEFT = OXLEFT + 2
                            WHERE OXROOTID = ''
                            AND OXLEFT >
                            AND OXRIGHT >= and oxshopid = '1'