Forums

[resolved] [Plugin: NextGEN Gallery] Database error. Could not add gallery! (7 posts)

  1. pulk99
    Member
    Posted 3 years ago #

    hi,
    I'm using wp 2.7 and nextGen gallery 1.0.2, and get following error when trying to upload a zip file into a new gallery:

    Database error. Could not add gallery!

    when I try to create a new gallery, I hit the "Add Gallery" button, the page refreshes but nothing happened.

    Tried to deactivate and activate the plugin, no effect. I had no problems before, the gallery was working fine.

  2. Alex Rabe
    Member
    Posted 3 years ago #

    Uninstall the plugin (not only deactive it) and try to upload it again, check also your server error logs

  3. Medialive
    Member
    Posted 3 years ago #

    I don't know if this is the same problem, but when I add a first gallery after successful installation, the add images/gallery page goes blank and I can not add anything to the gallery. The gallery is there, I can see it on the server. I just can't get to it in WordPress.

    It's got to have something to do with my host or database. I'm just not sure what to be looking for. Any thoughts?
    thanks.

  4. pulk99
    Member
    Posted 3 years ago #

    @alex
    the galleries are actually created on the server, also the images are uploaded and the thumbs are generated.

    if you say uninstall, you mean the uninstall function in the setup menu of the gallery, right?
    How is the best way to restore my galleries after that?

  5. pulk99
    Member
    Posted 3 years ago #

    ok, finally resolved the issue.

    I had running wp with a database user with full rights at the beginning, at some point it seems I revoke some privileges (like creating tables, fields,...) from that user.

    so after the update of nextgen-gallery the plugin couldn't add the new fields to the table. that's why I got the database error.

    thanks alex for the help!

  6. visualadventures
    Member
    Posted 3 years ago #

    I tried uninstalling the plug in, reinstalling, that fixed it, but after I uploaded images again, I ended up in the same place. What needs to be done to keep this from happening?

  7. cggurr
    Member
    Posted 3 years ago #

    Alex or pulk99,

    I am having the exact same problem as pulk99 had.
    Did you just uninstall and reinstall the plugin as Alex suggested? And that's what fixed it? Or did you do something with your database that fixed it? If so, what did you do?

    If you uninstalled it, what happened with all of your previously uploaded gallerys/images? After you uploaded the plugin again, did it work just the same?

    I have a lot of posts each with a ton of images using the Nextgen Gallery plugin and I'm scared that I uninstall it, it will lose the images, etc.

    Thanks in advance for you help!

Topic Closed

This topic has been closed to new replies.

About this Topic