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've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

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


1751 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?