Go Back   vb.org Archive > Community Central > Community Lounge
Reload this Page Unsorted IDs=corrupted databasE?
FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 06-16-2003, 04:11 PM
Areku Areku is offline
 
Join Date: Feb 2002
Posts: 540
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Unsorted IDs=corrupted databasE?
Hi!

I just moved vb & the db to a new server and just noticed most of the IDs in user table are unsorted...

I think I never saw this unsorting before...

Is this normal?

Is this symptom of corruption?

How can I fix this?

Thanks!
Reply With Quote
  #2  
Old 06-16-2003, 04:34 PM
N9ne N9ne is offline
 
Join Date: Feb 2002
Posts: 1,495
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Run this query:

SELECT * FROM user ORDER BY userid DESC LIMIT 30;

Does everything look ok?
Reply With Quote
  #3  
Old 06-16-2003, 04:40 PM
Areku Areku is offline
 
Join Date: Feb 2002
Posts: 540
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Seems so...

But I do recall I didn't use to see user table unsorted before....

Shall I worry then?
Reply With Quote
  #4  
Old 06-16-2003, 05:45 PM
N9ne N9ne is offline
 
Join Date: Feb 2002
Posts: 1,495
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Not if everything is working fine, you could also try this:

REPAIR TABLE `user`;

That will attempt to repair the user table if any damage has been done to it.
Reply With Quote
  #5  
Old 06-16-2003, 05:54 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Since the ID is unreliable for sorting over time, it shouldn't make a difference, albeit it'll look funky.
Reply With Quote
  #6  
Old 06-16-2003, 06:04 PM
Areku Areku is offline
 
Join Date: Feb 2002
Posts: 540
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Ok pals, thanks a lot!

However, which is the explanation to unsorting? And I'm not talking about deleting IDs...

It's just that I may have user ids like this now:

2
3
165
4
5
200
6
201
202
7
8

when they used to be correlative...

Thanks!
Reply With Quote
  #7  
Old 06-16-2003, 06:20 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
If you mean when new users are registering then it could be the unfortunate side effect of dropping and readding an auto_increment.

Was this from a vB3 upgrade? Also did you transfer the dump just as at http://www.vbulletin.com/manual/movingservers.html ?
Reply With Quote
  #8  
Old 06-16-2003, 06:41 PM
Areku Areku is offline
 
Join Date: Feb 2002
Posts: 540
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
No, I was just moving a 2.2.0 DB VB....

And yes, more or less i followed the paths in the Members area...

Which side effect is this?

How will this affect the db, performance, results or future corruption?

I had a very similar issue on a DB created from scratch, that would exim the server transfer "bug", what should this be then??

Thanks!
Reply With Quote
  #9  
Old 06-16-2003, 07:24 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Not sure what would happen other than freaky relationships between data over the next few days or so, depending on how busy your forum is and how much data gets filled in (if what I think is happening is really happening).

On another note, unless you enjoy getting hacked, upgrade to 2.3.0 as soon as superhumanly possible.
Reply With Quote
  #10  
Old 06-17-2003, 05:06 PM
S.Shady's Avatar
S.Shady S.Shady is offline
 
Join Date: Apr 2003
Location: Cleveland, Ohio
Posts: 179
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
2.2.0 damn. i would definatly upgrade to 2.3.0 it would be alot of hacking but it would be worth it
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 09:45 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03913 seconds
  • Memory Usage 2,228KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete