Announcement

#16 2011-08-25 14:56:42

flop25
Piwigo Team
2006-07-06
7037

Re: How do I get the photos to appear in alphabetical order?

I suggest you to test the 2.3 beta : it's in !


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#17 2011-08-25 14:57:32

lehrer
Member
2010-08-30
24

Re: How do I get the photos to appear in alphabetical order?

Thanks!
I will wait for the next release in this case.

Thanks a million!

Offline

 

#18 2011-08-29 04:49:45

yplady
Member
2011-04-10
18

Re: How do I get the photos to appear in alphabetical order?

Unfortunately, I have to do some major rebuilding (backups were corrupted) and I'm having problems with this same issue...here is what I have in my local config file - what am I missing?

<?php
$conf['order_by_inside_category']=$conf['order_by'];
$conf['order_by'] = " order by UPPER(file) COLLATE \'utf8_general_ci\' ASC";
$conf['order_by'] = " order by UPPER(file) ASC";
?>

Offline

 

#19 2011-08-29 11:17:42

flop25
Piwigo Team
2006-07-06
7037

Re: How do I get the photos to appear in alphabetical order?

normally, only that code should work (remove the last one which is overwriting the previous )

Code:

<?php
$conf['order_by_inside_category']=$conf['order_by'];
$conf['order_by'] = " order by UPPER(file) COLLATE \'utf8_general_ci\' ASC";
?>

Also you can check the order configuration of each album in order to see if it's set as "default"


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#20 2011-09-01 01:22:10

yplady
Member
2011-04-10
18

Re: How do I get the photos to appear in alphabetical order?

<?php
$conf['order_by'] = " order by UPPER(file) ASC";
$conf['order_by_inside_category']=$conf['order_by'];
?>

this did the trick...the one with  '\'utf8_general_ci\' ASC' messed up the mysql query.

thanks for the help.  All I have left to do is reassociate 3500 images!

Denise

Offline

 

#21 2012-03-15 01:38:46

Nick
Guest

Re: How do I get the photos to appear in alphabetical order?

All the pictures I have start with the same words, however there is a number at the end. For example: low_res1, low_res2, low_res3, etc. Is there any easy way to get these to appear starting at 1 rather than at the end?

 

#22 2012-03-15 01:41:34

Nick
Guest

Re: How do I get the photos to appear in alphabetical order?

Nick wrote:

All the pictures I have start with the same words, however there is a number at the end. For example: low_res1, low_res2, low_res3, etc. Is there any easy way to get these to appear starting at 1 rather than at the end?

Nevermind.... I was stupid and didn't read the last post.

<?php
$conf['order_by'] = " order by UPPER(file) ASC";
$conf['order_by_inside_category']=$conf['order_by'];
?>

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact