Notifications
Clear all

wpForo 1.x.x [Solved] URGENT: Lost forums/profile synchronization

5 Posts
2 Users
0 Likes
559 Views
Upstart DM
Posts: 34
Topic starter
(@upstartdm)
Trusted Member
Joined: 2 years ago

We seem to have suddenly lost profile synchronization and all our forum posts are showing as Anonymous. In fact, things just got worse, now our forums arent's displaying at all, just a blank space where they used to be (the forum header with the title, unread posts icon etc. is still visible). The banner "wpForo Forum Installation | 0%" appears in our Wordpress admin area and hitting the "Start Profile Synchronization" button brings up a "don't stop or close browser" message and a "Synched successfully" message but the banner is still there and our forums still not visible on the front end. In the wpforo admin area we can still see the forums hierarchy with the correct topics, posts etc. Help please!!

 

wpForo Version
1.9.9.1
WordPress Version
5.8.2
7.4.16
10.3.29-MariaDB
4 Replies
Upstart DM
Posts: 34
Topic starter
(@upstartdm)
Trusted Member
Joined: 2 years ago

Additional info: we have 38,000 members, 15,000 topics and 91,000 posts but the "don't stop or close browser" and "Synched successfully" messages appear just a few seconds after hitting the "Start Profile Synchronization" button - does that sound feasible, or should the process take longer?

 

Upstart DM
Posts: 34
Topic starter
(@upstartdm)
Trusted Member
Joined: 2 years ago

I think I've tracked down the problem (see below). How to fix? Restore from backup?

Table name
Problem description
Table: wpforo_profiles
Missing fields:  userid,
title, username, groupid, posts, questions, answers, comments, site,
icq, aim, yahoo, msn, facebook, twitter, gtalk, skype, avatar,
signature, about, occupation, location, last_login, online_time, rank,
like, status, timezone, is_email_confirmed, secondary_groups, fields
Table: wpforo_profiles
Missing keys:  userid, groupid, online_time, posts, status, is_email_confirmed

 

Chris
Posts: 1945
Admin
(@chris)
Support Team
Joined: 1 year ago

Hi @upstartdm,

1. Backup everything in database what you currently got, It's needed if something would crush we could bring it back to current position.

If the backup process won't work correctly, exclude Table: wpforo_profiles, and try the backup again.

2. Find the oldest working backups, If you don't have it your Server Hosting may have the backups. 

3. Delete Table: wpforo_profiles from your database.

4. Import the latest working Table: wpforo_profiles.

Upstart DM
Posts: 34
Topic starter
(@upstartdm)
Trusted Member
Joined: 2 years ago

Thanks for the reply. I managed to get everything back up and running after restoring the DB (restored the whole thing in the end rather than just the table but it was a very recent backup so no problem).

 

Share: