Support » Plugin: WordPress Gallery Plugin - NextGEN Gallery » Image upload error, Server Misconfiguration message and other dubious things

  • Hello,

    I’ve just spent the last hour or so fixing an issue with this plugin.
    When trying to upload files to galleries it kept giving me an error which suggests that the server is misconfigured..
    I deactivate and deleted the plugin, then reinstalled it again. Still the same issue. So I deleted it again, accessed my sql database and noticed that the databases were NOT deleted.
    So I manually deleted them.
    I then reinstalled the plugin to receive the same “Misconfigured” error.
    When I looked at my php logs, you could consider that databases not existing being “misconfigured”.
    mod_fcgid: stderr: WordPress database error Table 'wordpress_e.96W4t1_ngg_pictures' doesn't exist for query ALTER TABLE96W4t1_ngg_picturesADD COLUMNalttextTEXT made by require_once('wp-lo
    etc.

    I’ve just had to search online for the SQL to create all 3 of the database tables, because I couldn’t actually find them in the plugin files at all.
    I manually created the databases, and it is working fine now.

    Might want to look into your plugin somewhere because evidently its not correctly making the databases that it requires, and neither is it deleting the databases when it is uninstalled.

    https://wordpress.org/plugins/nextgen-gallery/

Viewing 2 replies - 1 through 2 (of 2 total)
  • I’ve also discovered another issue which I can not fix. Looks like for some reason that using the “Add Gallery/Images” section to create a new gallery that it always wants to create a new gallery starting with gid=0.

    mod_fcgid: stderr: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO 96W4t1_ngg_gallery

    This for some reason happens even when there is a completely empty (truncated) database.
    The work around seems to be to use the “Manage Galleries” page to create the galleries, then to add the images to them via the “Add Gallery/Images” section.

    Plugin Author photocrati

    (@photocrati)

    @stealthbird97 – Generally, if the database tables are not created when the plugin is installed and activated then the database user’s privileges should be reviewed to insure they have *ALL* privileges.

    As to deleting the database entries on uninstall, we have chosen not to do so at this time as it causes the plugin to lose reference to the images in the existing galleries and as such if uninstalling and re-installing the plugin manually you would also have to re-upload every image from every gallery each time as well.

    Thanks!

    – Cais.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Image upload error, Server Misconfiguration message and other dubious things’ is closed to new replies.