Jump to content
  • 0
noobzter003

Failed Assertion

Question

13 answers to this question

Recommended Posts

  • 0

this is known innodb issue.

First character can have wrong id. Fix it manually or remove character with id smaller than 150000

Share this post


Link to post
Share on other sites
  • 0
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.

Screen Shot 2018-07-02 at 1.17.45 PM.png

Share this post


Link to post
Share on other sites
  • 0
Just now, noobzter003 said:

thanks for answering my problem sir. but what should i edit here.

Screen Shot 2018-07-02 at 1.17.45 PM.png

do i need to change in to

150001   

150002   

150003 like this?

 

Share this post


Link to post
Share on other sites
  • 0

no, you looking wrong field. issue with char_id. char_id must be 15000 or bigger

 

 

Share this post


Link to post
Share on other sites
  • 0
9 minutes ago, noobzter003 said:

esta é minha tabela char.

o que é o problema .. desculpe, eu não entendi.

 

Untitled.png

'char_id' should start at 150000

the way it is there: 1, 2, 3 ... it's wrong

Share this post


Link to post
Share on other sites
  • 0
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?

Share this post


Link to post
Share on other sites
  • 0
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 by Mahiro1

Share this post


Link to post
Share on other sites
  • 0
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?

 

Share this post


Link to post
Share on other sites
  • 0
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)

Share this post


Link to post
Share on other sites
  • 0
10 minutes ago, Dastgir said:

thanks for your reply. but i dont really understand.

ist like this?

 

ALTER TABLE tbl AUTO_INCREMENT = 150000;
Edited by noobzter003

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

×
×
  • Create New...

Important Information

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