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,192 Views
Posts: 12
Topic starter
(@guitarnoise)
Eminent Member
Joined: 5 years ago

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.
6 Replies
Posts: 201
 fawp
(@fawp)
Reputable Member
Joined: 5 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
(@guitarnoise)
Eminent Member
Joined: 5 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: 10588
Admin
(@robert)
Support Team
Joined: 9 years 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
(@guitarnoise)
Eminent Member
Joined: 5 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: 6 years ago

Reputable Member
Posts: 233

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

(@guitarnoise)
Joined: 5 years ago

Eminent Member
Posts: 12

@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.