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] After a restore how to synch Front & DB

5 Posts
2 Users
1 Reactions
1,434 Views
ldj72
Posts: 95
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
(@ldj72)
Estimable Member
Joined: 4 years ago
[#25035]

Hi,

I am hosted at wordpress.com, WordPress + wpForo

After restoring my site and forum with Jetpack Backup (A service from Wordpress.com ), my front end shows an empty forum, like when I started:

It seems data are still here because I saw them on the admin panel: ,

and I see also members in wpforo>members

On the other hand, there is nothing in "Category and Forums" , and I lost all my settings (Customize CSS, SPAM settings, etc.)

Β 

In wpforum>Tools, I see an error message on the "Database Tables" tab , but when I click "Solve database problem" it doesn't solve the issue.

Β 

When I try to do it by using phpMyAdmin Database Manager > WordPress Database > SQL Tab I get also another error message

#1062 - Duplicata du champ 'community' pour la clef 'unique_slug'

I don't know if my issue with the data stored, and the empty front is linked to this message error in DB, but I need support to fix my issue.

I need to be sure I can back up and restore mywpForo at any time.

Thanks

Β 

wpForo Version
2.09
WordPress Version
6.02

4 Replies
ldj72
Posts: 95
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
(@ldj72)
Estimable Member
Joined: 4 years ago

After more analysis with Phpmyadmin :

I see my forums on wp_wpforo_forums and vp_backup_wp_wpforo_forum

but my frontend show forums from wp_wpforo_6-forum

Β 

And I can see all the information in tables on the DB (Posts, tags, etc...). So my data are not lost but not well linked.

Please advise.

Β 

Reagrds

Β 

Β 


1 Reply
ldj72
(@ldj72)
Joined: 4 years ago

Estimable Member
Posts: 95
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

It seems wpForo show data from wp_wpforo_6_xxx tables when in fact they are all in wp_wpforo_xxx

The number 6 is coming from the board IDΒ 

Please advise.

Β 

Regards


Robert
Posts: 10718
Admin
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
(@robert)
Support Team
Joined: 2 months ago

@ldj72,

Please edit the board in wpForo > Boards admin page, and change the Board Slug to forum-tmp.

Then go to wpForo > Tools > Database tables tab and click the [Solve Problems] or execute the SQL again, it should work now.

It'll create a new board with boardid=0. Once the board with boardid=0 is created, you can delete other boards.


ldj72
Posts: 95
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
(@ldj72)
Estimable Member
Joined: 4 years ago

Hi Robert,

it's fixed. Thanks for your quick support. 👍Β 


Share: