iZeal 5 Posted August 9, 2014 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 1 instead of 150000: Quote Share this post Link to post Share on other sites
0 iZeal 5 Posted August 10, 2014 anyone can help me? Quote Share this post Link to post Share on other sites
0 kisuka 178 Posted August 15, 2014 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; Quote Share this post Link to post Share on other sites
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 1 instead of 150000:
Share this post
Link to post
Share on other sites