Gallery ID is 0 for new created Galleries

  • Resolved mygov

    (@mygov)


    5 years, 7 months ago

    After I try to create a new Gallery (over Gallery > Manage Galleries > Add new gallery OR Gallery > Add Gallery / Images > Enter any title > Upload any images), there will no gallery id set in the wp_ngg_gallery table in the gid column. The value of the column “gid” of the new created gallery is “0” (but AUTO_INCREMENT is set active for the column).

    Any ideas how the issue can be fixed?

    MYSQL Version : 10.2.22-MariaDB-log
    PHP Version: 7.2.18

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi @mygov

    We had a similar problem a long time ago, and troubleshooting didn’t do much.

    Even though your MySQL and PHP versions look good, could you please double check our requirements?
    https://www.imagely.com/docs/requirements/

    Go to Gallery > Overview > Site details.

    Thread Starter mygov

    (@mygov)

    I checked the requirements again but no findings.. any further ideas?

    wp-content folder is set to 755

    Server Settings
    Operating System : Linux (64 Bit)
    Server : nginx/1.16.0
    Memory usage : 13.42 MByte
    MYSQL Version : 10.2.22-MariaDB-log
    SQL Mode : NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    PHP Version : 7.2.18
    PHP Safe Mode : Off
    PHP Allow URL fopen : On
    PHP Memory Limit : 256
    PHP Max Upload Size : 128M
    PHP Max Post Size : 128M
    PCRE Backtracking Limit : 1000000
    PHP Max Script Execute Time : 300s
    PHP Exif support : Yes (V7.2.)
    PHP IPTC support : Yes
    PHP XML support : Yes
    Graphic Library

    GD Version : 2.2.5
    FreeType Support : Yes
    FreeType Linkage : with freetype
    GIF Read Support : Yes
    GIF Create Support : Yes
    JPEG Support : Yes
    PNG Support : Yes
    WBMP Support : Yes
    XPM Support : Yes
    XBM Support : Yes
    WebP Support : Yes
    BMP Support : Yes
    JIS-mapped Japanese Font Support : No

    Hi @mygov

    Could you please try to reset NextGen Gallery Settings?
    Go to Gallery > Other options > Reset options

    Please, keep us posted.

    Thread Starter mygov

    (@mygov)

    I tried to reset the options, but unfortunately no difference at all. New galleries will be still created with ID “0”. (Tested with the new NextGEN Gallery release v3.2.0 – with WordPress 5.2)

    Hello @mygov

    I do have to admit that your situation seems unique.
    What hosting provider are you currently using?

    Let’s remove your NextGen Gallery Plugin.
    Deactivate and delete the plugin.
    Re-install the plugin again.

    Then, let’s check for existing conflicts.

    1.- Temporarily deactivate all your plugins except NextGen Gallery.

    2.- Is the problem solved? Then, it was caused by one of your plugins. Please check one by one and find the one causing the problem.

    3.- If the problem is not solved with the deactivation of the plugins, try changing to a standard WordPress theme, it could be a conflict with your current theme.

    Note: if the problem persists we can create a bug report.

    Please let us know how it goes.

    Thread Starter mygov

    (@mygov)

    I found the real solution/workaround:
    In my MariaDB-Server the SQL-Mode “NO_AUTO_VALUE_ON_ZERO” was active, after I removed it the gallery ids generated normally.

    Maybe it makes more sense and edit Line 613/614 of ..\nextgen-gallery\products\photocrati_nextgen\modules\ngglegacy\lib\ngg-db.php and add the gid column with value NULL.

    Related documents about this topic:
    https://mariadb.com/kb/en/library/sql-mode/
    https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Gallery ID is 0 for new created Galleries’ is closed to new replies.