WordPress.org

Ready to get started?Download WordPress

Forums

Paid Memberships Pro
[resolved] Error adding membership level. (14 posts)

  1. NEOLiNES
    Member
    Posted 1 year ago #

    Getting this message when adding a membership level.

    Error adding membership level.

    http://wordpress.org/extend/plugins/paid-memberships-pro/

  2. strangerstudios
    Member
    Plugin Author

    Posted 1 year ago #

    That is a kind of generic message generated at line 146 of adminpages/membershiplevels.php. What's happening is the query to add the level into the DB is failing.

    Which version of the plugin are you using?

    Does this happen always? Or when setting up a specific level?

    Can you paste here what you are entering for ALL of the fields when adding the level?

    Any other information that may help me?

  3. NEOLiNES
    Member
    Posted 1 year ago #

    Hi,

    I'm using version 1.5.1 on a fresh install of the latest stable WordPress build. I get the same result every time.

    Submit form
    http://imageshack.us/a/img818/8328/paidmembershippro.png

    Result
    http://imageshack.us/a/img27/3223/paidmembershippro2.png

    EDIT
    Bad images, not showing the "title", here's another one.
    http://imageshack.us/a/img542/8328/paidmembershippro.png

  4. strangerstudios
    Member
    Plugin Author

    Posted 1 year ago #

    So it doesn't seem to be due to the values you entered, or that you are using a different currency.

    I'm guessing the DB tables are missing for some reason. Can you check your DB for the wp_pmpro_membership_levels table and the others. (It can have a different prefix if you aren't using wp_ as your DB prefix.)

    Here is the SQL for the tables if you need to set it up manually:
    http://www.paidmembershipspro.com/wp-content/plugins/paid-memberships-pro/includes/setup.sql

    You can possibly get more information by adding $wpdb->print_error(); above $msg = -1 around line 145 of membershiplevels.php. If you do that, paste the results here.

  5. NEOLiNES
    Member
    Posted 1 year ago #

    I have all the tables in my database, and I added the "$wpdb->print_error();" on line 145 above "$msg = -1;", but I still just get "Error adding membership level." :-/

  6. NEOLiNES
    Member
    Posted 1 year ago #

    I've located the problem. With the version i have (1.5.1), there is a old "create table" for "*_pmpro_membership_levels", so there are some columns (confirmation, expiration_number and expiration_period) missing.

    I'll delete my current tables and install them from the link you sent.

  7. NEOLiNES
    Member
    Posted 1 year ago #

    Now it's working fine! Thank you for your support!

  8. strangerstudios
    Member
    Plugin Author

    Posted 1 year ago #

    Glad you got this working.

    There is upgrade code that should run to update your tables when you upgrade PMPro. I'm curious to how you installed PMPro that these didn't run... or ran out of order, etc.

    You said it was a fresh install of WP and PMPro 1.5.1. Were you using a DB that had PMPro installed earlier? Do you know what version of PMPro that was?

    Just trying to figure out how to keep this from happening to others.

    Thanks.

  9. WPChina
    Member
    Posted 7 months ago #

    I just downloaded and installed 1.6.1 and then the Dashboard said there was a new version so I auto-updated to 1.7.1. I am also getting this "Error adding membership level." error message so I am researching why this is happening.

  10. WPChina
    Member
    Posted 7 months ago #

    I uninstalled the plugin and rather than download and install the version I received from http://www.paidmembershipspro.com I used the WP Repository version. I still get the same error when trying to add the first level.

  11. WPChina
    Member
    Posted 7 months ago #

    We disabled all plugins except Paid Memberships Pro, but we still get this error message. I do not get the error message on a clean install, so that means either there is a conflict in the database or maybe elsewhere?

    When I use the WPMU Membership plugin, everything flows fine and works well, so could there be some artifacts from that plugin affecting Paid Memberships Pro? Everything is deactivated and Membership plugin is also deleted fully so I am unclear if that has an impact....

  12. strangerstudios
    Member
    Plugin Author

    Posted 7 months ago #

    FYI, the Paid Memberships Pro site simply links to the latest version of the plugin in the repository here. It's all the same plugin.

    Can you email me at jason@strangerstudios.com and include a WP admin user/pass and FTP user/pass for your site. I'll take a look at the error in action and might have an idea of what is going on.

    Thanks.

  13. WPChina
    Member
    Posted 7 months ago #

    @strangerstudios: thank you for the feedback. yes somehow it linked to a 1.6.1 version when we used your site.

    We fixed this but I'm unsure how it was solved. We exported all Posts and Pages and then re-built the database with a clean database and then re-imported everything and added the plugin. Now everything is fine.

  14. Slocum Themes
    Member
    Plugin Author

    Posted 7 months ago #

    Hi WPChina,

    We're glad you got this issue straightened out. I think there was some type of conflict in the DB. I'll mark this as resolved.

    Thank You

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic