Order change not allowed

5 posts by 2 authors in: Forums > CMS Builder
Last Post: September 12, 2016   (RSS)

By jenolan - September 11, 2016

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

---
<?= "Jenolan(Larry) :: Coding Since 1973" ?>
Peace and Long Life

By Damon - September 12, 2016

Hi, 

In the Section Editor for News, here are the steps:

  1. Erase the dragSortOrder field

  2. Under the General tab, in the ListPage Fields text field, remove dragSortOrder

  3. In the Sorting tab, in the Order By field, change this:
    dragSortOrder DESC
    to this
    createdDate DESC, title

  4. 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!

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

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. 

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By jenolan - September 12, 2016

Right, that did it ... old punch card nutz like me are used to saving at each step ;-)

Thanks!

---
<?= "Jenolan(Larry) :: Coding Since 1973" ?>
Peace and Long Life