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.

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

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

Unknown column 'MMSort' in 'order clause'


Reply


588 Views

Avatar
ismooth

Community Member, 24 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?