[Plugin: eShop] SQL Error Message

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

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.

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

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.