It is currently Thu Apr 18, 2024 4:54 am

View unanswered posts | View active topics View unread posts | View new posts | View your posts


Board index » Life In 19x19.com General Topics » Announcements

All times are UTC - 8 hours [ DST ]



Post new topic Reply to topic  Page 4 of 4
  [ 76 posts ]  Go to page Previous  1, 2, 3, 4
  Print view Previous topic | Next topic 
Author Message
Offline HermanHiddema
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #61 Posted: Thu Aug 11, 2011 7:53 am 
Gosei
User avatar

Posts: 2011
Location: Groningen, NL
Liked others: 202
Was liked: 1087
Rank: Dutch 4D
GD Posts: 645
Universal go server handle: herminator
Any updates on this?

Can someone at the very least publish the raw database dump?
Top
 Profile  
 
Offline Jordus
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #62 Posted: Thu Aug 11, 2011 1:39 pm 
Site Admin
User avatar

Posts: 1125
Location: Allegan, MI, USA
Liked others: 18
Was liked: 121
Rank: KGS 9k
Universal go server handle: Jordus
SpongeBob wrote:
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.

HermanHiddema wrote:
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.

_________________
I'm thinking...
Top
 Profile  
 
Offline xed_over
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #63 Posted: Fri Sep 16, 2011 9:50 pm 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
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:
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
Top
 Profile  
 
Offline flOvermind
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #64 Posted: Fri Sep 30, 2011 5:47 am 
Lives with ko
User avatar

Posts: 295
Location: Linz, Austria
Liked others: 21
Was liked: 44
Rank: EGF 4 kyu
GD Posts: 627
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.

This post by flOvermind was liked by: xed_over
Top
 Profile  
 
Offline jts
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #65 Posted: Fri Sep 30, 2011 7:53 am 
Oza
User avatar

Posts: 2644
Liked others: 304
Was liked: 631
Rank: kgs 6k
Huh. But some people have a higher number in the left column and some have a higher number in the right column.
Top
 Profile  
 
Offline flOvermind
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #66 Posted: Sat Oct 01, 2011 5:12 am 
Lives with ko
User avatar

Posts: 295
Location: Linz, Austria
Liked others: 21
Was liked: 44
Rank: EGF 4 kyu
GD Posts: 627
Yes, I see the same on my IPBoard forum. And I have no idea how that can ever happen...
Top
 Profile  
 
Offline Lictor
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #67 Posted: Sun Sep 15, 2013 4:23 am 
Beginner
User avatar

Posts: 6
Liked others: 0
Was liked: 0
Rank: KGS 20 kyu
I don't know whats happened but if I saw in when in MYSQL, I am sure I will be fix it :)
Top
 Profile  
 
Offline xed_over
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #68 Posted: Sun Sep 15, 2013 8:08 am 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
Lictor wrote:
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
Top
 Profile  
 
Offline Bantari
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #69 Posted: Sun Sep 15, 2013 10:09 am 
Gosei
User avatar

Posts: 1639
Location: Ponte Vedra
Liked others: 642
Was liked: 490
Universal go server handle: Bantari
flOvermind wrote:
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?

_________________
- Bantari
______________________________________________
WARNING: This post might contain Opinions!!
Top
 Profile  
 
Offline Lictor
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #70 Posted: Sun Sep 15, 2013 11:24 am 
Beginner
User avatar

Posts: 6
Liked others: 0
Was liked: 0
Rank: KGS 20 kyu
xed_over wrote:
Lictor wrote:
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.
Top
 Profile  
 
Offline xed_over
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #71 Posted: Sun Sep 15, 2013 1:29 pm 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
Lictor wrote:
xed_over wrote:
Lictor wrote:
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.
Top
 Profile  
 
Offline xed_over
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #72 Posted: Sun Sep 15, 2013 1:33 pm 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
Lictor wrote:
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.
Top
 Profile  
 
Offline Lictor
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #73 Posted: Sun Sep 15, 2013 1:52 pm 
Beginner
User avatar

Posts: 6
Liked others: 0
Was liked: 0
Rank: KGS 20 kyu
xed_over wrote:
Lictor wrote:
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)
Top
 Profile  
 
Offline jug
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #74 Posted: Fri Jan 16, 2015 10:43 am 
Dies with sente

Posts: 75
Liked others: 7
Was liked: 18
Rank: EGF 5k
KGS: jug
DGS: jug, 4k
Jordus wrote:
HermanHiddema wrote:
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).
Top
 Profile  
 
Offline xed_over
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #75 Posted: Fri Jan 16, 2015 11:57 am 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
there is no link to the dump.
I have a copy. Its incomplete. about half of the tables are missing.
Top
 Profile  
 
Offline jug
 Post subject: Re: Don making sure GD posts preserved; "fully supports" L19
Post #76 Posted: Fri Jan 16, 2015 12:18 pm 
Dies with sente

Posts: 75
Liked others: 7
Was liked: 18
Rank: EGF 5k
KGS: jug
DGS: jug, 4k
xed_over wrote:
there is no link to the dump.
I have a copy. Its incomplete. about half of the tables are missing.

I have read the thread, but wanted to take a peek regardless. Can you send the dump to me (or upload it somewhere safe for a short time to be downloaded from there)?
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 4 of 4
  [ 76 posts ]  Go to page Previous  1, 2, 3, 4

Board index » Life In 19x19.com General Topics » Announcements

All times are UTC - 8 hours [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group