antiblock
https://i.imgur.com/aJ17bf7.gif
  • Chatbox

    You don't have permission to chat.
    Load More
  • 0
Sign in to follow this  
mazage

I Have Problem Size Error, Check Your Db Structure

Question

this the pic when i save it say que 

 

Imagem colocada

 

 

can some one tell me how to fix this please i do this because i have problem with  query failed: Data truncated for column 'size' at row 1
 

 

so i see this pic how to solve the problem 

 

Imagem colocada

 

after i do this the error come like this pic 

 

 

Imagem colocada

 

 

 

so please tell me how to fix this problem with my thanks

Share this post


Link to post
Share on other sites

8 answers to this question

antiblock
https://i.imgur.com/aJ17bf7.gif
  • 0

Hi i do what u say its not fix its same ??? do we have other way to fix it 

Share this post


Link to post
Share on other sites
  • 0

i hope some one can help me with this thanks allot for ur trying helping :) 

Share this post


Link to post
Share on other sites
  • 0

That usually indicates you're trying to insert an out-of-range value to the column, check the underling database configuration. Since the data type is "set", you're restricted to the 3 defined values: "SMALL", "MEDIUM", "BIG". You're trying to insert unexpected data (i.e: not in the array). You can fix it by changing the value in the faulty row or changing the column's type.

Share this post


Link to post
Share on other sites
  • 0

can u explain for me more please i try to fix it but i filed :( hope some one help me with more explaining 

Share this post


Link to post
Share on other sites
  • 0

What haven't you understood? 

You can fix it by changing the value in the faulty row or changing the column's type.

The error message says a value is wrong at row 941, I just explained you why and how to fix it: change the value on said row or change the underling column's data type (varchar should work with anything).

Share this post


Link to post
Share on other sites
  • 0

my friend i think i find the problem is from the version off mysql 5.5.38 it shod be 5.5.33 with my thanks  

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
Sign in to follow this