noobzter003 3 Posted July 1, 2018 Anyone Can Help me about this Error. TIA Quote Share this post Link to post Share on other sites
0 4144 366 Posted July 1, 2018 this is known innodb issue. First character can have wrong id. Fix it manually or remove character with id smaller than 150000 1 noobzter003 reacted to this Quote Share this post Link to post Share on other sites
0 noobzter003 3 Posted July 2, 2018 11 hours ago, 4144 said: this is known innodb issue. First character can have wrong id. Fix it manually or remove character with id smaller than 150000 thanks for answering my problem sir. but what should i edit here. Quote Share this post Link to post Share on other sites
0 noobzter003 3 Posted July 2, 2018 Just now, noobzter003 said: thanks for answering my problem sir. but what should i edit here. do i need to change in to 150001 150002 150003 like this? Quote Share this post Link to post Share on other sites
0 4144 366 Posted July 2, 2018 no, you looking wrong field. issue with char_id. char_id must be 15000 or bigger Quote Share this post Link to post Share on other sites
0 Dastgir 1246 Posted July 4, 2018 check the `char` table Quote Share this post Link to post Share on other sites
0 noobzter003 3 Posted July 23, 2018 On 7/4/2018 at 2:46 PM, Dastgir said: check the `char` table this is my char table. whats the problem.. sorry i dont get it. Quote Share this post Link to post Share on other sites
0 Mahiro1 1 Posted July 23, 2018 9 minutes ago, noobzter003 said: esta é minha tabela char. o que é o problema .. desculpe, eu não entendi. 'char_id' should start at 150000 the way it is there: 1, 2, 3 ... it's wrong Quote Share this post Link to post Share on other sites
0 noobzter003 3 Posted July 23, 2018 19 minutes ago, Mahiro1 said: 'char_id' should start at 150000 the way it is there: 1, 2, 3 ... it's wrong how to make it starts with 15000? where should i edit this? Quote Share this post Link to post Share on other sites
0 Mahiro1 1 Posted July 23, 2018 (edited) 11 minutos atrás, noobzter003 disse: como fazer isso começa com 15000? onde devo editar isso? clique duas vezes no número "char_id" Edit: or click edit Edited July 23, 2018 by Mahiro1 Quote Share this post Link to post Share on other sites
0 noobzter003 3 Posted July 24, 2018 18 hours ago, Mahiro1 said: clique duas vezes no número "char_id" Edit: or click edit i know how to edit but the problem is when i create new character the char_id starts with 1 again. should be starts with 150001 something like that. how to fix this? Quote Share this post Link to post Share on other sites
0 Dastgir 1246 Posted July 24, 2018 2 minutes ago, noobzter003 said: i know how to edit but the problem is when i create new character the char_id starts with 1 again. should be starts with 150001 something like that. how to fix this? https://stackoverflow.com/questions/970597/change-auto-increment-starting-number https://dba.stackexchange.com/questions/43812/how-can-i-reset-a-mysql-table-auto-increment-to-1-in-phpmyadmin Change the value to (maximum_char_id+1) Quote Share this post Link to post Share on other sites
0 noobzter003 3 Posted July 24, 2018 (edited) 10 minutes ago, Dastgir said: https://stackoverflow.com/questions/970597/change-auto-increment-starting-number https://dba.stackexchange.com/questions/43812/how-can-i-reset-a-mysql-table-auto-increment-to-1-in-phpmyadmin Change the value to (maximum_char_id+1) thanks for your reply. but i dont really understand. ist like this? ALTER TABLE tbl AUTO_INCREMENT = 150000; Edited July 24, 2018 by noobzter003 Quote Share this post Link to post Share on other sites
0 noobzter003 3 Posted July 24, 2018 12 minutes ago, Dastgir said: https://stackoverflow.com/questions/970597/change-auto-increment-starting-number https://dba.stackexchange.com/questions/43812/how-can-i-reset-a-mysql-table-auto-increment-to-1-in-phpmyadmin Change the value to (maximum_char_id+1) thanks you i understand already. Quote Share this post Link to post Share on other sites
Anyone Can Help me about this Error. TIA
Share this post
Link to post
Share on other sites