By Bethany Amborn on Saturday, 02 July 2016
Posted in Technical Issues
Replies 1
Likes 0
Views 610
Votes 0
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 ()
Hey Beth,

I am sorry for the delay of this reply,

I've tried to reorder the `Uncategorized` category to up and down and save the order, it seems work fine without hitting that error you mentioned at above.

You can take a look of my video here : http://screencast.com/t/Oh3t1Qo43

Can you give it a check my video is it I reproduce the step wrongly? Please advise.
·
Monday, 04 July 2016 14:17
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post