WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: eShop] SQL Error Message (5 posts)

  1. RickA99
    Member
    Posted 5 years ago #

    WP 2.7.1 eShop Version 3.0

    I have two products that are downloadable and two identical error messages on my "base" page.

    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 '' at line 1]
    SELECT * FROM wp_eshop_downloads WHERE id =

    What should I do about this?

  2. elfin
    Moderator
    Posted 5 years ago #

    I can't fix atm - engrossed in another project but I'll take a look as soon as i can.

  3. elfin
    Moderator
    Posted 5 years ago #

    I've just taken a look at this and can't replicate it atm. I'll be releasing a new version shortly, so if you could test with that(when released) and let me know if it's fixed or not.

  4. boonofdoom
    Member
    Posted 5 years ago #

    I am getting a similar error, running WP 2.7 and eShop 3.2.1, which results in none of the buy buttons or product pricing showing up on any of my products. Here's what it says in the error log:

    [20-Mar-2009 15:25:14] 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 '6' at line 1 for query SELECT wp_postmeta.post_id, wp_posts.post_content,wp_posts.ID,wp_posts.post_title from wp_postmeta,wp_posts WHERE wp_postmeta.meta_key='_Stock Available' AND wp_postmeta.meta_value='Yes' AND wp_posts.ID=wp_postmeta.post_id AND wp_posts.post_status='publish' order by post_date DESC limit ,6 made by require, require_once, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, eshop_list_new

  5. elfin
    Moderator
    Posted 5 years ago #

    can you confirm which shortcode you are using - I've recently (as in today) found a few of these errors, so I'm hoping I've already fixed it properly for the next release.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags