Lost Premium Subscriptions and can't Extend any Sites

I had to restore my server to default, then restore files and database for my Wordpress multisite. However the premium subscriptions got reset in the process and I can't add days and extend and sites. Do I need to delete a db table or reload the supporter plugin? Ideas?

  • stephenway

    Ok here is the rundown:
    I'm on MediaTemple DV 4
    My server became compromised few weeks ago so I changed all passwords for Plesk and FTP.
    I reverted to Default, server does a backup then reinstalls CentOS and Plesk
    First I SSHed in as root user and moved httpdocs backup to httpdocs in root.
    Then created new database with same name as backup database then create user of same name and password. Then in SSH moved the database files for this database backup to the newly created database.
    All of this was done alongside a support call with MediaTemple.

    Once this was done, everything in my Wordpress seemed to be working, but I didn't notice supporter subscriptions were missing.

    Thanks for your help guys!

  • stephenway

    @bigonroad Yes, all subscriptions are visible in "All Sites"

    @Phil Tables in Wordpress Multisite Database
    wp_2_agm_maps
    wp_2_commentmeta
    wp_2_comments
    wp_2_events_answer
    wp_2_events_attendee
    wp_2_events_category_detail
    wp_2_events_category_rel
    wp_2_events_detail
    wp_2_events_discount_codes
    wp_2_events_discount_rel
    wp_2_events_email
    wp_2_events_locale
    wp_2_events_locale_rel
    wp_2_events_personnel_rel
    wp_2_events_prices
    wp_2_events_qst_group
    wp_2_events_qst_group_rel
    wp_2_events_question
    wp_2_events_start_end
    wp_2_events_venue
    wp_2_events_venue_rel
    wp_2_links
    wp_2_options
    wp_2_postmeta
    wp_2_posts
    wp_2_terms
    wp_2_term_relationships
    wp_2_term_taxonomy
    wp_2_wpb_content
    wp_3_commentmeta
    wp_3_comments
    wp_3_links
    wp_3_options
    wp_3_postmeta
    wp_3_posts
    wp_3_terms
    wp_3_term_relationships
    wp_3_term_taxonomy
    wp_4_commentmeta
    wp_4_comments
    wp_4_links
    wp_4_options
    wp_4_postmeta
    wp_4_posts
    wp_4_terms
    wp_4_term_relationships
    wp_4_term_taxonomy
    wp_5_commentmeta
    wp_5_comments
    wp_5_links
    wp_5_options
    wp_5_place_expire_session
    wp_5_postmeta
    wp_5_posts
    wp_5_price
    wp_5_ratings
    wp_5_terms
    wp_5_term_relationships
    wp_5_term_taxonomy
    wp_6_agm_maps
    wp_6_commentmeta
    wp_6_comments
    wp_6_links
    wp_6_options
    wp_6_postmeta
    wp_6_posts
    wp_6_rg_form
    wp_6_rg_form_meta
    wp_6_rg_form_view
    wp_6_rg_lead
    wp_6_rg_lead_detail
    wp_6_rg_lead_detail_long
    wp_6_rg_lead_notes
    wp_6_terms
    wp_6_term_relationships
    wp_6_term_taxonomy
    wp_6_wpb_content
    wp_8_commentmeta
    wp_8_comments
    wp_8_links
    wp_8_ngg_album
    wp_8_ngg_gallery
    wp_8_ngg_pictures
    wp_8_options
    wp_8_postmeta
    wp_8_posts
    wp_8_terms
    wp_8_term_relationships
    wp_8_term_taxonomy
    wp_9_commentmeta
    wp_9_comments
    wp_9_links
    wp_9_options
    wp_9_postmeta
    wp_9_posts
    wp_9_rg_form
    wp_9_rg_form_meta
    wp_9_rg_form_view
    wp_9_rg_lead
    wp_9_rg_lead_detail
    wp_9_rg_lead_detail_long
    wp_9_rg_lead_notes
    wp_9_terms
    wp_9_term_relationships
    wp_9_term_taxonomy
    wp_12_commentmeta
    wp_12_comments
    wp_12_links
    wp_12_options
    wp_12_postmeta
    wp_12_posts
    wp_12_terms
    wp_12_term_relationships
    wp_12_term_taxonomy
    wp_13_commentmeta
    wp_13_comments
    wp_13_links
    wp_13_options
    wp_13_postmeta
    wp_13_posts
    wp_13_terms
    wp_13_term_relationships
    wp_13_term_taxonomy
    wp_14_commentmeta
    wp_14_comments
    wp_14_links
    wp_14_options
    wp_14_postmeta
    wp_14_posts
    wp_14_terms
    wp_14_term_relationships
    wp_14_term_taxonomy
    wp_15_commentmeta
    wp_15_comments
    wp_15_links
    wp_15_options
    wp_15_postmeta
    wp_15_posts
    wp_15_terms
    wp_15_term_relationships
    wp_15_term_taxonomy
    wp_16_commentmeta
    wp_16_comments
    wp_16_links
    wp_16_options
    wp_16_postmeta
    wp_16_posts
    wp_16_terms
    wp_16_term_relationships
    wp_16_term_taxonomy
    wp_20_commentmeta
    wp_20_comments
    wp_20_links
    wp_20_options
    wp_20_postmeta
    wp_20_posts
    wp_20_terms
    wp_20_term_relationships
    wp_20_term_taxonomy
    wp_23_commentmeta
    wp_23_comments
    wp_23_Display_slider_menu
    wp_23_links
    wp_23_options
    wp_23_postmeta
    wp_23_posts
    wp_23_terms
    wp_23_term_relationships
    wp_23_term_taxonomy
    wp_26_acf_fields
    wp_26_acf_options
    wp_26_acf_values
    wp_26_commentmeta
    wp_26_comments
    wp_26_easymail_sendings
    wp_26_easymail_subscribers
    wp_26_easymail_trackings
    wp_26_links
    wp_26_options
    wp_26_pageflip
    wp_26_pageflip_gallery
    wp_26_pageflip_img
    wp_26_postmeta
    wp_26_posts
    wp_26_rg_form
    wp_26_rg_form_meta
    wp_26_rg_form_view
    wp_26_rg_lead
    wp_26_rg_lead_detail
    wp_26_rg_lead_detail_long
    wp_26_rg_lead_notes
    wp_26_terms
    wp_26_term_relationships
    wp_26_term_taxonomy
    wp_26_wpb_content
    wp_27_commentmeta
    wp_27_comments
    wp_27_easymail_sendings
    wp_27_easymail_subscribers
    wp_27_easymail_trackings
    wp_27_links
    wp_27_m_membership_news
    wp_27_options
    wp_27_pageflip
    wp_27_pageflip_gallery
    wp_27_pageflip_img
    wp_27_postmeta
    wp_27_posts
    wp_27_rg_form
    wp_27_rg_form_meta
    wp_27_rg_form_view
    wp_27_rg_lead
    wp_27_rg_lead_detail
    wp_27_rg_lead_detail_long
    wp_27_rg_lead_notes
    wp_27_terms
    wp_27_term_relationships
    wp_27_term_taxonomy
    wp_27_wpb_content
    wp_28_commentmeta
    wp_28_comments
    wp_28_links
    wp_28_options
    wp_28_postmeta
    wp_28_posts
    wp_28_terms
    wp_28_term_relationships
    wp_28_term_taxonomy
    wp_29_commentmeta
    wp_29_comments
    wp_29_Display_main_menu
    wp_29_Display_slider_menu
    wp_29_links
    wp_29_options
    wp_29_postmeta
    wp_29_posts
    wp_29_rg_form
    wp_29_rg_form_meta
    wp_29_rg_form_view
    wp_29_rg_lead
    wp_29_rg_lead_detail
    wp_29_rg_lead_detail_long
    wp_29_rg_lead_notes
    wp_29_terms
    wp_29_term_relationships
    wp_29_term_taxonomy
    wp_31_commentmeta
    wp_31_comments
    wp_31_invoice_log
    wp_31_invoice_main

    wp_31_invoice_meta
    wp_31_links
    wp_31_options
    wp_31_postmeta
    wp_31_posts
    wp_31_terms
    wp_31_term_relationships
    wp_31_term_taxonomy
    wp_32_commentmeta
    wp_32_comments
    wp_32_links
    wp_32_m_communications
    wp_32_m_levelmeta
    wp_32_m_membership_levels
    wp_32_m_membership_news
    wp_32_m_membership_relationships
    wp_32_m_membership_rules
    wp_32_m_member_payments
    wp_32_m_pings
    wp_32_m_ping_history
    wp_32_m_subscriptionmeta
    wp_32_m_subscriptions
    wp_32_m_subscriptions_levels
    wp_32_m_subscription_transaction
    wp_32_m_urlgroups
    wp_32_options
    wp_32_postmeta
    wp_32_posts
    wp_32_terms
    wp_32_term_relationships
    wp_32_term_taxonomy
    wp_33_commentmeta
    wp_33_comments
    wp_33_links
    wp_33_options
    wp_33_postmeta
    wp_33_posts
    wp_33_terms
    wp_33_term_relationships
    wp_33_term_taxonomy
    wp_34_agm_maps
    wp_34_commentmeta
    wp_34_comments
    wp_34_links
    wp_34_options
    wp_34_postmeta
    wp_34_posts
    wp_34_rg_form
    wp_34_rg_form_meta
    wp_34_rg_form_view
    wp_34_rg_lead
    wp_34_rg_lead_detail
    wp_34_rg_lead_detail_long
    wp_34_rg_lead_notes
    wp_34_terms
    wp_34_term_relationships
    wp_34_term_taxonomy
    wp_34_wpb_content
    wp_35_commentmeta
    wp_35_comments
    wp_35_links
    wp_35_options
    wp_35_postmeta
    wp_35_posts
    wp_35_terms
    wp_35_term_relationships
    wp_35_term_taxonomy
    wp_36_commentmeta
    wp_36_comments
    wp_36_links
    wp_36_options
    wp_36_postmeta
    wp_36_posts
    wp_36_rg_form
    wp_36_rg_form_meta
    wp_36_rg_form_view
    wp_36_rg_lead
    wp_36_rg_lead_detail
    wp_36_rg_lead_detail_long
    wp_36_rg_lead_notes
    wp_36_terms
    wp_36_term_relationships
    wp_36_term_taxonomy
    wp_37_commentmeta
    wp_37_comments
    wp_37_links
    wp_37_options
    wp_37_postmeta
    wp_37_posts
    wp_37_terms
    wp_37_term_relationships
    wp_37_term_taxonomy
    wp_add_new_users_queue
    wp_affiliatedata
    wp_affiliatereferrers
    wp_blogs
    wp_blog_versions
    wp_commentmeta
    wp_comments
    wp_contact_form_7
    wp_domain_mapping
    wp_domain_mapping_logins
    wp_forums
    wp_forums_posts
    wp_forums_topics
    wp_friends
    wp_gallery_slides
    wp_links
    wp_messages
    wp_mp_products
    wp_mp_terms
    wp_mp_term_relationships
    wp_m_communications
    wp_m_levelmeta
    wp_m_membership_levels
    wp_m_membership_news
    wp_m_membership_relationships
    wp_m_membership_rules
    wp_m_member_payments
    wp_m_pings
    wp_m_ping_history
    wp_m_subscriptionmeta
    wp_m_subscriptions
    wp_m_subscriptions_levels
    wp_m_subscription_transaction
    wp_m_urlgroups
    wp_options
    wp_postmeta
    wp_posts
    wp_registration_log
    wp_sent_messages
    wp_signups
    wp_site
    wp_sitemeta
    wp_site_posts
    wp_site_terms
    wp_site_term_relationships
    wp_support_faq
    wp_support_faq_cats
    wp_support_tickets
    wp_support_tickets_cats
    wp_support_tickets_messages
    wp_terms
    wp_term_counts
    wp_term_relationships
    wp_term_taxonomy
    wp_upgrades_credits
    wp_upgrades_features
    wp_upgrades_log
    wp_upgrades_packages
    wp_upgrades_package_status
    wp_usermeta
    wp_users
    wp_ust

  • stephenway

    @Phil, I've located 'wp_supporters, wp_supporter_signup_stats, wp_supporter_daily_stats, and wp_supporter_ads' tables in my last backup. I think at this point I am going to look for a way to migrate these tables to my live database as I have never done anything too complicated with the database before. Let me know what you think is best?

    @Mustafa, var/lib/mysql is chmod 755, I restarted the server a couple days ago so it shouldn't make a difference at this point unless your asking me to change the octal.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.