Missing rep, no posts with likes now and I'm missing over a 1000 of my posts

this issue is city wide folks, we are effected as well,
rest assured gnick will fix it.

 

Originally, they had a fix but now they are having to find a fix. I have been told it will be fixed so hopefully, that will happen.

 

This is still in progress , we are just acting very careful as this is data insertion on existing content. That's why we are making sure it will not effect anything further. Our plan is to roll this live next week. We will announce the day Monday.

 

Thanks!

@Lizard King

 

Hey All

We now have a completed import , however before rolling this live , i need to verify that all data is correctly inserted.

If you have a link of your missing thread that generates an error or have an old link for a missing post , that will help us greatly. Please supply them so we can confirm and roll this live asap

 

On all my tests the data is accurate.

Live website post count prior to import

+----------+
| count(*) |
+----------+
| 20610460 |
+----------+

Test server data

+----------+
| count(*) |
+----------+
| 20692180 |
+----------+

Missing 82k post seems correctly imported. We'll conduct some further tests and choose a day to roll this live this week.

We'll keep you updated.

 

Hello ,

Tomorrow we will roll this live. The board will be offline an hour or so.
Here is the process we will do tomorrow
1. Disable the forum to public access
2. Initiate import process
3. Verify import is done correct
4. Enable the board
5. Start two important backend task that will update post counts for users and threads.

Step 5 will take approximately 48-72 hours.

Cross fingers

 

We had a minor issue while importing that big database of IPB to server , that's why the process is a bit delayed. We are waiting update from datacenter on correction for the issue.

However good news is that i found some broken threads on live website and verified that they are correctly imported on test server

Code:

Broken thread on live : https://forum.grasscity.com/threads/plants-in-the-same-plot-changing-strains.1232466/

test server :  http://d.pr/i/Uc2t/3HVySfCQ

However as i suspected likes for those posts are gone , because when IPB moves those post to archive they also remove all reputation details from the posts. Which makes it impossible for us to retrieve as archive table contain no information about them

Code:

MariaDB [ipb]> describe forums_archive_posts;

+------------------------+------------------+------+-----+---------+-------+
| Field                  | Type             | Null | Key | Default | Extra |
+------------------------+------------------+------+-----+---------+-------+
| archive_id             | int(10)          | NO   | PRI | 0       |       |
| archive_author_id      | int(10)          | NO   | MUL | 0       |       |
| archive_author_name    | varchar(255)     | NO   |     | 0       |       |
| archive_ip_address     | varchar(46)      | NO   |     |         |       |
| archive_content_date   | int(10)          | NO   | MUL | 0       |       |
| archive_content        | mediumtext       | YES  |     | NULL    |       |
| archive_queued         | int(1)           | NO   |     | 1       |       |
| archive_topic_id       | int(10)          | NO   | MUL | 0       |       |
| archive_is_first       | int(1)           | NO   |     | 0       |       |
| archive_bwoptions      | int(10) unsigned | NO   |     | 0       |       |
| archive_attach_key     | char(32)         | NO   |     |         |       |
| archive_html_mode      | int(1)           | NO   |     | 0       |       |
| archive_show_signature | int(1)           | NO   |     | 0       |       |
| archive_show_emoticons | int(1)           | NO   |     | 0       |       |
| archive_show_edited_by | int(1)           | NO   |     | 0       |       |
| archive_edit_time      | int(10)          | NO   |     | 0       |       |
| archive_edit_name      | varchar(255)     | NO   |     |         |       |
| archive_edit_reason    | varchar(255)     | NO   |     |         |       |
| archive_added          | int(10)          | NO   |     | 0       |       |
| archive_restored       | int(1)           | NO   | MUL | 0       |       |
| archive_forum_id       | int(10)          | NO   |     | 0       |       |
+------------------------+------------------+------+-----+---------+-------+
21 rows in set (1.15 sec)

 

After further investigation i also found out a second issue that missed our attention. It seems Xenforo is missing a major important backend tool : Update Users Post Counts

Which resulted users thinking that they los posts. Basically some users post counts reflect lower then the actual post count they have in system

We started developing this maintenance tasks and it shall be completed hopefully tonight. We will test this tool on our development server and then roll live .

Thanks to Ron for his pursue on this issue , his effort forced me to investigate further