Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Data truncated for column 'cur_url' at row 1

Tags:

python

django

Using django-socialregistration, got error messages:

Data truncated for column 'cur_url' at row 1

What went wrong here?

like image 232
Elisa Avatar asked Nov 30 '11 04:11

Elisa


People also ask

How do I fix truncated data?

How do I fix truncated data? Fix the data that we are trying to insert or update. Data length should not exceed the maximum allowed limit for the particular column. Use 'SET ANSI_WARNINGS OFF' to truncate the data and insert it as per column maximum string length.

What is Data truncated for column?

Truncated means “cut short”, and “data truncated” warnings or errors refer to a value's data being cut off at the end during the importing process (e.g. a value of “2.9823” being imported as “2.98”). These errors are important warnings, because it notifies us that our data has not been imported accurately.


1 Answers

You have tried to insert a larger value than field accepts, so it was literally "cut to fit".

like image 66
favoretti Avatar answered Sep 28 '22 06:09

favoretti