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

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

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