Support » Fixing WordPress » [Plugin: eShop] SQL Error Message

  • 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?

Viewing 4 replies - 1 through 4 (of 4 total)
  • I can’t fix atm – engrossed in another project but I’ll take a look as soon as i can.

    elfin

    (@elfin)

    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.

    boonofdoom

    (@boonofdoom)

    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

    elfin

    (@elfin)

    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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: eShop] SQL Error Message’ is closed to new replies.