order: sortOrder throw sql error on Craft CMS 3 RC15

[MDXDave]

Description

The following code has worked on Craft Cms 2.x:

{% set assets = craft.assets({
    relatedTo: { sourceElement: entry, field: "assetsFieldHandle" },
    order:     "sortOrder",
    limit:     null
}) %}

In Craft Cms 3 RC15 it throws an sql error:

INTERNER SERVERFEHLER
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sortOrder' in 'order clause' The SQL being executed was: SELECT elements.id, elements.fieldLayoutId, elements.uid, elements.enabled, elements.archived, elements.dateCreated, elements.dateUpdated, elements_sites.slug, elements_sites.uri, elements_sites.enabled AS enabledForSite, assets.volumeId, assets.folderId, assets.filename, assets.kind, assets.width, assets.height, assets.size, assets.focalPoint, assets.dateModified, volumeFolders.path AS folderPath, content.id AS contentId, content.title, content.field_addressFooter, content.field_addressHeader, content.field_description, content.field_cdnUrl, content.field_hintHeader, content.field_infoHeader, content.field_body, content.field_contactHeader, content.field_lizenzLink, content.field_lizenz, content.field_menu, content.field_rechteinhaber, content.field_order, content.field_phoneHeader, content.field_weatherHeader FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN assets assets ON assets.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON content.elementId = elements.id WHERE (elements_sites.siteId='1') AND (content.siteId='1') AND (elements.archived=FALSE) AND (elements_sites.enabled=TRUE) AND (elements.id IN (SELECT sources1.targetId FROM relations sources1 WHERE (sources1.sourceId='29') AND (sources1.fieldId='3'))) ORDER BY sortOrder) subquery INNER JOIN assets assets ON assets.id = subquery.elementsId INNER JOIN volumefolders volumeFolders ON assets.folderId = volumeFolders.id INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN content content ON content.id = subquery.contentId ORDER BY sortOrder

Has something changed between Craft cms 2 and 3? Or is it an unexpected bahvior?

[shuckster]

"sortOrder" should point to the field you wish to sort by, and optionally, the direction:

    order:     "filename asc",

Also, I believe order is now deprecated in favour of orderBy in v3.

[MDXDave]

But i want to have the same order as i defined in the backend:

How to achieve this?

[shuckster]

Apparently, the default order option is postDate desc, so perhaps simply exclude the order option.

[MDXDave]

Without using the order/orderBy param, the order is complelty wrong

[shuckster]

Looks like fixedOrder is the parameter to try.

[MDXDave]

As soon as I set this param to true, the values in the sql query would be escaped wrong and a error message is thrown: 🤔

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))

WHERE (elements_sites.siteId='2') AND (content.siteId='2') AND (elements.archived=FALSE) AND (elements_sites.enabled=TRUE) AND (elements.id IN (SELECT sources1.targetId FROM relations sources1 WHERE (sources1.sourceId='30') AND (sources1.fieldId='3'))) 

The code that I am using:

{% set assets = craft.assets({
            fixedOrder: true,
            relatedTo: { sourceElement: entry, field: "gallery" }
        }).all() %}

[shuckster]

After more digging, perhaps this: order('lft')

[MDXDave]

Unknown column 'lft'

As you can see, the param sortOrder should be right, but i can not access them, because it will not read out from the database. There should be something like sources1.* or sources1.sortOrder

SELECT sources1.targetId FROM relations source1

[shuckster]

Perhaps try back-ticking it? Or using single/double quotes:

order( 'sortOrder' )
order( '`sortOrder`' )
order( "'sortOrder'" )
order( '"sortOrder"' )

[MDXDave]

Nope, it does not make any difference.

[shuckster]

How about:

order( 'relations.sortOrder' )
order( '[[relations.sortOrder]]' )

EDIT - Should have been relations, not elements.

[MDXDave]

Column not found: 1054 Unknown column 'elements.sortOrder' in 'order clause'

[shuckster]

Try the edit.

[MDXDave]

Same error, but with relations.sortOrder , the column will not be select from the database

[shuckster]

Perhaps the relatedTo option is messing things up? I guess you've tried it with order as the only option?