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

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

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. 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

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

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

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

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

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

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

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

Hey @Marc Stridgen Yes, I have a few 3rd party items, but have been installed from day 1 using IP Board, over 2 years ago. No new 3rd party items have been installed since my initial installation. Also, I've checked the file access as best I know how, and the fact that I have no problem dragging and dropping images into this Invision forum tells me it's not the image/file, but something with the way my current community setup reacts when a drag/drop occurs. A few other thoughts (in hopes this may trigger something for you). I have had some MySQL database stability issues. I can't say for sure, but it seems to be a caching issue. I've tried a few different caching plugins, but still experience a MySQL crash once or twice a month. The other thought was that my server storage space has been steadily growing over the past few years. I've run out of space a few times and the hosting company says I'm pushing the limits of the disc storage and I should clean off some files (mostly old backups). Which I have done. But I wonder if perhaps (without my knowing) they put some limiter on the server that might be related to this issue. Most likely not, but I thought I'd raise it here. Otherwise I'm stuck, and don't have any more ideas. If you think of something, let me know. cheers, Todd

Thanks for your response. I've attached one particular file. It's a screenshot from a macbook. Also, I should mention I'm on the latest version - IPS Community Suite 4.6.12.1 Let me know if you need any more details / screenshots from my CPAdmin. Todd oh, sorry you said "zip" attached. Todd sample image drag drop bug.zip

Hello. I have a bug that has been occurring for about 6 months, but it's taken me this long to post about it. Members of my community used to be able to drag and drop images/files from their desktop into a post for easy in post positioning of the image. Now a message pops up (screenshot attached) informing them of the certain file types can be uploaded) Simultaneously with the error box, towards the bottom an info prompt appears saying "Pasted as rich text. paste as plain text instead." see the bottom of the screenshot. The problem is not the file type or size, I've checked that. It seems to think the drag/drop function is a "paste" and "text". And actually, just now, when I dragged and dropped these screenshots into the Invision community - the drag drop worked perfectly. So that confirms the problem is not related to the users computer. I did notice that the same info box pops up saying "pasted as rich text". Here are screenshots of my settings for images on AdminCP. Any help is much appreciated 🙂 thank you. Todd