Upgrade & Configuration Error

[TODD MCCARTY]

Hello, 

I upgraded to the newest version. The system checker had all green checks, but mentioned the recommendation to upgrade to PHP 8.0. (I have not done this as I know it will create issues I cannot manage right now, and my main concern is getting my community up and going and take care of my customers/community).
Initially there were no problems with my upgrade. I checked and everything was working normally. 
But when I woke up the next morning and checked I had an error and several community members saying the community is broken.  I've been having some other issues related to MySQL. And usually I have been able to get the community back up and running by using terminal and doing a stop/start of the MySQL database. 
But that didn't work. 

Here is the error I am getting:

here is the full pasted text:
ELECT map_item_id, map_member_id FROM `core_item_member_map` WHERE map_class='IPS\forums\Topic' AND ( map_item_id IN(5,674,656,626,636,615,633,613,616,488,446,609,612,611,438,420,587,602,603,601,517,578,583,569,574) )
IPS\Db\Exception: Table 'bandbldr_wp365.core_item_member_map' doesn't exist in engine (1932)
#0 /home/bandbldr/public_html/community/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*bandbldr_wp36...', Array, true)
#1 /home/bandbldr/public_html/community/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 /home/bandbldr/public_html/community/system/Node/Statistics.php(59): iterator_to_array(Object(IPS\Db\Select))
#4 /home/bandbldr/public_html/community/system/Node/Statistics.php(160): IPS\forums\_Forum->authorsPostedIn(Array)
#5 /home/bandbldr/public_html/community/system/Helpers/Table/Content.php(499): IPS\forums\_Forum->contentPostedIn(Object(IPS\Member), Array)
#6 /home/bandbldr/public_html/community/system/Helpers/Table/Table.php(494): IPS\Helpers\Table\_Content->getRows(Array)
#7 /home/bandbldr/public_html/community/applications/forums/modules/front/forums/forums.php(568): IPS\Helpers\Table\_Table->__toString()
#8 /home/bandbldr/public_html/community/applications/forums/modules/front/forums/forums.php(38): IPS\forums\modules\front\forums\_forums->_forum(Object(IPS\forums\Forum))
#9 /home/bandbldr/public_html/community/system/Dispatcher/Controller.php(118): IPS\forums\modules\front\forums\_forums->manage()
#10 /home/bandbldr/public_html/community/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#11 /home/bandbldr/public_html/community/index.php(13): IPS\_Dispatcher->run()
#12 {main}

 

When I try to look on the IPBoard CPAdmin it shows a similar error - but different in some aspects. 
I couldn't make any sense of it.

Here is the pasted text: 
SELECT reply_id, reply_title, reply_added_by, reply_enabled, core_permission_index.perm_id, core_permission_index.perm_view FROM `core_editor_stored_replies` LEFT JOIN `core_permission_index` ON core_permission_index.app='core' AND core_permission_index.perm_type='editorStoredReplies' AND core_permission_index.perm_type_id=core_editor_stored_replies.reply_id 
IPS\Db\Exception: Table 'bandbldr_wp365.core_editor_stored_replies' doesn't exist in engine (1932)
#0 /home/bandbldr/public_html/community/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*bandbldr_wp36...', Array, true)
#1 /home/bandbldr/public_html/community/system/Db/Select.php(286): IPS\Db\_Select->runQuery()
#2 /home/bandbldr/public_html/community/applications/core/sources/StoredReplies/StoredReplies.php(223): IPS\Db\_Select->setKeyField('reply_id')
#3 /home/bandbldr/public_html/community/system/Helpers/Form/Editor.php(126): IPS\core\_StoredReplies::getStore()
#4 /home/bandbldr/public_html/community/applications/core/modules/admin/settings/general.php(54): IPS\Helpers\Form\_Editor->__construct('site_offline_me...', '', false, Array, NULL, NULL, NULL, 'site_offline_me...')
#5 /home/bandbldr/public_html/community/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\settings\_general->manage()
#6 /home/bandbldr/public_html/community/applications/core/modules/admin/settings/general.php(38): IPS\Dispatcher\_Controller->execute()
#7 /home/bandbldr/public_html/community/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\settings\_general->execute()
#8 /home/bandbldr/public_html/community/admin/index.php(13): IPS\_Dispatcher->run()
#9 {main}

Can you give me some pointers?  I'd like to get my community back up and running ASAP, and solve some of the ongoing issues once and for all.

many thanks,

Todd
 

[TODD MCCARTY]

also, this seems important so I wanted to post it here.

[Marc Stridgen]

As mentioned in the message there, you are actually missing tables 

IPS\Db\Exception: Table 'bandbldr_wp365.core_item_member_map' doesn't exist in engine (1932)

and

IPS\Db\Exception: Table 'bandbldr_wp365.core_editor_stored_replies' doesn't exist in engine (1932)

It may be those tables are crashed, or missing entirely. If they are missing you will need to restore those from a working backup. If crashed, your hosting company would need to assist you with this.

[TODD MCCARTY]

Hey @Marc Stridgen

Thanks for the response. Perhaps the table was there before the upgrade, then after the upgrade it was missing or incompatible with the new version?   But it's strange that it wouldn't serve me the error immediately after the upgrade.

If I don't have backups, is there a way for somebody to create/build the necessary table(s)? Or are these tables automatically created?   

The reason I posted here, was because I spoke to my hosting company and they said I should ask Invision. I discussed further with a developer who has helped me from time to time. He said he couldn't find anything about how to fix this issue and he also said I should post here and ask. 

Hmm.  I hate to go back to them empty handed. They knew the table was missing. 

I did a "repair database" to see if that might clear up something and it uncovered a few more missing tables. (copy paste below)
 

Repairing bandbldr_wp365

bandbldr_wp365.calendar_calendars                  OK
bandbldr_wp365.calendar_event_comments             OK
bandbldr_wp365.calendar_event_reminders            OK
bandbldr_wp365.calendar_event_reviews              OK
bandbldr_wp365.calendar_event_rsvp                 OK
bandbldr_wp365.calendar_events                     OK
bandbldr_wp365.calendar_import_feeds               OK
bandbldr_wp365.calendar_import_map                 OK
bandbldr_wp365.calendar_venues                     OK
bandbldr_wp365.core_achievements_log               OK
bandbldr_wp365.core_achievements_log_milestones
Error    : Table 'bandbldr_wp365.core_achievements_log_milestones' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_achievements_rules             OK
bandbldr_wp365.core_acp_notifcations_dismissals    OK
bandbldr_wp365.core_acp_notifications              OK
bandbldr_wp365.core_acp_notifications_preferences  OK
bandbldr_wp365.core_acp_search_index               OK
bandbldr_wp365.core_acp_tab_order                  OK
bandbldr_wp365.core_acronyms                       OK
bandbldr_wp365.core_admin_login_logs               OK
bandbldr_wp365.core_admin_logs                     OK
bandbldr_wp365.core_admin_permission_rows          OK
bandbldr_wp365.core_advertisements                 OK
bandbldr_wp365.core_alerts                         OK
bandbldr_wp365.core_alerts_seen
Error    : Table 'bandbldr_wp365.core_alerts_seen' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_announcements                  OK
bandbldr_wp365.core_anonymous_posts                OK
bandbldr_wp365.core_api_keys                       OK
bandbldr_wp365.core_api_logs                       OK
bandbldr_wp365.core_api_webhook_fires              OK
bandbldr_wp365.core_api_webhooks                   OK
bandbldr_wp365.core_applications                   OK
bandbldr_wp365.core_attachments                    OK
bandbldr_wp365.core_attachments_map                OK
bandbldr_wp365.core_automatic_moderation_pending   OK
bandbldr_wp365.core_automatic_moderation_rules     OK
bandbldr_wp365.core_automatic_moderation_types     OK
bandbldr_wp365.core_badges                         OK
bandbldr_wp365.core_banfilters                     OK
bandbldr_wp365.core_bulk_mail                      OK
bandbldr_wp365.core_cache                          OK
bandbldr_wp365.core_club_pages                     OK
bandbldr_wp365.core_clubs                          OK
bandbldr_wp365.core_clubs_fields                   OK
bandbldr_wp365.core_clubs_fieldvalues              OK
bandbldr_wp365.core_clubs_memberships              OK
bandbldr_wp365.core_clubs_node_map                 OK
bandbldr_wp365.core_content_featured
Error    : Table 'bandbldr_wp365.core_content_featured' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_content_meta                   OK
bandbldr_wp365.core_deletion_log                   OK
bandbldr_wp365.core_dev                            OK
bandbldr_wp365.core_edit_history                   OK
bandbldr_wp365.core_editor_stored_replies
Error    : Table 'bandbldr_wp365.core_editor_stored_replies' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_email_templates                OK
bandbldr_wp365.core_emoticons                      OK
bandbldr_wp365.core_error_logs                     OK
bandbldr_wp365.core_file_logs                      OK
bandbldr_wp365.core_file_storage                   OK
bandbldr_wp365.core_files                          OK
bandbldr_wp365.core_files_temp                     OK
bandbldr_wp365.core_follow                         OK
bandbldr_wp365.core_follow_count_cache
Error    : Table 'bandbldr_wp365.core_follow_count_cache' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_geoip_cache                    OK
bandbldr_wp365.core_googleauth_used_codes          OK
bandbldr_wp365.core_group_promotions               OK
bandbldr_wp365.core_groups                         OK
bandbldr_wp365.core_hooks                          OK
bandbldr_wp365.core_ignored_users                  OK
bandbldr_wp365.core_image_scanner_logs             OK
bandbldr_wp365.core_incoming_emails                OK
bandbldr_wp365.core_ips_bulletins                  OK
bandbldr_wp365.core_item_markers                   OK
bandbldr_wp365.core_item_member_map
Error    : Table 'bandbldr_wp365.core_item_member_map' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_item_redirect
Error    : Table 'bandbldr_wp365.core_item_redirect' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_item_statistics_cache
Error    : Table 'bandbldr_wp365.core_item_statistics_cache' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_javascript                     OK
bandbldr_wp365.core_leaders                        OK
bandbldr_wp365.core_leaders_groups                 OK
bandbldr_wp365.core_log                            OK
bandbldr_wp365.core_login_links                    OK
bandbldr_wp365.core_login_methods                  OK
bandbldr_wp365.core_mail_error_logs                OK
bandbldr_wp365.core_marketplace_tokens             OK
bandbldr_wp365.core_member_badges                  OK
bandbldr_wp365.core_member_history                 OK
bandbldr_wp365.core_member_ranks                   OK
bandbldr_wp365.core_member_recognize
Error    : Table 'bandbldr_wp365.core_member_recognize' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_member_status_replies          OK
bandbldr_wp365.core_member_status_updates          OK
bandbldr_wp365.core_members                        OK
bandbldr_wp365.core_members_feature_seen           OK
bandbldr_wp365.core_members_features               OK
bandbldr_wp365.core_members_known_devices          OK
bandbldr_wp365.core_members_known_ip_addresses     OK
bandbldr_wp365.core_members_logins
Error    : Table 'bandbldr_wp365.core_members_logins' doesn't exist in engine
status   : Operation failed
bandbldr_wp365.core_members_warn_actions           OK
bandbldr_wp365.core_members_warn_logs              OK

 

this leads me to believe that they existed before but somehow were removed.  Any ideas on how that could happen?  
So if somehow I can get those tables re-created, are you confident that it would fix the issue and get the community back up and running?
 

In the interest of time, it would be much appreciated if you could take a look under the hood? You mentioned to me in another post here - that you couldn't get on my community ACP because the credentials are not correct.  Can you tell me where I can find that in the AdminCP?  I looked everywhere and couldn't find where I update those details. 

thanks,

Todd


 

[Marc Stridgen]

Im not sure where you get the impression there that they were removed. What actually looks to be the case there is that there is an issue with your mysql instance. It is looking to repair tables in which the physical files are not present. After all, if they are not there, why would it be trying to repair them otherwise? There is only your hosting company that can resolve that, and only a restore from backup will correct the issue at this point. Its quite  few tables you are missing there

[TODD MCCARTY]

I figured they were part of the existing database and the repair the database tool couldn't find them. And the only new action that had happened since then was the update of the IPBoard software. So I figured that new software installation removed those tables. 

Is there something else that would cause those tables to be removed?

If I don't have a backup, then what can my hosting company do?

Does this mean my 3 years worth of community is destroyed? Or can tables be re-built?

Todd
 

[Marc Stridgen]

There is an issue with your mysql instance is what has caused your issue. The problem is the tables must exist at least in some form as your mysql instance is trying to repair them. It wouldnt know of their existence otherwise.

You could attempt to get blank copies of those tables from another instance if you wanted to see if you can create them. However you will be missing data from it. Have you contacted your hosting company to see if they have backups themselves?

[TODD MCCARTY]

Yes I already discussed the backup with my hosting company.
the tech said, "oh, I see you don't have our add-on backup plan". 
I replied "I didn't know you offered a backup plan. I use a daily backup plugin, will that help?"
the tech replied "no, that only backs up wordpress files". 
They do not have backups. 

Todd

[Marc Stridgen]

You could create a test instance and copy the empty versions of the tables as mentioned, but of course there is no guarantee you wont have issues. 

[TODD MCCARTY]

OK, is this something my hosting company can do?, or is it more of a "web developer" skill?

Do you have any formate for an "empty version", or will the host/developers know what that is?

Todd
 

[Marc Stridgen]

I can certainly script out those tables and send them to you (I will do that shortly). You can then attempt to restore them that way and see how you go

[Marc Stridgen]

Feel free to try this. Note, this is outside the scope of support.

--
-- Table structure for table `core_achievements_log_milestones`
--

CREATE TABLE `core_achievements_log_milestones` (
  `milestone_id` bigint(20) UNSIGNED NOT NULL,
  `milestone_member_id` bigint(20) UNSIGNED NOT NULL,
  `milestone_rule` int(10) UNSIGNED NOT NULL,
  `milestone_log_id` bigint(20) UNSIGNED NOT NULL,
  `milestone_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'subject'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_alerts_seen`
--

CREATE TABLE `core_alerts_seen` (
  `seen_alert_id` int(11) NOT NULL,
  `seen_member_id` int(11) NOT NULL,
  `seen_date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_content_featured`
--

CREATE TABLE `core_content_featured` (
  `feature_id` int(11) NOT NULL,
  `feature_content_id` int(11) NOT NULL DEFAULT 0,
  `feature_content_class` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `feature_content_author` int(11) NOT NULL DEFAULT 0,
  `feature_date` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_editor_stored_replies`
--

CREATE TABLE `core_editor_stored_replies` (
  `reply_id` int(11) NOT NULL,
  `reply_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reply_text` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `reply_added_by` int(11) NOT NULL,
  `reply_enabled` tinyint(3) UNSIGNED DEFAULT 0,
  `reply_position` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_follow_count_cache`
--

CREATE TABLE `core_follow_count_cache` (
  `id` bigint(20) NOT NULL DEFAULT 0,
  `class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `count` int(11) NOT NULL DEFAULT 0,
  `added` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_item_member_map`
--

CREATE TABLE `core_item_member_map` (
  `map_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `map_item_id` int(11) NOT NULL DEFAULT 0,
  `map_member_id` int(11) DEFAULT 0,
  `map_latest_date` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_item_redirect`
--

CREATE TABLE `core_item_redirect` (
  `redirect_id` int(11) NOT NULL,
  `redirect_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect_item_id` int(11) NOT NULL DEFAULT 0,
  `redirect_new_item_id` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_item_statistics_cache`
--

CREATE TABLE `core_item_statistics_cache` (
  `cache_id` int(11) NOT NULL,
  `cache_class` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `cache_item_id` int(11) NOT NULL DEFAULT 0,
  `cache_added` int(11) NOT NULL DEFAULT 0,
  `cache_contents` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_members_logins`
--

CREATE TABLE `core_members_logins` (
  `member_id` int(11) NOT NULL,
  `member_date` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `member_timestamp` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_member_recognize`
--

CREATE TABLE `core_member_recognize` (
  `r_id` int(11) NOT NULL,
  `r_member_id` int(11) NOT NULL,
  `r_content_class` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `r_content_id` int(11) NOT NULL DEFAULT 0,
  `r_message` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `r_added` int(11) NOT NULL DEFAULT 0,
  `r_badge` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `r_points` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `r_given_by` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `r_public` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Show this message publicly?'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `core_achievements_log_milestones`
--
ALTER TABLE `core_achievements_log_milestones`
  ADD PRIMARY KEY (`milestone_id`),
  ADD UNIQUE KEY `lookup` (`milestone_member_id`,`milestone_rule`,`milestone_type`);

--
-- Indexes for table `core_alerts_seen`
--
ALTER TABLE `core_alerts_seen`
  ADD UNIQUE KEY `alert_member` (`seen_alert_id`,`seen_member_id`);

--
-- Indexes for table `core_content_featured`
--
ALTER TABLE `core_content_featured`
  ADD PRIMARY KEY (`feature_id`),
  ADD KEY `feature_lookup` (`feature_content_id`,`feature_content_class`,`feature_content_author`);

--
-- Indexes for table `core_editor_stored_replies`
--
ALTER TABLE `core_editor_stored_replies`
  ADD PRIMARY KEY (`reply_id`);

--
-- Indexes for table `core_follow_count_cache`
--
ALTER TABLE `core_follow_count_cache`
  ADD UNIQUE KEY `id_class` (`id`,`class`(171)),
  ADD KEY `added` (`added`);

--
-- Indexes for table `core_item_member_map`
--
ALTER TABLE `core_item_member_map`
  ADD UNIQUE KEY `map_unique` (`map_class`(171),`map_item_id`,`map_member_id`),
  ADD KEY `map_lookup` (`map_item_id`,`map_member_id`),
  ADD KEY `map_member_id` (`map_member_id`);

--
-- Indexes for table `core_item_redirect`
--
ALTER TABLE `core_item_redirect`
  ADD PRIMARY KEY (`redirect_id`),
  ADD KEY `redirect_lookup` (`redirect_class`(181),`redirect_item_id`),
  ADD KEY `redirect_delete` (`redirect_class`(181),`redirect_new_item_id`);

--
-- Indexes for table `core_item_statistics_cache`
--
ALTER TABLE `core_item_statistics_cache`
  ADD PRIMARY KEY (`cache_id`),
  ADD UNIQUE KEY `cache_lookup` (`cache_class`,`cache_item_id`),
  ADD KEY `cache_added` (`cache_added`);

--
-- Indexes for table `core_members_logins`
--
ALTER TABLE `core_members_logins`
  ADD UNIQUE KEY `lookup` (`member_id`,`member_date`);

--
-- Indexes for table `core_member_recognize`
--
ALTER TABLE `core_member_recognize`
  ADD PRIMARY KEY (`r_id`),
  ADD KEY `r_member_id` (`r_member_id`),
  ADD KEY `r_content` (`r_content_class`,`r_content_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `core_achievements_log_milestones`
--
ALTER TABLE `core_achievements_log_milestones`
  MODIFY `milestone_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `core_content_featured`
--
ALTER TABLE `core_content_featured`
  MODIFY `feature_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `core_editor_stored_replies`
--
ALTER TABLE `core_editor_stored_replies`
  MODIFY `reply_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `core_item_redirect`
--
ALTER TABLE `core_item_redirect`
  MODIFY `redirect_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `core_item_statistics_cache`
--
ALTER TABLE `core_item_statistics_cache`
  MODIFY `cache_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `core_member_recognize`
--
ALTER TABLE `core_member_recognize`
  MODIFY `r_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

 

[TODD MCCARTY]

Hey @Marc Stridgen

I've been doing these UpDraft backups for years thinking all along that my MySQL database was being backed up. Only today did I learn that UpDraft only backs up WP files.  
But look at this screenshot... Is there a chance that the "database" I point to are the backups that have those tables?  
I tried to download/unpack those but couldn't find anything that looked like php files. 
See screenshot of the backup plugin and let me know what you think?

thanks,

Todd

[Marc Stridgen]

Just now, TODD MCCARTY said:

Hey @Marc Stridgen

I've been doing these UpDraft backups for years thinking all along that my MySQL database was being backed up. Only today did I learn that UpDraft only backs up WP files.  
But look at this screenshot... Is there a chance that the "database" I point to are the backups that have those tables?  
I tried to download/unpack those but couldn't find anything that looked like php files. 
See screenshot of the backup plugin and let me know what you think?

thanks,

Todd

There is no way I would know if those are your mysql database backups for your IPS site. You would not see PHP files on a mysql backup

[TODD MCCARTY]

1 minute ago, Marc Stridgen said:

Feel free to try this. Note, this is outside the scope of support.

This is much appreciated @Marc Stridgen  Above and beyond.  
I will pass this along to my host tech and see if he can fix it.  

I do not know what to do with it myself.  
I appreciate you preparing this. thanks again.

 

1 minute ago, Marc Stridgen said:

There is no way I would know if those are your mysql database backups for your IPS site. You would not see PHP files on a mysql backup

and fair enough. It's above my head (obviously 😂)  But just thought I would try, in the case that it would save you from creating the empty tables. 

I will update this thread after either my host tech or developer implements the empty tables.


Todd

[Marc Stridgen]

It is worth asking, have you ever considered our cloud solution? If you are not knowlegable in anything related to your hosting, including backups, it may be a much better direction for you. You would never need to think about things like this again. You just think about running your site instead

[TODD MCCARTY]

Hey @Marc Stridgen
There is a membership education company (Membership Academy) that turned me on to IP Board 4 years ago. I loved using it in their community, and wanted to implement it when I built mine (launched October 2019). 
At the time, I told my developer I want it setup the exact same way Membership Academy had theirs setup. And so he did it.  
I really didn't consider any other option, and I certainly never thought I would be on with tech support or this forum. None of this stuff ever occurred to me. I set out to build a business in education, not mess with tech. I think the reason my developer hasn't been involved is simply because of the support security not allowing him to do tech support on my behalf. Somehow I was the only one that could communicate with support. 

So is it possible to use the Cloud solution at this point?  Or would I lose my 3 years of community activity in the process of transferring?  I really can't do that, because the community discussions are tied directly to the course/academy. It's become a resource people count on and continue to reference.  

If you tell me it's easy and I can transfer everything to your Cloud service and keep the stuff I have, then I'm ready to go.  
What are the requirements?

Todd

[Marc Stridgen]

Yes, your current community can indeed be transferred over to our cloud environment. I will get a ticket created for you for our sales team, who are better placed to discuss specifics with you. Based on what you have said there, you can then simply concentrate on running your business, rather than thinking about backups, mysql etc. 

[TODD MCCARTY]

Thank you for posing this option @Marc Stridgen
I hope it allows me to do just that.  Look forward to hearing from the sales team.
Todd

[Marc Stridgen]

No problem at all, Todd.