Post A Reply

Nick: 2012-03-15 01:41:34

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'];
?>

Nick: 2012-03-15 01:38:46

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?

yplady: 2011-09-01 01:22:10

<?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

flop25: 2011-08-29 11:17:42

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"

yplady: 2011-08-29 04:49:45

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";
?>

lehrer: 2011-08-25 14:57:32

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

Thanks a million!

flop25: 2011-08-25 14:56:42

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

lehrer: 2011-08-25 14:44:25

Would it not be better, safer and easier to have an extra configuration option in the configuration --> options section?

I would then have the following possible options and a few columns, the first one.
The first column will show the option, the second will show the level in a dropdown menu (level 1 will be ordered first etc), and the third column will show ASC or DESC (dropdown menu):

This ti will look like

Order based on:
Date | ASC or DESC | level
Filename | ASC or DESC | level
File added | ASC or DESC | level
etc

yplady: 2011-06-17 02:39:31

Thanks - it's now working!

flop25: 2011-06-16 11:44:18

It's normal : first the numbers, then you have the capital letters ordered correctly and then the others.
So use this thread to order as you wish :
$conf['order_by'] = " order by UPPER(file) COLLATE \'utf8_general_ci\' ASC"; may be the better solution
ps : don't forget $conf['order_by_inside_category']=$conf['order_by']

flop25: 2011-06-16 11:04:35

yplady wrote:
If anyone is curious to take a look...there are five images beginning with Africa - but only one shows alphabetically by file name
http://hermesscarf.com/piwigo/index.php?/category/home

You can see them in the Geography subfolder.

I guess there's not an option to sort by title as set within Piwigo?

the category is private
btw you seems to have trouble with hr_os_xl

ps : your link is wrong but the album Geography is ok ^^

ps² : if you're french you can go to the french forum

yplady: 2011-06-16 04:15:43

If anyone is curious to take a look...there are five images beginning with Africa - but only one shows alphabetically by file name
http://hermesscarf.com/piwigo/index.php?/category/home

You can see them in the Geography subfolder.

I guess there's not an option to sort by title as set within Piwigo?

plg: 2011-06-01 15:22:13

Or better (at performance level):

Code:

$conf['order_by'] = ' ORDER BY file COLLATE \'utf8_general_ci\' ASC';

P@t: 2011-04-20 18:46:27

flop25 wrote:
it's case sensitive

You can sort by filename with insensitive case:

Code:

$conf['order_by'] = " order by UPPER(file) ASC";

flop25: 2011-04-20 18:08:48

flop25 wrote:
We investigate .... [Bugtracker] bug 2270

there is in fact no problem. this is how works the alphabetical order :

Aurora_screenshot.jpg
BSD_013_TechnoDream.jpg
BUD_metal_work_03.jpg
BeHappyDamnit.jpg
Beyond_Knowledge_V1.jpg
BlueOrb.jpg Blue_Christmas.jpg
BoXXiCelli1024x768.jpg
Celestial_Dragons.jpg
Christmas_Balls.jpg

it's case sensitive

Piwigo.org

Announcement

Topic review (newest first)

Nick wrote:

Code:

yplady wrote:

Code:

flop25 wrote:

Code:

flop25 wrote:

Board footer