How to restore database

#1 · September 2, 2019, 3:52 pm

I just updated my plugin to 1.15.1 and updated my WP to 5.2.2. If I recall, as part of the WP update it did some sort of database update as well.

It seems that one of these upgrades caused me to loose all of my Asgaros Forum categories and posts. My basic forum setup data is ok. I checked in my db and it looks like I still have all of my data. Here is a snippet of the the tables for wp_forum. Please let me know how I can recover these posts.

nb: post moved from within release notice and moved to new topic

Uploaded files:

#2 · September 3, 2019, 8:37 pm

Can anyone please point me in the right direction on this one. It is an integral part of my site.

I just tried changing a few settings to see if it would rebind the database and got these error messages

[Tue Sep 03 18:33:45.881999 2019] [proxy_fcgi:error] [pid 2027:tid 140406641587968] [client 66.249.146.221:10191] AH01068: Got bogus version 55, referer: https://offgridsoftwaresolutions.com/ws500-user-forum/
[Tue Sep 03 18:33:45.882054 2019] [proxy_fcgi:error] [pid 2027:tid 140406641587968] (22)Invalid argument: [client 66.249.146.221:10191] AH01075: Error dispatching request to :, referer: https://offgridsoftwaresolutions.com/ws500-user-forum/

Hoping this means something to someone 🙂

Much appreciated!

Rick

#3 · September 5, 2019, 8:16 pm

Hello @sailor-rick

First of all: Sorry for the late reply! The latest version of Asgaros Forum does not make any changes to the database-structure. From which version did you upgrade?

I guess that this issue is caused by another problem. Are you using some kind of clean-up extensions like the WP-Sweep plugin? Some of those sometimes delete required data from the database.

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

#4 · September 5, 2019, 10:07 pm

Thanks for getting back to me!

And, actually, yes I am. I am using this french plugin called WPS Cleaner and I do recall using it the other day. I have used it before without any issues but you may be on to something.

https://www.wpserveur.net/ (in french)

It seems I am missing the categories tables.

Here is a snippet

Thanks !!

Uploaded files:

#5 · September 6, 2019, 3:03 pm

Hello again @sailor-rick

I suggest you to disable this kind of extensions because they often remove “unused” data which in fact is required. In your case it seems that the plugin removed the terms/taxonomy-data used for categories.

Basically it can be possible to get access to the structure again by modifying the database. If you dont know how to do it and you can give me phpMyAdmin and WordPress access, I could do it for you manually. You can contact me via developer (at) thomasbelser.net

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

#6 · September 6, 2019, 3:04 pm

Thomas, any ideas on how to fix this?

Do I need to re-create my categories? If so, how would I re-establish the links to the current postings?

Thanks,

Rick

@thomas-b