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’:wink:, require_once(‘wp-load.php’:wink:, require_once(‘wp-config.php’:wink:, require_once(‘wp-settings.php’:wink:, include_once(‘/plugins/membership/membershippremium.php’:wink:, 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’:wink:, require_once(‘wp-config.php’:wink:, require_once(‘wp-settings.php’:wink:, include_once(‘/plugins/membership/membershippremium.php’:wink:, 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

  • phillcoxon
    • The Crimson Coder

    It looks like the coupons table may not have been created properly. Did you have any noticable issues while installing the plugin?

    Did you upload it manually or through the WPMU dashboard?

    It might be worth reinstalling the Membership plugin although that may not fix up any missing tables if they were missed on the original install.

  • Gary M. Gordon
    • Site Builder, Child of Zeus

    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
    • The Crimson Coder

    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.

  • Gary M. Gordon
    • Site Builder, Child of Zeus

    Thanks. I submitted a separate ticket.

    Do you think that the developer of the “Membership” plugin can look into why the problem might have occurred (based upon the way I installed it) so it might not happen again in the future? Or is this not possible?

    Gary

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.