#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Main Support Forums
How-to and Troubles...
URGENT: Lost forums...
 
Share:
Share
Tweet
Share
Notifications
Clear all

[Solved] URGENT: Lost forums/profile synchronization

    Last Post
RSS

Upstart DM
Posts: 26
 Upstart DM
Topic starter
December 11, 2021 2:49 pm
(@upstartdm)
Eminent 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
PHP Version
7.4.16
MySQL version
10.3.29-MariaDB
Topic Tags
profile synchronization database error missing fields missing keys
4 Replies
Upstart DM
Posts: 26
 Upstart DM
Topic starter
December 11, 2021 2:53 pm
(@upstartdm)
Eminent 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: 26
 Upstart DM
Topic starter
December 11, 2021 3:05 pm
(@upstartdm)
Eminent 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

 

This post was modified 6 months ago by Upstart DM
Chris
Posts: 1390
 Chris
Admin
December 11, 2021 4:53 pm
(@chris)
Support Team
Joined: 11 months 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.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Upstart DM
Posts: 26
 Upstart DM
Topic starter
December 11, 2021 7:03 pm
(@upstartdm)
Eminent 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).

 

  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • WordPress database error Table 'wp_wpforo_logs' doesn't exist
    1 year ago
  • Problems Found in Database - doesn't exist in engine
    3 years ago
  • Multisite errorTale does not exist
    3 years ago
  • Mysql Error
    4 years ago
Topic Tags:  profile synchronization (1), database error (7), missing fields (1), missing keys (2),

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • How to put join us in the forum with login and register the same as wpForo?

    By edielton, 16 hours ago

  • Can't change forum slug

    By popvlad82, 2 days ago

  • Major bug occurring with @user mentions

    By Noved, 2 days ago

  • Forum description

    By Vijiki, 3 days ago

  • cant send public messages to friends

    By ReddBeard, 3 days ago

  • Moderation Turned Completely Off...User's Posts Are Still "Awaiting Moderation"...

    By Noved, 3 days ago

Topic Tags

  • css50
  • translation49
  • plugin conflict48
  • seo45
  • new features44
  • buddypress42
  • moderation40
  • ultimate member40
  • avatar40
  • forum40
  • login38
  • registration36
  • threaded layout35
  • cache33
  • editor32
  • menu32
  • shortcode31
  • forum accesses30
  • spam29
  • phrases28
View all tags (2163)

Recent Posts

  • RE: How to put join us in the forum with login and register the same as wpForo?

    Where exactly you want to put the login/register button...

    By Robert, 2 hours ago

  • RE: Guest to not see recent posts on Recent activity page

    I want to migrate my forum to other platform! The new...

    By OMTesla, 2 hours ago

  • RE: Major bug occurring with @user mentions

    @chris Thanks for the reply. After spending roughly 12 ...

    By Noved, 22 hours ago

  • RE: Can't change forum slug

    There are two places for the slug. In wpForo AND mainly...

    By dimalifragis, 2 days ago

  • RE: Moderation Turned Completely Off...User's Posts Are Still "Awaiting Moderation"...

    @robert Ok thank you!

    By Noved, 2 days ago

  • RE: wpForo 2 Major Update is Imminent!

    @dimalifragis, It depends on the beta version. We are...

    By Robert, 2 days ago

  • RE: How to schedule a topic?

    Hi @joselito, I'm sorry, but this will not be availab...

    By Robert, 2 days ago

Share:
Share
Tweet
Share
  Forum Statistics
20 Forums
9,775 Topics
49.5 K Posts
5 Online
44.8 K Members

Latest Post: How to put join us in the forum with login and register the same as wpForo? Our newest member: How Nutritional Supplements Al... Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation