Clicking a gallery shows nothing

  • Resolved kenw232

    (@kenw232)


    8 years, 6 months ago

    When I click one of our 6 galleries in the WP admin I see no images. I get this in my apache error log. I’m running PHP 5.5.34 on Linux with NextGEN Gallery 2.1.31. There is nothing after “ORDER BY…” WHY?

    [Mon May 30 11:22:58 2016] [error] [client 173.238.101.156] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 50’ at line 1 for query SELECT DISTINCT wp_ngg_pictures.* , GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS ‘extras’ FROM wp_ngg_pictures LEFT OUTER JOIN wp_postmeta ON wp_postmeta.post_id = extras_post_id WHERE (galleryid = 2) GROUP BY wp_ngg_pictures.pid ORDER BY LIMIT 50 made by do_action(‘gallery_page_nggallery-manage-gallery’), call_user_func_array, nggAdminPanel->show_menu, nggManageGallery->controller, nggallery_picturelist, C_Image_Mapper->run_query, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, C_CustomTable_DataMapper_Driver_Mixin->run_query, referer: https://staging1.extremehosting.ca/wp-admin/admin.php?page=nggallery-manage-gallery

    https://www.ads-software.com/plugins/nextgen-gallery/

Viewing 1 replies (of 1 total)
  • Plugin Contributor photocrati

    (@photocrati)

    @kenw232 – I would recommend insuring you are using the current release of NextGEN Gallery; and, please try our external Reset Tool plugin here: https://bitbucket.org/photocrati/nextgen-gallery-reset/get/default.zip as this appears that it may be a migration related issue.

    To install and activate, go to Plugins > Add New … Upload Plugin
    To use, go to Tools > NextGEN Gallery Reset

    We do not offer specific support for the Reset Tool plugin as is but it can help in many circumstances, please let us know if it does.

    Thanks!

    – Cais.

Viewing 1 replies (of 1 total)
  • The topic ‘Clicking a gallery shows nothing’ is closed to new replies.