I just upgraded from 4.7 to 5, but all my carefully chosen sorting is gone. Is there any way to sort acidfree albums by weight or any other manual sorting mode?

Comments

andre75’s picture

Title: Arrange images in Albums » How do I sort the albums

I used Chronological order by creation date (changed it to DESC from ASC) and started modifying the post date, but the pager doesn't reflect the new album order, which is even more confusing. Without the change things work allright (the pager matches the album order).
I guess the pager lookup works somewhat different only with ASC queries?

andre75’s picture

Title: How do I sort the albums » Bounty: Add Sorting function to the Album

Looking through the database queries, I think there is a bug in how the pager queries are generated. I see these kind of statements:

pager_query SELECT DISTINCT(n.nid), n.title, n.created FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.type <> 'acidfree' AND tn.tid = 129 AND n.status = 1 ORDER BY created DESC, nid ASC LIMIT 30, 1 
_acidfree_pager_rewrite SELECT DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.type <> 'acidfree' AND tn.tid = 129 AND n.status = 1 ORDER BY created DESC, nid ASC LIMIT 1 OFFSET 0 

I am no expert, but doesn't it it try to order by "created DESC" and "nid ASC" ?

andre75’s picture

Title: How do I sort the albums » Arrange images in Albums

Comparing it to the database queries for the deafault mode:

pager_query SELECT DISTINCT(n.nid), n.title, n.created FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.type <> 'acidfree' AND tn.tid = 129 AND n.status = 1 ORDER BY nid DESC LIMIT 22, 1 
_acidfree_pager_rewrite SELECT DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.type <> 'acidfree' AND tn.tid = 129 AND n.status = 1 ORDER BY nid DESC LIMIT 1 OFFSET 0 

My last offer still stands:
$50 for a decent sorting function:
-easy sorting
-functioning pager

andre75’s picture

Title: Bounty: Add Sorting function to the Album » Arrange images in Albums

Allright, I finally came up with a solution of my own and hereby claim my bounty :-)

vhmauery’s picture

Status: Active » Closed (duplicate)