Title: Database error
Last modified: November 8, 2017

---

# Database error

 *  Resolved [intuitart](https://wordpress.org/support/users/intuitart/)
 * (@intuitart)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/database-error-251/)
 * Woocommerce version 3.2.3
    AffiliateWP version 2.1.7 Show affiliate coupons version
   1.0.6
 * I’m getting a WP database error when accessing the site and not logged in. Error:
 * > 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 ” at line 4]
   >  SELECT post_id FROM wp_postmeta WHERE ( meta_key 
   > = ‘affwp_discount_affiliate’ OR meta_key = ‘affwp_coupon_affiliate’ ) AND meta_value
   > =
 * I can avoid the error by returning from get_coupons() function early if there
   is no $affiliate_id. That is:
 * replace
 * `$affiliate_id = affwp_get_affiliate_id()`
 * with
 *     ```
       if ( ! $affiliate_id = affwp_get_affiliate_id() ) {
       	return false;
       }
       ```
   
 * Hope this helps,
 * Andrew P.

Viewing 1 replies (of 1 total)

 *  Thread Starter [intuitart](https://wordpress.org/support/users/intuitart/)
 * (@intuitart)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/database-error-251/#post-9678537)
 * I see this is fixed in version 1.0.7. Thanks.

Viewing 1 replies (of 1 total)

The topic ‘Database error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/affiliatewp-show-affiliate-coupons_ed6d62.
   svg)
 * [AffiliateWP - Show Affiliate Coupons](https://wordpress.org/plugins/affiliatewp-show-affiliate-coupons/)
 * [Support Threads](https://wordpress.org/support/plugin/affiliatewp-show-affiliate-coupons/)
 * [Active Topics](https://wordpress.org/support/plugin/affiliatewp-show-affiliate-coupons/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/affiliatewp-show-affiliate-coupons/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/affiliatewp-show-affiliate-coupons/reviews/)

## Tags

 * [AffiliateWP](https://wordpress.org/support/topic-tag/affiliatewp/)

 * 1 reply
 * 1 participant
 * Last reply from: [intuitart](https://wordpress.org/support/users/intuitart/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/database-error-251/#post-9678537)
 * Status: resolved