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

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

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

×
×
  • Create New...

Important Information

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