Title: [Plugin: eShop] SQL Error Message
Last modified: August 19, 2016

---

# [Plugin: eShop] SQL Error Message

 *  [ricka99](https://wordpress.org/support/users/ricka99/)
 * (@ricka99)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/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)

 *  Anonymous User
 * (@anonymized-3085)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/plugin-eshop-sql-error-message/#post-995042)
 * I can’t fix atm – engrossed in another project but I’ll take a look as soon as
   i can.
 *  Anonymous User
 * (@anonymized-3085)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/plugin-eshop-sql-error-message/#post-995317)
 * 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](https://wordpress.org/support/users/boonofdoom/)
 * (@boonofdoom)
 * [17 years, 2 months ago](https://wordpress.org/support/topic/plugin-eshop-sql-error-message/#post-995391)
 * 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
 *  Anonymous User
 * (@anonymized-3085)
 * [17 years, 2 months ago](https://wordpress.org/support/topic/plugin-eshop-sql-error-message/#post-995392)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: Anonymous User
 * Last activity: [17 years, 2 months ago](https://wordpress.org/support/topic/plugin-eshop-sql-error-message/#post-995392)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics