Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
TODD MCCARTY Posted August 16, 2022 Posted August 16, 2022 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 Posted August 16, 2022 Author Posted August 16, 2022 also, this seems important so I wanted to post it here.
Marc Posted August 16, 2022 Posted August 16, 2022 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 1
TODD MCCARTY Posted August 16, 2022 Author Posted August 16, 2022 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 Posted August 16, 2022 Posted August 16, 2022 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 1
TODD MCCARTY Posted August 16, 2022 Author Posted August 16, 2022 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 Posted August 16, 2022 Posted August 16, 2022 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 1
TODD MCCARTY Posted August 16, 2022 Author Posted August 16, 2022 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 Posted August 16, 2022 Posted August 16, 2022 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 Posted August 16, 2022 Author Posted August 16, 2022 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 Posted August 16, 2022 Posted August 16, 2022 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 TODD MCCARTY 1
Marc Posted August 16, 2022 Posted August 16, 2022 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 and tnn 2
TODD MCCARTY Posted August 16, 2022 Author Posted August 16, 2022 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 Posted August 16, 2022 Posted August 16, 2022 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
TODD MCCARTY Posted August 16, 2022 Author Posted August 16, 2022 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 Posted August 16, 2022 Posted August 16, 2022 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 Posted August 16, 2022 Author Posted August 16, 2022 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 Posted August 16, 2022 Posted August 16, 2022 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 1
TODD MCCARTY Posted August 16, 2022 Author Posted August 16, 2022 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
Recommended Posts