Membership Level "XX" couldn't be created due to error.

[yiyeluwei]

wp eMember v10.2.6

wordpress 5.3.2

php 7.3.11

mysql 8.0.18

When I try to create my first membership level, red alert appears: Membership Level “XX” couldn’t be created due to error.

Just bought the plugin today. Not sure what to do with this error.

Best Regards

Yuan

[wzp]

Please deactivate the plugin and try installing a fresh copy:

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

[Plugin User]

I had the same problem. On investigation here are my findings and how i fixed it.

I have WordPress installed on Azure on MySQL. After installing and uninstalling eMember multiple times i was unable to resolve the issue.

Observation: Tables wp_wp_eMember_membership_tbl, wp_wp_auth_session_tbl, wp_wp_members_meta_tbl, wp_wp_eMember_members_tbl Did not exist in the database.

Issue: The issue seems to be the Database Engine on Azure being InnoDB while the scripts assume MyISAM. (Ref: eMember_installer.php lines: 74, 102, 116, 139, 175, 234, 243, 256, 278)

Solution: I created these 4 tables manually.

Steps:

1. Downloaded a MySQL Client tool. Heidisql worked for me just fine.

2. Run SQL Create Table Statements to create these Tables manually using InnoDB Engine.

3. Only one change in script was needed, looks like InnoDB does not accept Default Date parameters to be ‘0000-00-00’, so I had to change that to ‘2000-01-01’.

4. Restarted the website.

Everything seems to be working now.

[wzp]

Thank you for providing your solution. For further clarification to others: InnoDB is actually the DB “engine” that runs beneath MySql. The default DB engine is MyISAM.

[Author]

Posts