Need help with auto_now_add and auto_now fields

[sarfaraz ahmed]

Hello Team,

I have a model and I have added two fields to User_Address model creation_date and updation_date. I have pasted the model code at pastebin. Please take a look. 

I am getting following error while running makemigrations command 

You are trying to add a non-nullable field 'creation_date' to user_address witho

ut a default; we can't do that (the database needs something to populate existin

g rows).

Please select a fix:

 1) Provide a one-off default now (will be set on all existing rows)

 2) Quit, and let me add a default in models.py

Select an option: 

Please help...

Regards,

Sarfaraz Ahmed

[sarfaraz ahmed]

I missed the pastebin link in my last post. Sorry...

Here is the model code

http://pastebin.com/5EF1hV8U

[rajan santhanam]

Hi Ahmed,

This message is because you hav few entries already present for that model in DB. If it is OK for you, you can add datetime.now as default value for the existing rows

Many Thanks
Rajan

[sarfaraz ahmed]

I have entries present in User Profile Table. But this field belongs to User_Address model which is new and does not have any entries present. Please advice.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CACO5KE9VA0QFKmk25HpEnwubKSpbk_6LUT%2BU%3DUwh7y0Dgu3YYw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Thanks with regards,
Sarfaraz Ahmed

[rajan santhanam]

No problem. Still you can provide an one off value by selecting option 1 and migrate. It won't have any impact.

I think this warning will arise on every occasion we alter the table structure irrespective of entry being there or not.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEPJdiy8sea_nbtewbyQpVmF54mrCSoe3XRReMrOKex%2B7mKktw%40mail.gmail.com.