vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   need to renumber user id numbers in the database because of a boo boo (https://vborg.vbsupport.ru/showthread.php?t=79004)

solent 03-29-2005 11:24 AM

need to renumber user id numbers in the database because of a boo boo
 
The problem that I am having is I had a admin manually renumber a peep in the database and now it is assigning user id numbers in a random manner well this is causing a bit of problem with soft delete of posts with by phantom users. also it is inserting them in a very strange fashion into the db. IE: user id 1, user id 2, user id 100428, user id 4 etc. now I know that there are at least 4 other records that use the user id number. what i am asking is there a way to renumber the user id numbers in the data base and what other record also need to be renumbered to make it work ? or can it be done at all.

now to answer the first question that will be asked is no I do not have a valid old db backup :disappointed: .

I went to vbulliten.com and they sent me here lol lucky you so any suggestion or advice or help would greatly be apprciated thank yo in advance folks


All times are GMT. The time now is 01:46 PM.

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.00953 seconds
  • Memory Usage 1,699KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete