vanillaforums/Garden — Issue #1210: Sql error when deleting category
Author: atlbubba
Created: 2011-11-08 09:13:49+00:00
State: open

2.0.18.1

Deleting category and permanently removing posts.

Throws sql error only when trying to delete the cat and posts for good. If you choose an existing cat to move the posts to the category will be deleted.

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 'c from GDN_Comment c join GDN_Discussion d on c.DiscussionID = d.DiscussionID wh' at line 1|Gdn_Database|Query|delete GDN_Comment c from GDN_Comment c join GDN_Discussion d on c.DiscussionID = d.DiscussionID where d.CategoryID = :dCategoryID