Searching for new images in existing gallery duplicates already imported images

  • Resolved Sara Patricia

    (@sarapatricia)


    11 months, 1 week ago

    Using WP 6.3.2. and NGG 3.55 on PHP 8.2

    I have hundreds of galleries stored in different folders. A gallery may have between 1 and several hundred images. I used to FTP images to these folders and then let NGG search for new images.

    Now all images that were already imported to NGG are imported once more so that they get duplicated.

    The PHP error log then shows this database error:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”1”’ at line 1 for query SELECT filename FROM wp1_ngg_pictures WHERE galleryid = ‘1” made by do_action(‘nextgen-gallery_page_nggallery-manage-gallery’), WP_Hook->do_action, WP_Hook->apply_filters, nggAdminPanel->show_menu, nggManageGallery->__construct, nggManageGallery->post_processor_images, nggAdmin::import_gallery

    I belive this is caused by a superfluous ‘ in the WHERE clause, in this example: WHERE galleryid = ‘1” <—–

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Jaime Segura

    (@jaimeimagely)

    Hi @sarapatricia,

    This is related to the 3.5x releases, it was checked and sorted out already. It will be fixed in an upcoming release. For the time being you can keep using NextGEN 3.41 until them. We apologize for the inconveniences.

    If you have a backup from before you uploaded the images, you can restore it, then switch to 3.41 and try again.

    Thread Starter Sara Patricia

    (@sarapatricia)

    Thanks.

    tinuzz

    (@tinuzz)

    Or, open src/Legacy/admin/functions.php in the plugin folder and fix the query (i.e. delete the superfluous quote) on line 512.

    Thread Starter Sara Patricia

    (@sarapatricia)

    Well sorted out @tinuzz, that did the trick!

    Plugin Support Mihai Ceban

    (@mihaiimagely)

    Hi @sarapatricia, @tinuzz,

    I am happy to inform you that the bug with “scan folder for new images”creating duplicate imports based on the already available images was resolved.

    Please update to the latest version of NextGen Gallery to have it fixed.

    Thread Starter Sara Patricia

    (@sarapatricia)

    I can confirm the error has been fixed. Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Searching for new images in existing gallery duplicates already imported images’ is closed to new replies.