We've started receiving "Tablespace is missing for a table" mysql errors for our wpforo_profiles table. Running check table in phpmyadmin gives:
- Warning Tablespace is missing for table 'db_name/prefix_wpforo_profiles'
- Error Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
- Error Corrupt
If we can't fix this issue and need to restore from backup, do we need to be careful about synchronization issues between this table and any other tables containing user data? Thanks.
Basically what I'm asking is, if we need to replace the wpforo_profiles table from backup, do we also need to replace other wpforo tables - and maybe even other Wordpress tables - at the same time, to ensure consistency between our data?
HI @upstartdm,
Press Synch User Profiles button from wpForo > Overview, after replacing the table with the backup.
Thanks Chris. Is it possible to just replace wpforo_profiles with an empty table and then synch the user profiles? Would that work? Otherwise we're going to need to replace the entire db from backup and lose some other changes/content.
You can do that, but note that Users would lose their profile fields information, for Example: Avatar, Signature, Networks, and others.
It also can affect on the Usergroups, if Role-Usergroup Synchronization option is disabled.
If the option is enabled, the Usergroups would be synched with WordPress user Roles by default.
@chris Thanks, yes, the avatars and sigs would be an issue for us. We'll restore from the latest backup and synch.
I've just tried this and I think the answer is no, this won't work. It's possible to create an empty table and synch the profiles successfully but there's a lot of data which would previously have been in the wpforo_profiles table which is missing.
