SQL syntax error

  • Resolved Andrea Lincetto

    (@lincetto)


    3 months ago

    Hi, in the log we are getting this error

    [08-Oct-2025 08:16:46 UTC] 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 'AND id IN (21,22,23) ORDER BY parent_id ASC' at line 1 for query SELECT id, category_name as name, icon, ordr, parent_id FROM wp_asl_categories WHERE lang = '' AND AND id IN (21,22,23) ORDER BY parent_id ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/page-blank.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, AgileStoreLocator\Frontend\App->frontendStoreLocator, AgileStoreLocator\Model\Category::get_app_categories

    What could be the cause?

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support masdhrn

    (@masdhrn)

    3 months ago

    Hi, there was an issue with the older version, which version of the plugin you are using? if you are using pro version please create a support ticket by emailing us at [email protected]

    Thank you

    Thread Starter Andrea Lincetto

    (@lincetto)

    3 months ago

    Hi, we are using the latest version of the free plugin

    Andrea

    Plugin Support masdhrn

    (@masdhrn)

    2 months, 4 weeks ago

    We will release an update tomorrow to validate that no extra AND add up to it, with some other updates.

    Thank you

    Plugin Support masdhrn

    (@masdhrn)

    2 months, 3 weeks ago

    Hi, thank you for highlighting it was happening when category attribute was added in the shortcode, we have released 1.6.1 with the fix for it.

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

You must be logged in to reply to this topic.