python3 manage.py migrate got an error

Question

I just started a new project and change database engine

DATABASES = { 'default': { 'ENGINE': 'mysql.connector.django', 'NAME': 'mysite', 'USER': 'root', 'PASSWORD': 'mypassword', 'HOST': '127.0.0.1', 'PORT': '3306', }

} then after running python3 manage.py migrate i got an error:

Operations to perform: Apply all migrations: admin, auth, contenttypes, sessions Running migrations: Applying contenttypes.0001_initial...Traceback (most recent call last): File "/usr/local/lib/python3.5/site-packages/mysql/connector/django/base.py", line 177, in _execute_wrapper return method(query, args) File "/usr/local/lib/python3.5/site-packages/mysql/connector/cursor.py", line 515, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/local/lib/python3.5/site-packages/mysql/connector/cursor.py", line 434, in _handle_result self._handle_noresultset(result) File "/usr/local/lib/python3.5/site-packages/mysql/connector/cursor.py", line 404, in _handle_noresultset self._warnings[0][1], self._warnings[0][2]) mysql.connector.errors.DatabaseError: 1265: Data truncated for column 'applied' at row 1

It looks like you shortent a field applied and the data does not fit in there anymore. — Klaus D.
– Klaus D., Commented Oct 24, 2016 at 5:22
i hadn't installed my apps,just use 'django.contrib.admin','django.contrib.auth',and so on,how to change the the type of 'applied'? — Gxp
– Gxp, Commented Oct 24, 2016 at 8:36

damores · Accepted Answer · 2016-10-24 04:09:38Z

1

You have to:

python3 manage.py makemigrations

And then:

python3 manage.py migrate

Then you can safely start the server again

Hope this helps

answered Oct 24, 2016 at 4:09

damores

2,3612 gold badges21 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gxp Over a year ago

unluckily,it doesn't work. if i use sqlite3,it works well.

Sherman Chen Over a year ago

It did not work for me, either.

Collectives™ on Stack Overflow

python3 manage.py migrate got an error

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related