I am using my existing mysql db. I found out that if I have an enum and try
to insert a value not present in the enum this error will occur.
However, my problem occurs on a TimeField. I created this field using
phpMyAdmin, it is a timestamp, and default is current time. Therefore, I
did the following in my Django model:
message_create_time = models.TimeField(auto_now_add=True)
When I create an object, and save, it gives me:
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line
463, in save
self.save_base(using=using, force_insert=force_insert,
force_update=force_update)
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line
551, in save_base
result = manager._insert([self], fields=fields, return_id=update_pk,
using=using, raw=raw)
File "/Library/Python/2.7/site-packages/django/db/models/manager.py",
line 203, in _insert
return insert_query(self.model, objs, fields, **kwargs)
File "/Library/Python/2.7/site-packages/django/db/models/query.py", line
1593, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File
"/Library/Python/2.7/site-packages/django/db/models/sql/compiler.py", line
912, in execute_sql
cursor.execute(sql, params)
File "/Library/Python/2.7/site-packages/django/db/backends/util.py", line
40, in execute
return self.cursor.execute(sql, params)
File
"/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line
114, in execute
return self.cursor.execute(query, args)
File
"/Library/Python/2.7/site-packages/MySQL_python-1.2.4-py2.7-macosx-10.8-intel.egg/MySQLdb/cursors.py",
line 203, in execute
if not self._defer_warnings: self._warning_check()
File
"/Library/Python/2.7/site-packages/MySQL_python-1.2.4-py2.7-macosx-10.8-intel.egg/MySQLdb/cursors.py",
line 117, in _warning_check
warn(w[-1], self.Warning, 3)
Warning: Data truncated for column 'message_create_time' at row 1
However if I change it to :
message_create_time = models.DateTimeField()
It works perfectly.
Any ideas?
Thanks in advance
On Tue, Jan 15, 2013 at 7:32 AM, Bill Freeman <ke1g...@gmail.com> wrote:
> Does the field in question have "max_length" specified (assuming that it
> is a character field or a sub class)? Does introspecting the database with
> the database's tools indicate that the corresponding field has that size?
> Was the database created using Django's syncdb, or are you attempting to
> use an existing database. Which database engine are you using (e,g.;
> PostgreSQL, MySQL, etc. - different people will have insights into
> different back ends)? Is a stack trace printed - if so, provide it for
> us? At least, what is the exact text of the error message?
>
> Bill
>
> On Tue, Jan 15, 2013 at 1:19 AM, Chen Xu <xuche...@gmail.com> wrote:
>
>> Hi Everyone,
>> I am new to Django, I am currently converting my site from php to Django.
>> I have already have my database (all the tables) setup when I wrote in php;
>> now when I convert to Django, I am basically matching each column with the
>> existing column. After I finished doing this, I try to create an object,
>> and doing a <object>.save() gives me Warning: Data truncated for column
>> '<some column>'. However, I checked, the length of my string did not excess
>> the limit.
>>
>> Could anyone help?
>>
>>
>> Thanks
>>
>>
>>
>>
>> --
>> ⚡ Chen Xu ⚡
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To post to this group, send email to django-users@googlegroups.com.
>> To unsubscribe from this group, send email to
>> django-users+unsubscr...@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/django-users?hl=en.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
--
⚡ Chen Xu ⚡
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
