#6062: integrity error Date field auto_now_add for RelatedKey field object data
(edit_inline)
--------------------------------+-------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: nobody
Status: new | Component: Admin interface
Version: SVN | Keywords:
Stage: Unreviewed | Has_patch: 1
--------------------------------+-------------------------------------------
Hello,
I also stepped to problem similar to ticket:3156 (but this bug is another
branch, also problem only looks similar, but patch is different)
I have Order, and related model !GoogleOrderInformation which I want to
see/edit inline.
Here is related part of model code:
{{{
#!python
class GoogleOrderInformation(models.Model):
order =
models.ForeignKey(Order,edit_inline=models.STACKED,max_num_in_admin=1)
google_order_number = models.CharField(maxlength=40)
....
added = models.DateTimeField(auto_now_add = True)
changed = models.DateTimeField(auto_now = True)
...
}}}
When I hit "save" button in Django oldforms admin, I get this error:
{{{
Exception Type: IntegrityError
Exception Value: null value in column "added" violates not-null
constraint
}}}
And the actual SQL code at the bottom shows me this:
{{{
'UPDATE "GoogleCheckout_googleorderinformation" SET
"order_id"=\'8314\',"google_order_number"=\'das\',"added"=NULL,"changed"=\'2007-11-30
16:29:26.995612\',"eligible_for_protection"=true,"avs_response"=\'f\',"cvn_response"=\'f\',"partial_cc_number"=\'sfsd\',"buyer_account_age"=NULL,"timestamp"=\'2007-11-30
18:18:09\' WHERE "id"=\'2\''
}}}
I've looked at actual manipulators code (btw not easy to read/understand)
and patched it quickly.
I would like to share this patch with Django community, so anyone else
encountering same problem will be able to patch it.
Attached is patch, as it works for me. No guarantees that it works for
you.
I did not made tests, neither I tested it for MySQL or SQLlite. That is
because I've been told a number of times that all patches to oldforms
admin
are not useful, and will be refused anyway, so I don't want to spend much
of my time on this. Just use patch if it fixes your problem, and lets
hope all for a quicker release of newforms-admin.
--
Ticket URL: <http://code.djangoproject.com/ticket/6062>
Django Code <http://code.djangoproject.com/>
The web framework for perfectionists with deadlines
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
