Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: 'Order by title' problem  (Read 3699 times)

0 Members and 1 Guest are viewing this topic.

burlington

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
'Order by title' problem
« on: June 21, 2012, 06:12:58 pm »

Running version 1.5x with numerous albums within a small number of categories. I have been asked if the albums can be ordered (sorted) by title (name) within each category. I have followed earlier advice to amend the index.php file to show 'order by title' but to no avail.

Any advice would be welcome please. I thought that there was a function within the admin system to achieve this without file editing but I can't find it.

Thanks

Martin



Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: 'Order by title' problem
« Reply #1 on: June 21, 2012, 10:42:55 pm »

I have followed earlier advice to amend the index.php file to show 'order by title'
Please post a link to that thread.
Logged

burlington

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: 'Order by title' problem
« Reply #2 on: June 22, 2012, 10:36:51 am »

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: 'Order by title' problem
« Reply #3 on: June 25, 2012, 10:48:43 am »

Joachim's instruction works as expected for me. You have to replace
Code: [Select]
ORDER BY a.pos, a.aidwith
Code: [Select]
ORDER BY a.title, a.aidtwice, in index.php
Logged

burlington

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: 'Order by title' problem
« Reply #4 on: July 05, 2012, 03:22:10 pm »

Thank you for your help.

Apologies for the delay in replying but I have been away. Your suggestion works fine and I am grateful.

However, I have now been asked about sorting by title within categories in the album manager file /albmgr.php BUT I can't seem to get it to do what I want it to.

Can you help again please?

Thanks

Martin
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: 'Order by title' problem
« Reply #5 on: July 05, 2012, 03:29:09 pm »

sorting by title within categories in the album manager file /albmgr.php
Sorry, but I don't understand what you want to do.
Logged

burlington

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: 'Order by title' problem
« Reply #6 on: July 05, 2012, 06:16:29 pm »

Andre

Thanks

If the Administrator wants to edit an album within Album Manager, ..../gallery/albmgr.php?cat=*, and there are a lot of albums within a Category, the albums are not sorted automatically by title order and so he/she has to read down the list until they find what is wanted.

The list IS now sorted by Title order in the public view of the albums BUT not within Album Manager.

Martin
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: 'Order by title' problem
« Reply #7 on: July 05, 2012, 07:58:04 pm »

So your current request is to sort also the album manager by title, right?
Logged

burlington

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: 'Order by title' problem
« Reply #8 on: July 05, 2012, 10:14:50 pm »

Yes please.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: 'Order by title' problem
« Reply #9 on: July 06, 2012, 10:05:17 am »

Open albmgr.php, find
Code: [Select]
ORDER BY pos ASCand replace with
Code: [Select]
ORDER BY title ASC(twice).
Logged

burlington

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: 'Order by title' problem
« Reply #10 on: July 07, 2012, 08:32:44 am »

Works perfectly.

Very many thanks

Martin
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: 'Order by title' problem
« Reply #11 on: July 08, 2012, 10:43:16 am »

Please
tag your answer as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 21 queries.