Bug #3868
Saving a category in root tree throws a SQL error
| Status: | Resolved | Start date: | 2009-07-10 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assignee: | Christian Kuhn | % Done: | 0% |
|
| Category: | Bug | Spent time: | - | |
| Target version: | - | |||
| Votes: | 0 |
Description
Current trunk rev. 22243
This seems to be related to fixes of #3729 and #3629 .
Debug output:
t3lib_DB::exec_DELETEquery
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 3
DELETE FROM tx_commerce_categories_parent_category_mm
WHERE
uid_local=9 AND NOT ((uid_foreign=))
SC_alt_doc->processData#1459 // t3lib_TCEmain->process_datamap#314 // t3lib_TCEmain->hook_processDatamap_afterDatabaseOperations#908 // tx_commerce_dmhooks->processDatamap_afterDatabaseOperations#553 // tx_commerce_belib->saveRelations#1061 // t3lib_DB->exec_DELETEquery#801 // t3lib_DB->debug#214
Associated revisions
Fixed bug #3868: Saving category in root tree throws SQL error
Fixed bug #3868: Saving category in root tree throws SQL error
History
Updated by Christoph Niewerth almost 4 years ago
- File commerce_3868_1.diff added
Attached to fix this bug.
Added checks to secure correct building of DELETE SQL query
Replaced is_array by count. $delWhere is initialized as array at function start.
Added check if $relation[uid_foreign] is set to secure SQL query build.
Updated by Christian Kuhn almost 4 years ago
- Status changed from New to Resolved
- Assignee set to Christian Kuhn
Committed to trunk rev. #22437
Thanks Christoph!