Error – WordPress database error You have an error in your SQL syntax

  • Tons of this error in my error logs.

    [Thu May 01 10:26:38 2014] [8553253] [fcgid:warn] [client 72.167.191.15:46955] mod_fcgid: stderr: 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 gtcwfpt_ngg_pictures.* , GROUP_CONCAT(CONCAT_WS('@@', meta_key, meta_value)) AS 'extras' FROMgtcwfpt_ngg_picturesLEFT OUTER JOINgtcwfpt_postmetaONgtcwfpt_postmeta.post_id=extras_post_idWHERE (exclude= 0) AND (galleryidIN (17)) GROUP BY gtcwfpt_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/arras-theme/page.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, referer https://fifteen52.us/gallery/cast-tarmacs/nggallery/page/page/3
    `

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor photocrati

    (@photocrati)

    @chapel976 – There may be a few issues going on with your site, have you already checked for conflicts with other active plugins or possibly your theme?

    – Cais.

    Thread Starter Chapel976

    (@chapel976)

    I have checked through all the error logs and this is the only one that comes up constantly.

    I’m using the Arras theme on a GoDaddy Linux host
    WordPress 3.9
    Plugin version 2.0.65

    Plugin Contributor photocrati

    (@photocrati)

    @chapel976 – We have seen issues with the Arras theme and GoDaddy hosting as well … perhaps you would be better off submitting a Bug Report (https://www.nextgen-gallery.com/report-bug/ … please reference this topic) with your site details so we can try to help you by getting a closer look under the page.

    We will need log in and FTP credentials for your WordPress installation as well, please include those wit the Bug Report.

    Thanks!

    – Cais.

    Thread Starter Chapel976

    (@chapel976)

    thanks. I’ll need to get approval from the site owners.

    Plugin Contributor photocrati

    (@photocrati)

    @chapel976 – By all means, definitely let them know we will be trying to help get this sorted out.

    Thanks!

    – Cais.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error – WordPress database error You have an error in your SQL syntax’ is closed to new replies.