Home Forums Plugin Support AffiliateWP BuddyPress Pro Plugin – error

4 replies, 3 voices Last updated by jemains 1 year, 4 months ago
    • Amilcar Gazaniga
      Participant
      @infogotous-market
      #6896

      Hi,

      I´m using AffiliateWP BuddyPress Pro, and had to deactivate the plugin because it´s creating a major error in the site. Each access generates error, and when a disable “AffiliateWP BuddyPress Pro” the site works well. Below I´ll add the log, can you help me solving this?

      Thanks!

      [Thu Mar 30 13:59:50.857327 2017] [proxy_fcgi:error] [pid 12226:tid 140691334043392] [client 191.43.90.191:65133] AH01071: Got error ‘PHP message: Erro de banco de dados do WordPress 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 4 para a consulta \n\t\t\t\tSELECT post_id\n\t\t\t\tFROM wp_postmeta\n\t\t\t\tWHERE ( meta_key = ‘affwp_discount_affiliate’ OR meta_key = ‘affwp_coupon_affiliate’ )\n\t\t\t\tAND meta_value = \n\t\t\t\t feita por require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), bp_init, do_action(‘bp_init’), bp_setup_nav, do_action(‘bp_setup_nav’), affwp_bp_add_affiliate_area_bp_nav, do_action(‘affwp_bp_after_add_nav_items’), affwp_bp_add_coupons_nav_item, AffiliateWP_Show_Affiliate_Coupons::get_coupons\n’, referer: http://www.google.com/?q=abrir+uma+franquia+nos+eua
      [Thu Mar 30 13:59:53.589605 2017] [proxy_fcgi:error] [pid 11169:tid 140691826861824] [client 177.10.210.79:4517] AH01071: Got error ‘PHP message: Erro de banco de dados do WordPress 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 4 para a consulta \n\t\t\t\tSELECT post_id\n\t\t\t\tFROM wp_postmeta\n\t\t\t\tWHERE ( meta_key = ‘affwp_discount_affiliate’ OR meta_key = ‘affwp_coupon_affiliate’ )\n\t\t\t\tAND meta_value = \n\t\t\t\t feita por require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), bp_init, do_action(‘bp_init’), bp_setup_nav, do_action(‘bp_setup_nav’), affwp_bp_add_affiliate_area_bp_nav, do_action(‘affwp_bp_after_add_nav_items’), affwp_bp_add_coupons_nav_item, AffiliateWP_Show_Affiliate_Coupons::get_coupons\n’, referer: https://www.gotous.market/wp-admin/admin.php?page=gf_entries&view=entry&id=63&lid=720&order=ASC&filter&paged=1&pos=13&field_id&operator
      [Thu Mar 30 13:59:54.616965 2017] [proxy_fcgi:error] [pid 13908:tid 140691686536960] [client 191.43.90.191:65137] AH01071: Got error ‘PHP message: Erro de banco de dados do WordPress 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 4 para a consulta \n\t\t\t\tSELECT post_id\n\t\t\t\tFROM wp_postmeta\n\t\t\t\tWHERE ( meta_key = ‘affwp_discount_affiliate’ OR meta_key = ‘affwp_coupon_affiliate’ )\n\t\t\t\tAND meta_value = \n\t\t\t\t feita por require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), bp_init, do_action(‘bp_init’), bp_setup_nav, do_action(‘bp_setup_nav’), affwp_bp_add_affiliate_area_bp_nav, do_action(‘affwp_bp_after_add_nav_items’), affwp_bp_add_coupons_nav_item, AffiliateWP_Show_Affiliate_Coupons::get_coupons\n’, referer: https://gotous.market/
      [Thu Mar 30 13:59:54.656597 2017] [proxy_fcgi:error] [pid 13908:tid 140691652966144] [client 191.43.90.191:65138] AH01071: Got error ‘PHP message: Erro de banco de dados do WordPress 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 4 para a consulta \n\t\t\t\tSELECT post_id\n\t\t\t\tFROM wp_postmeta\n\t\t\t\tWHERE ( meta_key = ‘affwp_discount_affiliate’ OR meta_key = ‘affwp_coupon_affiliate’ )\n\t\t\t\tAND meta_value = \n\t\t\t\t feita por require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), bp_init, do_action(‘bp_init’), bp_setup_nav, do_action(‘bp_setup_nav’), affwp_bp_add_affiliate_area_bp_nav, do_action(‘affwp_bp_after_add_nav_items’), affwp_bp_add_coupons_nav_item, AffiliateWP_Show_Affiliate_Coupons::get_coupons\n’, referer: https://gotous.market/
      [Thu Mar 30 13:59:54.821235 2017] [proxy_fcgi:error] [pid 11169:tid 140691224938240] [client 191.43.90.191:65135] AH01071: Got error ‘PHP message: Erro de banco de dados do WordPress 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 4 para a consulta \n\t\t\t\tSELECT post_id\n\t\t\t\tFROM wp_postmeta\n\t\t\t\tWHERE ( meta_key = ‘affwp_discount_affiliate’ OR meta_key = ‘affwp_coupon_affiliate’ )\n\t\t\t\tAND meta_value = \n\t\t\t\t feita por require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), bp_init, do_action(‘bp_init’), bp_setup_nav, do_action(‘bp_setup_nav’), affwp_bp_add_affiliate_area_bp_nav, do_action(‘affwp_bp_after_add_nav_items’), affwp_bp_add_coupons_nav_item, AffiliateWP_Show_Affiliate_Coupons::get_coupons\n’, referer: https://gotous.market/
      [Thu Mar 30 13:59:55.082850 2017] [proxy_fcgi:error] [pid 11169:tid 140691241723648] [client 191.43.90.191:65136] AH01071: Got error ‘PHP message: Erro de banco de dados do WordPress 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 4 para a consulta \n\t\t\t\tSELECT post_id\n\t\t\t\tFROM wp_postmeta\n\t\t\t\tWHERE ( meta_key = ‘affwp_discount_affiliate’ OR meta_key = ‘affwp_coupon_affiliate’ )\n\t\t\t\tAND meta_value = \n\t\t\t\t feita por require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), bp_init, do_action(‘bp_init’), bp_setup_nav, do_action(‘bp_setup_nav’), affwp_bp_add_affiliate_area_bp_nav, do_action(‘affwp_bp_after_add_nav_items’), affwp_bp_add_coupons_nav_item, AffiliateWP_Show_Affiliate_Coupons::get_coupons\n’, referer: https://gotous.market/

    • Christian Freeman
      Participant
      @christianf
      #6919

      Hi Amilcar,

      Sorry for the delayed response, I didn’t receive the notification for your post. It looks like there’s a compatibility issue with BuddyPress Pro and the Affiliate Coupons add-on. What happens when you deactivate the Affiliate Coupons add-on? Do you still receive those errors?

    • Amilcar Gazaniga
      Participant
      @infogotous-market
      #6924

      Hi Christian,

      Yes, it´s a compatibility issue with Affiliate Coupons add-on, I just tested here as you said, and didn´t get the error. Is it possible to correct?

      Thanks

    • Christian Freeman
      Participant
      @christianf
      #6926

      Does this error appear on every page, or only on the Coupons tab in the affiliate area inside the BuddyPress profile?

    • jemains
      Participant
      @jemains
      #14705
      This reply has been marked as private.
Viewing 4 reply threads
  • You must be logged in to reply to this topic.