AI Assistant
Notifications
Clear all

[Solved] Updating wpForo 1.9.9.1 to 2.0.8 causes all posts to disappear

7 Posts
4 Users
3 Reactions
1,934 Views
Posts: 12
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
(@guitarnoise)
Eminent Member
Joined: 7 years ago
[#23982]

Hi, after trying to update wpForo 1.9.9.1 to 2.0.8 all of my posts have disappeared.

On the fontend it looks like an empty community with 1 forum with 0 posts, 0 topics, and 11.6k users.
 
In the backend the wpForo shows the expected 29 forums, 47712 topics, 385547 posts, 11598 members.
 
I don't have any template customization or add-ons. I updated using the one-click plugin update. When trying to click the Access Database Troubleshooter button I got a Wordpress error “Sorry, you’re not allowed to access this page.”
 
I navigated to the Tools > Database Tables Tab and clicked solve database problems. That didn't remove the errors. Next I used the hosts Database Management Tool to manually input Problem Fixer SQL Commands and it returned a couple of errors:
 
Query 3
Error in query (1062)
Duplicate entry 'community' for key 'unique_slug',
 
Query 4
Error in query (1065)
Query was empty
 
What are some next steps to get everything back to normal? I have backups of everything, but I'm really interested in using wpForo 2.x from now on.
 
Any help or support would be greatly appreciated.
The page I need help with
wpForo Version
2.0.8
WordPress Version
6.0.2

6 Replies
Posts: 212
 fawp
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
(@fawp)
Reputable Member
Joined: 7 years ago

I tested the update to v.2 a couple of times.

In one occasion I had similar issues to yours.

 

I first updated from 1.9.9.1 to 1.9.9.2 and then updated to version 2.x, this seems to have helped.

You might want to give this a try.


Posts: 12
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
(@guitarnoise)
Eminent Member
Joined: 7 years ago

Thank you for the suggestion. I might give that a try. But first I'm still hoping for a solution that doesn't require me rolling back to a previous version.

It could be something the support team understands the cause of.


Robert
Posts: 10720
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

@guitarnoise,

Go to wpForo > Boards, edit the current board and change the slug to tmp-board

Then go back to wpForo > Tools > Database Tables tab and click the [Solve Problems] button.

Then go to wpForo > Overview admin page, scroll down and click the [Delete All Caches] and [Hard Flush Permalinks] buttons

 


Posts: 12
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
(@guitarnoise)
Eminent Member
Joined: 7 years ago

Thank you @robert 

That does repair the forums.

There is an issue though, the login and registration URLs do not appear. I confirmed all login settings are enabled. If I look at the second forum with the slug tmp-board it does have login/registration links.

Furthermore, the board ID 0 and board ID 1 both share the same page ID. Is that a problem?


2 Replies
RealAct
(@realact)
Joined: 8 years ago

Reputable Member
Posts: 239
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

@guitarnoise I can see Login and Registration pages on your forum as a guest. Have you cleared your browser's cache?


(@guitarnoise)
Joined: 7 years ago

Eminent Member
Posts: 12
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

@realact Thank you for checking. I did clear my cache and tried different browsers. Just flushed the server cache and I can see them now. Appreciate you checking for me. Thank you.


Share: