ItemOrder plugin allows reordering on admin pages, but no change on public page

Hi -

This is our system info:

System
Omeka 2.4.1
PHP 7.0.14 (cgi-fcgi)
OS Linux 3.2.61-grsec-modsign x86_64
MySQL Server 5.6.34
MySQL Client mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $
PHP Extensions
Regular bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, exif, filter, ftp, gd, gettext, hash, iconv, imagick, imap, json, libxml, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcntl, pcre, PDO, pdo_mysql, pdo_sqlite, posix, pspell, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib
Zend Zend OPcache
Plugins
Dropbox 0.7.2
DublinCoreExtended 2.0.1
Export 2.0
ItemOrder 2.0.2
Scripto 2.2
SimplePages 3.0.7
Themes
Scribe 2.0 (current)

We used the ItemOrder plugin to reorder items within a collection, following the instructions at this url:

http://omeka.org/codex/Plugins/ItemOrder_2.0

These two pages display the new order:

https://www.nsmlv.org/omeka/admin/item-order?collection_id=2
https://www.nsmlv.org/omeka/admin/collections/show/2

Unfortunately, the item order did not change on this page:

https://www.nsmlv.org/omeka/collections/show/2

Is this expected behavior? We would like for the public page to reorder in addition to the admin pages.

It’s not expected behavior but I can’t reproduce this. I have a hunch that it has something to do with a customization that bypasses the plugin’s items_browse_sql hook. Did the previous developer leave notes on the customizations they implemented? Without some insight on the changes I can’t effectively help.

Hi -

We are using the Scripto plugin and the Scribe theme from University of Virginia at this url:

Sorry, I am not a programmer. I grepped through all the files in our Omeka install and the items_browse_sql string only shows up in the
ItemOrderPlugin.php file. Where would the hook be located?

Thank you for your help - we really appreciate it.

Omeka does not maintain the Scribe theme. Again just a hunch, but look in Scribe’s theme directory for a collections/show.php file. If that file exists I suspect that’s where the customization is that the ItemOrder plugin cannot “see.”

Hi - Thank you again for your help. I am thinking about how to fix this problem.

The “culprit” lines are almost certainly these highlighted ones. By picking an explicit sorting order, this code results in that sorting being used rather than Item Order’s. If all you want is the Item Order ordering, just taking out the sort_field and sort_dir lines should do it.

Thank you for your great kindness and patience helping us! Your solution fixed the problem!