NextGEN Gallery WordPress database error You have an error in your SQL syntax

I’m experiencing high rate of errors (every 30 seconds to 1 minute) when in WP admin adding or editing posts. These errors cause the server to overload and run out of memory and swap memory (website goes down)

Each line in my error log looks like this:

[09-Sep-2014 19:37:38] 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 ‘-20, 20’ 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 (exclude = 0) AND (galleryid IN (13)) GROUP BY wp_ngg_pictures.pid ORDER BY ABS(sortorder) ASC, sortorder ASC LIMIT -20, 20 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/CP/single.php’), the_content, apply_filters(‘the_content’), call_user_func_array, C_NextGen_Shortcode_Manager->parse_content, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, M_NextGen_Basic_Gallery->render, C_Displayed_Gallery_Renderer->display_images, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Renderer->display_images, C_Displayed_Gallery_Renderer->render, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Renderer->render, C_Display_Type_Controller->index_action, C_Display_Type_Controller->__call, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_Basic_Thumbnails_Controller->index_action, C_Displayed_Gallery->get_included_entities, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->get_included_entities, C_Displayed_Gallery->get_entities, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->get_entities, C_Displayed_Gallery->_get_image_entities, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->_get_image_entities, C_Image_Mapper->run_query, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, C_CustomTable_DataMapper_Driver_Mixin->run_query, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

Does anyone know how to fix this issue?

I’m running NextGEN Gallery Version 2.0.66.27

thanks in advance!

Mike

https://ww.wp.xz.cn/plugins/nextgen-gallery/