Jump to content
  • 0
Sign in to follow this  
iZeal

Char_ID on SQL Question

Question

Hi Just wanted to ask about this weird problem on my SQL but nothing unusual it's just that It's my first time seeing something like this:
the char_id started at instead of 150000:

post-6299-0-66726300-1407601528_thumb.png

 

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

First off, perform the following query on your MySQL database to check what the AUTO_INCREMENT value is currently set to for the char table.

SELECT `AUTO_INCREMENT`FROM  information_schema.tables WHERE table_schema = 'ragnarokDB'AND   table_name = 'char';

If it's below 150000 then you may have accidently messed up the AUTO_INCREMENT value. It's not a terrible issue really, as long as the account_id is still referencing your correct accounts and the char_id is correct in the other tables then theoretically you should be fine. If it's that much of an issue though and you want any future characters made to have 150k+ IDs then perform the following:

ALTER TABLE `char` AUTO_INCREMENT = 150000;

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.