Order change not allowed
5 posts by 2 authors in: Forums > CMS Builder
Last Post: September 12, 2016 (RSS)
I am setting up a news feed, in the section editor 'Sorting' I want the "createdDate DESC, title", DragSortOrder has been removed but whenever I try and save the new sort it always comes back with;
If used, dragSortOrder must be the first field in 'Order By'!
Sorting Error: Check your 'Order By' fields in the sorting tab for invalid field names.
MySQL returned the following error: Unknown column 'dragSortOrder' in 'order clause'
Help!
Larry
Peace and Long Life
By Damon - September 12, 2016
Hi,
In the Section Editor for News, here are the steps:
- Erase the dragSortOrder field
- Under the General tab, in the ListPage Fields text field, remove dragSortOrder
- In the Sorting tab, in the Order By field, change this:
dragSortOrder DESC
to this
createdDate DESC, title - Click the Save Details button
That's the steps. Let me know if this works for you and/or you have any other questions.
Thanks!
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
As soon as I try step 2 the error appears and dragSortOrder is back in the ListPage fields, you list was what I was doing in the first place.
Larry
Peace and Long Life
By Damon - September 12, 2016
As soon as I try step 2 the error appears and dragSortOrder is back in the ListPage fields, you list was what I was doing in the first place.
Don't click the Save Details button until you have done both Steps 2 and 3.
Let me know if that works.
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Right, that did it ... old punch card nutz like me are used to saving at each step ;-)
Thanks!
Peace and Long Life