Notifications
Clear all

How can I change the default database table prefix?

2 Posts
2 Users
1 Reactions
138 Views
ffooccuuss
Posts: 21
Topic starter
(@ffooccuuss)
Eminent Member
Joined: 6 months ago

I want to create a staging website to test and experiment with. I used WPVivid to create a staging website and it was successful. However, there are no posts in the new, copied WPForo application. I think it is because all of the database tables were copied with a table prefix of "staging_". In other words, the new staging site has a table prefix of "staging_wpforo_" for the wpforo tables. 

WPForo wants to use the default table prefix of wpforo_. Can I edit a config somewhere to change where the WPForo application points to change the table prefix, or do I need to create a staging site with its own independent database so it can use the default table prefix? 

I just created this so I can delete this staging instance and recreate it with a separate database if that is preferred. But my site is 17gb and 90,000 posts so it is not as easy as just changing a table prefix somewhere. 

1 Reply
Posts: 996
Moderator
(@martin)
Support Team
Joined: 8 years ago

Hi @ffooccuuss,

wpForo doesn't need any prefix. wpForo tables have _wpforo_ secondary prefix, it's not a primary prefix. So your forum table prefixes should be anything_wpforo_ . If the staging_wpforo_ is ok. You just need to make sure the board ID is correct.

Open the _wpforo_boards table and make sure the boardid = 0 of the first row. If you have just one forum page, then there should be one board with boardid = 0.

Fix it, then go to wpForo > Overview admin page and click [Delete All Caches]

Reply