Still sorting problems

[wolfgangm]

Recently I had sorting problems which I described here, and where I received kind help here.

Our users still complain about strange behaviour in sorting, which I cannot resolve:

- The sorting of the photos within the themes (or by daily sorting) workes by date, but when a photo receives a comment, this photo keeps it's position. (before, commented photos jumped to first position).

- There is strange sorting behaviour within the personal user albums: The first photo ist the newest one, from second photo on they are sorted by name, instead of date or comment.

The link is:
http://www.sagen.at/fotos/index.php

Help would be kindly welcome

Wolfgang

[Chuck S]

Remember users whom have personal albums are allowed to set default sorts on photos therefore just like a sticky those photos will aways appear in order ahead of any other sort

[wolfgangm]

Dear Chuck,

please allow me to oppose.

I am sure, there happened any crash to a table: When this dis-sorting started, I noticed one photo-thumb in the first row of our index-page:
http://www.sagen.at/fotos/index.php

this thumb has been in the usually empty row. This photo also mixed up with annother users photo by the same file-name. Since this incident, I have those difficulties. That time I deleted both photos, but some sorting things still are strange.
I have no idea, how to repair which table?

Besides personal albums, it would be much more comfortably, if commented photos move in first position again! This needs to be a problem with a table?

Kindest regards

Wolfgang

[Chuck S]

There is no problem here that i see if someone sorts a photo then moves it the sort never changes, there is no provision for that

You can elect to set all photos to no sort to override the cat sort by doing a query like so

UPDATE pp_photos SET disporder='99999'

[wolfgangm]

The column disporder in table pp_photos has default value "99999" ?

Wolfgang

[Chuck S]

Right and I would bet the photos that are out of order has a disporder set to some other parameter