AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant
Notifications
Clear all

[Solved] URGENT: Lost forums/profile synchronization

5 Posts
2 Users
0 Reactions
2,054 Views
Posts: 50
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@upstartdm)
Trusted Member
Joined: 6 years ago
[#19283]

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

4 Replies
Posts: 50
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@upstartdm)
Trusted Member
Joined: 6 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?

 


Posts: 50
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@upstartdm)
Trusted Member
Joined: 6 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: 3610
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@chris)
Famed Member
Joined: 5 years 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.


Posts: 50
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@upstartdm)
Trusted Member
Joined: 6 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: