Don making sure GD posts preserved; "fully supports" L19!

[HermanHiddema]

Any updates on this?

Can someone at the very least publish the raw database dump?

[Jordus]

Out of curiosity: How can the database be corrupt? Software error in VBulletin software? Hardware problem with database server?

It is a known issue with the vbulletin software.

Any updates on this?

Can someone at the very least publish the raw database dump?

If you think you might be able to extract the info then pm me for the link to download it.

[xed_over]

Either the datadump is incomplete, or some data has been lost due to corruption? Or are some of these count mismatches due to deleted posts or something similar?

for u in user_id.list; do mysql -e "select count(*) from vb_post where userid = "$u";"; done

Code: Select all

userid   gd *   db
   posts   count
---------------------
129   3513   3464
221   3005   3008
156   2845   2791
2111   2705   2560
241   2587   2498
155   2428   2435
119   2308   2315
105   2173   2169
670   2067   2044
162   1708   1668

*GoDiscussions post counts as of today
http://www.godiscussions.com/forum/memb ... osts&pp=30

[flOvermind]

In IPBoard this mismatch would be normal. The "post count" column in the user table increases whenever a post is made, but it never decreases, even when posts are deleted. This can for example be seen as a mismatch between the post count in the user list and the post count on the user profile page.

I wouldn't be surprised when there is a similar thing going on in vBulletin.

[jts]

Huh. But some people have a higher number in the left column and some have a higher number in the right column.

[flOvermind]

Yes, I see the same on my IPBoard forum. And I have no idea how that can ever happen...

[Lictor]

I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it

[xed_over]

I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it

the mysql dump was corrupted and incomplete

[Bantari]

Yes, I see the same on my IPBoard forum. And I have no idea how that can ever happen...

Some people have drafts saved which never got published?

[Lictor]

I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it

the mysql dump was corrupted and incomplete

It seems a backup failure. MYSQL have many different functions for proper backup for different CMS softwares.

[xed_over]

I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it

the mysql dump was corrupted and incomplete

It seems a backup failure. MYSQL have many different functions for proper backup for different CMS softwares.

either that, or the database itself became corrupted during use, and the latest backup successfully replaced a good previous backup with the now corrupted backup, and no one noticed or saved any previously good backups.

[xed_over]

I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it

yeah, I thought the very same thing myself.

but when I finally did see it.. its beyond repair. almost half the tables are missing.

[Lictor]

I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it

yeah, I thought the very same thing myself.

but when I finally did see it.. its beyond repair. almost half the tables are missing.

It's still depends on which tables are missing. If not specific ones still could be repairable from a vanilla setup. (With combine missing tables)

[jug]

Can someone at the very least publish the raw database dump?

If you think you might be able to extract the info then pm me for the link to download it.

I'm interested in the old GoDiscussion-forums. Can someone send me a link to the data of the old GoDiscussion-forums, where I can download the db-dump please?
(Have contacted Jordus 5 days ago but without any response yet).

[xed_over]

there is no link to the dump.
I have a copy. Its incomplete. about half of the tables are missing.