Home Forums Plugin Support AffiliateWP BuddyPress Pro Plugin – error

3 replies, 2 voices Last updated by  Christian Freeman 7 months, 2 weeks ago
  • Amilcar
    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
    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?

You must be logged in to reply to this topic.