PHP Error logged after installing "Membership Plugin"

Immediately after installing the "Membership" plugin, I am seeing PHP errors appearing that are:

[21-Jan-2013 00:04:15] WordPress database error Table 'wbfw_wpbnsdatabase.89371wp_m_coupons' doesn't exist for query SELECT * FROM 89371wp_m_coupons WHERE couponcode = '' made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/membership/membershippremium.php'), membershipadmin->__construct, M_Coupon->__construct
[21-Jan-2013 00:04:17] WordPress database error Table 'wbfw_wpbnsdatabase.89371wp_m_coupons' doesn't exist for query SELECT * FROM 89371wp_m_coupons WHERE couponcode = '' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/membership/membershippremium.php'), membershipadmin->__construct, M_Coupon->__construct

I'm not sure why or what is causing this so I am requesting your input.

Please let me know how I can resolve this and what might be causing it.

Thanks,
Gary Gordon

  • Gary M. Gordon

    I ran the repair (per your suggestion) and it reported back:

    Verifying and Repairing

    Checking table : 89371wp_m_membership_levels - Ok

    Checking fields in table : 89371wp_m_membership_levels -
    id - Ok
    level_title - Ok
    level_slug - Ok
    level_active - Ok
    level_count - Ok

    Checking table : 89371wp_m_membership_relationships - Ok

    Checking fields in table : 89371wp_m_membership_relationships -
    rel_id - Ok
    user_id - Ok
    sub_id - Ok
    level_id - Ok
    startdate - Ok
    updateddate - Ok
    expirydate - Ok
    order_instance - Ok
    usinggateway - Ok

    Checking table : 89371wp_m_membership_rules - Ok

    Checking fields in table : 89371wp_m_membership_rules -
    level_id - Ok
    rule_ive - Ok
    rule_area - Ok
    rule_value - Ok
    rule_order - Ok

    Checking table : 89371wp_m_subscriptions - Ok

    Checking fields in table : 89371wp_m_subscriptions -
    id - Ok
    sub_name - Ok
    sub_active - Ok
    sub_public - Ok
    sub_count - Ok
    sub_description - Ok
    sub_pricetext - Ok

    Checking table : 89371wp_m_subscriptions_levels - Ok

    Checking fields in table : 89371wp_m_subscriptions_levels -
    sub_id - Ok
    level_id - Ok
    level_period - Ok
    sub_type - Ok
    level_price - Ok
    level_currency - Ok
    level_order - Ok
    level_period_unit - Ok

    Checking table : 89371wp_m_subscription_transaction - Ok

    Checking fields in table : 89371wp_m_subscription_transaction -
    transaction_ID - Ok
    transaction_subscription_ID - Ok
    transaction_user_ID - Ok
    transaction_sub_ID - Ok
    transaction_paypal_ID - Ok
    transaction_payment_type - Ok
    transaction_stamp - Ok
    transaction_total_amount - Ok
    transaction_currency - Ok
    transaction_duedate - Ok
    transaction_gateway - Ok
    transaction_note - Ok
    transaction_expires - Ok

    Checking table : 89371wp_m_urlgroups - Ok

    Checking fields in table : 89371wp_m_urlgroups -
    id - Ok
    groupname - Ok
    groupurls - Ok
    isregexp - Ok
    stripquerystring - Ok

    Checking table : 89371wp_m_communications - Ok

    Checking fields in table : 89371wp_m_communications -
    id - Ok
    subject - Ok
    message - Ok
    periodunit - Ok
    periodtype - Ok
    periodprepost - Ok
    lastupdated - Ok
    active - Ok
    periodstamp - Ok

    Checking table : 89371wp_m_pings - Ok

    Checking fields in table : 89371wp_m_pings -
    id - Ok
    pingname - Ok
    pingurl - Ok
    pinginfo - Ok
    pingtype - Ok

    Checking table : 89371wp_m_ping_history - Ok

    Checking fields in table : 89371wp_m_ping_history -
    id - Ok
    ping_id - Ok
    ping_sent - Ok
    ping_info - Ok
    ping_return - Ok

    Checking table : 89371wp_m_levelmeta - Ok

    Checking fields in table : 89371wp_m_levelmeta -
    id - Ok
    level_id - Ok
    meta_key - Ok
    meta_value - Ok
    meta_stamp - Ok

    Checking table : 89371wp_m_subscriptionmeta - Ok

    Checking fields in table : 89371wp_m_subscriptionmeta -
    id - Ok
    sub_id - Ok
    meta_key - Ok
    meta_value - Ok
    meta_stamp - Ok

    Checking table : 89371wp_m_member_payments - Ok

    Checking fields in table : 89371wp_m_member_payments -
    id - Ok
    member_id - Ok
    sub_id - Ok
    level_id - Ok
    level_order - Ok
    paymentmade - Ok
    paymentexpires - Ok

    Checking table : 89371wp_m_coupons - Fixed

    ============================

    When I installed the plugin, I installed it as I normally do, through the PLUGINS Upload option in WP. Not through WPMU Dashboard. I did not FTP the files. Again, I just ran the upload feature in WP to install the plugin. This should have worked properly .. shouldn't it have?

    ============================

    After running the repair, the PHP Error does not seem to be reoccurring.

    Thanks,
    Gary

  • phillcoxon

    Awesome - sounds like it fixed your coupons table up - everything should hopefully work now.

    I suggest opening up a new thread about the Affiliate plugin so that we don't have two entirely different subjects in this thread.

    If you start a new question about the affiliate plugin I can give some feedback as I've used the tips and tricks plugin...

    I'll mark this thread as resolved for now. Please reopen if you have any more questions on the original topic.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.