Home› General support

Gallery ignoring album sort order?

squeebie Member
in General support
I'm not sure how this would affect anything, but my host migrated my account to a new server, and since then the order that the albums are displayed in my gallery are wrong.

http://squeebie.com

The admin / edit tab says this: "Current sort: ID descending"
The first album displayed there has an id of 30, it's clearly not the first in the database when I look at the table. If I change the setting for sort order in the admin, it doesn't seem to effect anything.

When I view the albums in the edit tab, they show in the order they're showing in my gallyer. If I manually drag an album, the current sort changes to manual, the page says that the save was successful, I see in the database that the sort_order column is updated correctly, but still the edit page and gallery still show the albums in the wrong order. I'm not even sure what order it's showing in now, but it's not what I want, and it seems to be ignoring any changes I make.

Any ideas?

Comments

  • sbillard Member
    You are running Zenphoto 1.2.2 shortly we will be releasing Zenphoto 1.2.5, so your site is a bit out of date. I suggest you upgrade to the new release as soon as it is available.
  • squeebie Member
    Thanks sbillard. Will that help? Would 1.2.3 help? Why would my host migrating me cause this issue?
  • squeebie Member
    Just to try it out, I updated to 1.2.3, and cleared out my cache folder. No luck.
  • squeebie Member
    It actually seems to be ignoring any change I've tried. Watermark is turned off, but it's showing "watermark" on the full images. I have no idea what's going on. I see my admin changes updating the values in the database, so I know it's set up correctly and using the database, but I don't see those changes affect the front end.
  • sbillard Member
    Mostly I suggested 1.2.4 because it was being released today. It is up and available http://www.zenphoto.org/. Please install it.
  • squeebie Member
    Thanks for the suggestion. I upgraded to 1.2.4 and still no luck. I have a separate install on my server in a test area, and that one still worked fine. I updated the config in that one to point to the database for the gallery at squeebie.com/photos and then it started with the same issues. Looks to me like it something in the database, any ideas what would cause that?

    Is there a way to have zenphoto log the sql statements or something? Or should I just start poking around in the code and see what / where things are going wrong?

    Thanks.
  • acrylian Administrator, Developer
    Watermarked images are cached, if you turn of the option you need to purge your cache.
  • squeebie Member
    I finally figured it out. This zenphoto install I have is pretty old, and has been upgraded a few times. The issue was the parentid on all of my albums was 0, but the query is looking for NULL, so it wasn't returning anything, and I was just getting some default sorting.

    I updated the column to have a default of NULL and updated the current values of my rows from 0 to NULL and that fixed it.

    Thanks for all the suggestions.
  • sbillard Member
    Thanks for the info. We can have setup fix the zero IDs to be nulls. That may help future migrations.
Sign In or Register to comment.