NextGEN Gallery
Gallery title and ID out of sync after deleting galleries (5 posts)

  1. macaronilover
    Posted 2 years ago #

    If you delete galleries, the title and ID goes out of sync.

    For example, say I made 5 galleries named with the title { 1, 2, 3, 4, 5 }.
    Then I delete galleries { 2, 3, 4, 5 }.
    The next time I make a new gallery with the title { 2 }, the gallery ID for it will be 6.
    So I have a new gallery with the title { 2 } and gallery ID with { 6 }.

    I've been able to temporarily fix this problem manually by going into mysql and changing the "gid" and "galleryid" from "6" to "2".
    But the problem still persists if make a new gallery because of auto incrementation from some field/table. ( The new gallery will have an gallery ID of 7 ).

    I have to manually change the ID through mysql every time I make a new gallery.

    I've already searched the web for answers and found 2 other links addressing similar issues but no solution are listed.

    This plugin is awesome and would like to continue using it but ID syncing is crucial to my installation.

    If I can't find a solution, I'm going to have to find an alternative.
    Does someone out there know how to fix this problem?


  2. DoubleSixx
    Posted 2 years ago #

    Yeah it's always been that way, I learned to get over it and just ignore the numbers.

  3. tizz
    Posted 2 years ago #

    Yes, it's a non-problem, auto incrementation is the way database works.

  4. macaronilover
    Posted 2 years ago #

    Ah what a bummer. Thanks for the confirmation guys. Goodbye Nextgen!

  5. photocrati
    Plugin Author

    Posted 2 years ago #

    @macaronilover - Although this is a common database issue and not directly related to NextGEN Gallery, you are still free to submit a Feature Request to be able to re-index the database entries (or something similar that meets your needs).

    We have a form for just such ideas here: http://www.nextgen-gallery.com/feature-voting/


    - Cais.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • NextGEN Gallery
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic