Arrange images in Albums
andre75 - February 19, 2008 - 07:34
| Project: | Acidfree Albums |
| Version: | 5.x-1.x-dev |
| Component: | User interface |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
Description
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?
#1
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?
#2
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" ?
#3
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
#4
Allright, I finally came up with a solution of my own and hereby claim my bounty :-)
#5
duplicate of http://drupal.org/node/224954