Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

Moderators: martimiz, UncleCheese, Sean, Ed, biapar, Willr, Ingo, swaiba

Unknown column 'MMSort' in 'order clause'


Go to End


1180 Views

Avatar
ismooth

Community Member, 25 Posts

29 November 2013 at 2:51am

Edited: 29/11/2013 2:52am

Hi,

I've got Article object with many_many relation on Review (relation name: Reviews) object, Keyword (Keywords) and Author (Authors, class extends Member). I've also sortable_many_many relation:

SortableDataObject::add_sortable_many_many_relation('Article','Authors');
SortableDataObject::add_sortable_many_many_relation('Article','Keywords');

But, I don't have sortable many_many extension on Article->Reviews relation. Problem now comes when I try to add new Review for an Article in CMS. I get error from title of thread: Unknown column 'MMSort' in 'order clause'

Any ideas how to fix this?