Categories Order
By Matt on Monday, 09 May 2016
Posted in Technical Issues
Likes 0
Views 609
Votes 0
We installed 4.0.5

Categories cannot be ordered. In fact, after attempting to, it caused an error:

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 ()


Please advise,

Thank you!
I was just clicking the up and down arrows and the categories were not moving then the error occurred.

It works now, for some reason.

I guess ED 4 is so advanced it fixes itself??

Matt
·
Monday, 09 May 2016 23:38
·
0 Likes
·
0 Votes
·
0 Comments
·
I just tried to order the category and it works perfectly fine on your end. How do I replicate this? Can you please provide the steps taken to reproduce this?
Mark
·
Monday, 09 May 2016 23:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Haha, I wish it has AI built-in to fix itself but if you are able to reproduce this, please start a new thread on our forums and provide us the steps to reproduce these errors.
Mark
·
Monday, 09 May 2016 23:40
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post