WordPress.org

Support

Support » Plugins and Hacks » [Resolved] [Plugin: Paid Memberships Pro] Error adding membership level.

[Resolved] [Plugin: Paid Memberships Pro] Error adding membership level.

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Jason Coleman

    @strangerstudios

    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?

    NEOLiNES

    @neolines

    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

    Plugin Author Jason Coleman

    @strangerstudios

    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.

    NEOLiNES

    @neolines

    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.” :-/

    NEOLiNES

    @neolines

    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.

    NEOLiNES

    @neolines

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

    Plugin Author Jason Coleman

    @strangerstudios

    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.

    WPChina

    @wordpresschina

    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.

    WPChina

    @wordpresschina

    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.

    WPChina

    @wordpresschina

    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….

    Plugin Author Jason Coleman

    @strangerstudios

    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.

    WPChina

    @wordpresschina

    @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.

    Slocum Themes

    @slocumstudio

    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

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘[Resolved] [Plugin: Paid Memberships Pro] Error adding membership level.’ is closed to new replies.