eMember writes commas in mysql database records producing errors.

[lorenzogiacomini]

Hello,

I’ve noticed that eMember, when auto-upgrades to a new membership level,

has a strange behaviour in updating more_membership_levels column in the

wp_eMember_members table.

As you can see in this image: [http://goo.gl/ndXFNS]

it puts commas in front of the membership level code.

This behaviour produces database errors as you can see below in this piece

of error log:

[30-Nov-2013 10:24:18 UTC] 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 ’87 )’ at line 1 for query SELECT * FROM wp_wp_eMember_membership_tbl WHERE id IN ( ,87 ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), call_user_func_array, emember_bootstrap, Emember_Auth::getInstance, Emember_Auth->__construct, Emember_Auth->setPermissions, dbAccess::findAll

This behaviour tends to slow down the website.

Thank you

Lorenzo Giacomini

[mbrsolution]

Hello Lorenzo Giacomini, please load a fresh new copy of the plugin and see if that works.

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

[nur]

in case you are still seeing the error. you can try replacing:

Code:

$my_secondary_levels = dbAccess::findAll(WP_EMEMBER_MEMBERSHIP_LEVEL_TABLE,
‘ id IN ( ‘ . $this->userInfo->more_membership_levels . ‘ ) ‘);

( line 558 ~ 560 if you have latest version)

with:

Code:

$my_secondary_levels = dbAccess::findAll(WP_EMEMBER_MEMBERSHIP_LEVEL_TABLE,
‘ id IN ( ‘ . trim($this->userInfo->more_membership_levels,’,’) . ‘ ) ‘);

[Author]

Posts