- This topic has 2 replies, 2 voices, and was last updated 6 years, 9 months ago by .
Viewing 3 posts - 1 through 3 (of 3 total)
Viewing 3 posts - 1 through 3 (of 3 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
by
Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember Troubleshooting › Help deleting old membership levels from database
Tagged: emember database, membership levels
How can I delete from the database old membership levels. A colleague added 45 different membership levels. I deleted them all and want to refresh the database so that the levels start again from 1 and go to 5 instead of 1 then 58 59 etc.
Is there a table setting or commend where I can do this please?
I will back up first before doing do of course.
Thanks
MIa
…I deleted them all and want to refresh the database so that the levels start again from 1 and go to 5…
Those are really the MySQL index numbers for the wp_eMember_membership_tbl table, and are controlled by MySQL, not the plugin or WordPress. Resetting the index counter requires that you first delete all existing members from the plugin, and then reset the AUTO_INCREMENT values within MySQL, using phpMyAdmin.
The ID numbers are normally not visible to members (they only see the level names), and are only visible to administrators with access to the plugin settings. So you shouldn’t really worry about those numbers.
Thanks for that