Notifications
Clear all

[Closed] Tablespace is missing for a table

8 Posts
2 Users
1 Reactions
1,454 Views
Posts: 50
Topic starter
(@upstartdm)
Trusted Member
Joined: 5 years ago

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.

Topic Tags
7 Replies
Posts: 50
Topic starter
(@upstartdm)
Trusted Member
Joined: 5 years ago

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?

Chris
Posts: 3627
(@chris)
Famed Member
Joined: 3 years ago

HI @upstartdm,

Press Synch User Profiles button from wpForo > Overview, after replacing the table with the backup.

Posts: 50
Topic starter
(@upstartdm)
Trusted Member
Joined: 5 years ago

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.

2 Replies
Chris
(@chris)
Joined: 3 years ago

Famed Member
Posts: 3627

@upstartdm,

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.

(@upstartdm)
Joined: 5 years ago

Trusted Member
Posts: 50

@chris Thanks, yes, the avatars and sigs would be an issue for us. We'll restore from the latest backup and synch.

Posts: 50
Topic starter
(@upstartdm)
Trusted Member
Joined: 5 years ago

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.

1 Reply
Chris
(@chris)
Joined: 3 years ago

Famed Member
Posts: 3627

@upstartdm,

Backup would work for you if you have one.