Resetting sort order for all albums

mloiterman

Joined: 2006-01-02
Posts: 5
Posted: Tue, 2006-01-03 01:44

How can I reset the sort order for all my albums? I have many albums, so only a SQL command line instruction will be practical.

Ideally, I would like to set them all to be alphabetical, with new items first.
 
pelle
pelle's picture

Joined: 2004-12-10
Posts: 389
Posted: Tue, 2006-01-03 01:51

You could set all albums to use the default order by argument with this (postgresql):
UPDATE g2_albumitem SET g_orderby = '', g_orderdirection = '';
Then go to Site Admin -> Theme and set your desiered order by.

Final you need to flush the db cache (Site Admin -> Maintenance)
 
mloiterman

Joined: 2006-01-02
Posts: 5
Posted: Tue, 2006-01-03 02:52

Thanks. That worked perfectly...