vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Thread/Forum/User ID Issue after Converting (https://vborg.vbsupport.ru/showthread.php?t=285908)

irfan72 07-24-2012 06:55 AM

Thread/Forum/User ID Issue after Converting
 
<font color="Blue">Hi,
Previously I was using MyBB, but from the time I converted my Forum into vBulletin using Impex, an issue I'm having to face is that all the ids have been started far from like user ids have started from 6028 while thread ids from 8000 series, can I have any sql querry to fix this matter?
I want these ids to be started from 1 ofcourse.
{I'm having Super Admin at id 1, no problem if I do need to remove that or if the ids do start from 2nd figure}
</font>

Simon Lloyd 07-24-2012 07:32 AM

The trouble with resetting the primary key is that all relationships with other tables will be lost, so if you reset the userid key they may no longer be associated with posts/threads the same goes if you reset the thread or post primary keys, if you can live with that then i'll help you otherwise just live with it, it will be of no consequence to you or change the way the forum works.


All times are GMT. The time now is 02:02 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.01056 seconds
  • Memory Usage 1,704KB
  • 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
  • (2)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