Missing posts and topics after dearchiving process

[angle4cor]

Hello, 

Due to a request of the former hosting provider of my board, I had to decrease the database size and therefore, I have chosen to move old posts to a seperate database. I've had some problems with it and had to be assisted by the Invision Community staff to complete this task. I've created a topic about it here:

 

Fast forward to a couple of months later, I have moved the board to another server recently. I have decided to unarchive all posts and keep it all in the same database. I've turned the archiving process off and with CRON on the database size with forums_archive_posts decreased over time from over 400mb of data to a little over 12mb of data. The process seems to be over, I see no additional scheduled tasks in the forums ACP, but the archive database is not empty and theres still over 200k posts that are not accessible on my board. 

There should be around 630k posts on my board, but it shows 443k at the moment:

I see forums showing wrong total topics numbers:

That forum for example contains way more than just 9 posts:

I can open way more than just 9 posts here, but many topics are throwing an error when I am trying to enter:

Link to a topic thats showing that error:

 https://forum.wrestling.pl/topic/36611-sprzedam-grę-wwe-2k14/

 

 

I tried to rebuild the search index, it does show that theres around 630k posts on the board, but like you can see in the attatched screenshot, its reaching 100% with just like 20k posts that were rebuilded.

 

I am struggling with this for the last few days and I hope you can help me solve these issues. I hope that I have described everything clearly. I have updated the acces information in the Client Area in case some additional help trough technical staff would be necessary. 

 

Greetings

Edited 14 hours ago by angle4cor

[Jim M]

If there is still data in the archived database table, the process is still running. The unarchiving process does not show up in the queue (like search index rebuild does), it has it's own background process and just runs constantly if there are archived topics to unarchive. You can run this task manually in ACP -> System -> Advanced Configuration -> View Tasks -> unarchive. Then see if you get any errors. If you do, please let us know.

[angle4cor]

The unarchive tasks shows that its not currently needed, so I guess the process is done:

I tried to run it manually a few times, but there are no errors and the forums_archive_posts table is not changing its size at all. 

When I am opening the forums_archive_posts table in the phpmyadmin, it shows only 281 records all connected to the same topic with archive_topic_id = 2492. 

I have no idea what happend with the other 200k posts here. 

[Jim M]

I have transferred this to a ticket so that we can further investigate what is happening here. 200k is a lot of posts that I do not have an immediate answer for and would like to think there is a count issue here, but I will let a developer fully investigate.

Please watch your email for further correspondence. Please note though that we are currently observing the Christmas and New Years holidays where support times may be longer than normal, or potentially not be able to get a full answer till after the New Years holiday.