I'm getting this error on my categories. I moved all the discussions from one category to another deleted the empty one, and the order got all screwed up. Now i get this when i try to reorder.
1064 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 1 SQL=update `#__discuss_category` set lft = lft + '2', rgt = rgt + '2' where `id` in ()