Can’t add a Membership Level

  • Resolved doyenwilliams

    (@doyenwilliams)


    4 years, 10 months ago

    Hi there,

    I’m currently building a community site for a client.

    My problem is: having added PMP, when I go through the process of adding a membership level it comes back with “Membership level added successfully.” at the top of the menu, but then “No Membership Levels Found. Create a membership level.”

    Plugin environment (all pre-date the addition of PMP):
    Beaver Builder Addons by WPZOOM
    Beaver Builder (Lite)
    Caldera Forms
    Email Subscribers & Newsletter
    EWWW Image Optimizer
    GT Translate
    If Menu
    LiveMesh Addons for Beaver Builder
    PeepSo
    PeepSo Ultimate Bundle (including PeepSo PMP integration)
    Pods
    Pods Beaver Theme Add-On
    WP ADmin Custom Interface
    WP Audit Security Log

    Wordfence was added POST PMP installation

    I have deactived, uninstalled, re-installed and reactivated PMP with no change in the results.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter doyenwilliams

    (@doyenwilliams)

    According to the audit log every time I activate this plugin it loops through creating 2 database tables 4x
    – wp_pmpro_membership_levelmeta
    – wp_pmpro_membership_levels

    I still am unable to add levels.

    I have tried disabling peepso and its related plugins – but that does nothing.

    Any help is appreciated.

    Plugin Author Andrew Lima

    (@andrewza)

    Hi @doyenwilliams

    Thank you for using Paid Memberships Pro, I’m sorry to hear about the issue you are facing.

    This sounds like it could be an issue with your database tables for the _pmpro_membership_levels.

    Could you please ensure that it’s correctly setup by referencing this code as a base for the comparison – https://github.com/strangerstudios/paid-memberships-pro/blob/dev/includes/setup.sql

    Thread Starter doyenwilliams

    (@doyenwilliams)

    you are correct @andrewza – I cannot identify the

    – wp_pmpro_membership_levelmeta
    – wp_pmpro_membership_levels

    tables in my database. All other tables have been created. I tried running the SQL from the page you sent and was still unable to create the tables.

    Any advice helps.

    Plugin Author Andrew Lima

    (@andrewza)

    Thanks for the feedback, what error did you get when trying to manually create the tables in SQL?

    This code should work but might need slight tweaking to support direct SQL calls.

    Thread Starter doyenwilliams

    (@doyenwilliams)

    sorry about the wait @andrewza ..

    “#1709 – Index column size too large. The maximum column size is 767 bytes.”

    Thread Starter doyenwilliams

    (@doyenwilliams)

    Updating to a current version of the database server fixed this issue.

    It is NOT an issue with the plugin.

    Thank you for your assistance @andrewza

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Can’t add a Membership Level’ is closed to new replies.