[12.x, batch manager] order by rank does not work #1416

New Issue

2026-10-05T00:42:59+02:00

adam commented

2026-10-05 00:42:59 +02:00

If you use "manual sort order" in the default photos sort order, then batch manager will, most of the time, throw a "unknown column rank". The rank column must be used to sort photos only if we join with image_category table (which has the rank column...). The $conf['order_by'] should not have any rank in it (from admin/configuration.php):

// there is no rank outside categories
if ( ($i = array_search('rank ASC', $order_by)) !== false)
{ 
  unset($order_by[$i]);
}

BUT since rank became a reserved keyword in MySQL 8, Piwigo has added backticks to rank and of course, the search for rank ASC never works...

If you use "manual sort order" in the default photos sort order, then batch manager will, most of the time, throw a "unknown column rank". The `rank` column must be used to sort photos only if we join with `image_category` table (which has the `rank` column...). The `$conf['order_by']` should not have any `rank` in it (from `admin/configuration.php`): ``` // there is no rank outside categories if ( ($i = array_search('rank ASC', $order_by)) !== false) { unset($order_by[$i]); } ``` BUT since `rank` became a reserved keyword in MySQL 8, Piwigo has added backticks to `rank` and of course, the search for `rank ASC` never works...

adam closed this issue

2026-10-05 00:42:59 +02:00

Sign in to join this conversation.

master

issue-2560-people

translation

16.x

feat/embedding-based-contextual-tagging

issue-2576-search-include-ai-in-search-results

feat/search-ocr-ai

issue-2391-update-menu-design

15.x

detect-container

issue-2386-update-filters-users-activity

issue-2362-add-filters-options-in-admin

issue-2367-imagemagick7

issue-2225-quicksearch-help

14.x

issue-2164-BatchManagerUnitMode-Redesign

13.x

12.x

issue-1657-SVG_Support

issue-1703-historySearchMethod

11.x

2.10

2.9

2.8

2.7

2.5

2.6

2.4

2.3

2.2

2.1

2.0

1.7

1.3

1.6

1.5

1.4

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: adam/Piwigo#1416