• 0
noobzter003

Failed Assertion

Question

13 answers to this question

  • 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
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.

 

Untitled.png

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now