Django - Postcode Issue












0















I am having issues with the postcode in my models.py file. I get the attached error. Can anybody help me?Error Message



Models.py






from __future__ import unicode_literals
from django.db import models

# Create your models here.
from django.contrib.auth.models import User
from django.db.models.signals import post_save
from django.dispatch import receiver
from django.utils import timezone


# Create your models here.
class UserProfile(models.Model):
image = models.ImageField(upload_to='images', default='Upload Picture')
user = models.OneToOneField(User, on_delete=models.CASCADE, related_name="profile")
address1 = models.CharField(max_length=255, blank=True)
address2 = models.CharField(max_length=255, blank=True)
eircode = models.CharField(max_length=7, default="V93CY93")
email = models.CharField(max_length=50, blank=True, null=True)
phone = models.CharField(max_length=10, blank=True)
dob = models.CharField(max_length=10, blank=True)
gender = models.CharField(max_length=1, blank=True)

class KidProfile(models.Model):
parent = models.ForeignKey(User, related_name='kids')
name = models.CharField(max_length=255, null=True, blank=True)
dob = models.CharField(max_length=10, null=True, blank=True)
gender = models.CharField(max_length=1, null=True, blank=True)

def __str__ (self):
return self.name












share|improve this question



























    0















    I am having issues with the postcode in my models.py file. I get the attached error. Can anybody help me?Error Message



    Models.py






    from __future__ import unicode_literals
    from django.db import models

    # Create your models here.
    from django.contrib.auth.models import User
    from django.db.models.signals import post_save
    from django.dispatch import receiver
    from django.utils import timezone


    # Create your models here.
    class UserProfile(models.Model):
    image = models.ImageField(upload_to='images', default='Upload Picture')
    user = models.OneToOneField(User, on_delete=models.CASCADE, related_name="profile")
    address1 = models.CharField(max_length=255, blank=True)
    address2 = models.CharField(max_length=255, blank=True)
    eircode = models.CharField(max_length=7, default="V93CY93")
    email = models.CharField(max_length=50, blank=True, null=True)
    phone = models.CharField(max_length=10, blank=True)
    dob = models.CharField(max_length=10, blank=True)
    gender = models.CharField(max_length=1, blank=True)

    class KidProfile(models.Model):
    parent = models.ForeignKey(User, related_name='kids')
    name = models.CharField(max_length=255, null=True, blank=True)
    dob = models.CharField(max_length=10, null=True, blank=True)
    gender = models.CharField(max_length=1, null=True, blank=True)

    def __str__ (self):
    return self.name












    share|improve this question

























      0












      0








      0








      I am having issues with the postcode in my models.py file. I get the attached error. Can anybody help me?Error Message



      Models.py






      from __future__ import unicode_literals
      from django.db import models

      # Create your models here.
      from django.contrib.auth.models import User
      from django.db.models.signals import post_save
      from django.dispatch import receiver
      from django.utils import timezone


      # Create your models here.
      class UserProfile(models.Model):
      image = models.ImageField(upload_to='images', default='Upload Picture')
      user = models.OneToOneField(User, on_delete=models.CASCADE, related_name="profile")
      address1 = models.CharField(max_length=255, blank=True)
      address2 = models.CharField(max_length=255, blank=True)
      eircode = models.CharField(max_length=7, default="V93CY93")
      email = models.CharField(max_length=50, blank=True, null=True)
      phone = models.CharField(max_length=10, blank=True)
      dob = models.CharField(max_length=10, blank=True)
      gender = models.CharField(max_length=1, blank=True)

      class KidProfile(models.Model):
      parent = models.ForeignKey(User, related_name='kids')
      name = models.CharField(max_length=255, null=True, blank=True)
      dob = models.CharField(max_length=10, null=True, blank=True)
      gender = models.CharField(max_length=1, null=True, blank=True)

      def __str__ (self):
      return self.name












      share|improve this question














      I am having issues with the postcode in my models.py file. I get the attached error. Can anybody help me?Error Message



      Models.py






      from __future__ import unicode_literals
      from django.db import models

      # Create your models here.
      from django.contrib.auth.models import User
      from django.db.models.signals import post_save
      from django.dispatch import receiver
      from django.utils import timezone


      # Create your models here.
      class UserProfile(models.Model):
      image = models.ImageField(upload_to='images', default='Upload Picture')
      user = models.OneToOneField(User, on_delete=models.CASCADE, related_name="profile")
      address1 = models.CharField(max_length=255, blank=True)
      address2 = models.CharField(max_length=255, blank=True)
      eircode = models.CharField(max_length=7, default="V93CY93")
      email = models.CharField(max_length=50, blank=True, null=True)
      phone = models.CharField(max_length=10, blank=True)
      dob = models.CharField(max_length=10, blank=True)
      gender = models.CharField(max_length=1, blank=True)

      class KidProfile(models.Model):
      parent = models.ForeignKey(User, related_name='kids')
      name = models.CharField(max_length=255, null=True, blank=True)
      dob = models.CharField(max_length=10, null=True, blank=True)
      gender = models.CharField(max_length=1, null=True, blank=True)

      def __str__ (self):
      return self.name








      from __future__ import unicode_literals
      from django.db import models

      # Create your models here.
      from django.contrib.auth.models import User
      from django.db.models.signals import post_save
      from django.dispatch import receiver
      from django.utils import timezone


      # Create your models here.
      class UserProfile(models.Model):
      image = models.ImageField(upload_to='images', default='Upload Picture')
      user = models.OneToOneField(User, on_delete=models.CASCADE, related_name="profile")
      address1 = models.CharField(max_length=255, blank=True)
      address2 = models.CharField(max_length=255, blank=True)
      eircode = models.CharField(max_length=7, default="V93CY93")
      email = models.CharField(max_length=50, blank=True, null=True)
      phone = models.CharField(max_length=10, blank=True)
      dob = models.CharField(max_length=10, blank=True)
      gender = models.CharField(max_length=1, blank=True)

      class KidProfile(models.Model):
      parent = models.ForeignKey(User, related_name='kids')
      name = models.CharField(max_length=255, null=True, blank=True)
      dob = models.CharField(max_length=10, null=True, blank=True)
      gender = models.CharField(max_length=1, null=True, blank=True)

      def __str__ (self):
      return self.name





      from __future__ import unicode_literals
      from django.db import models

      # Create your models here.
      from django.contrib.auth.models import User
      from django.db.models.signals import post_save
      from django.dispatch import receiver
      from django.utils import timezone


      # Create your models here.
      class UserProfile(models.Model):
      image = models.ImageField(upload_to='images', default='Upload Picture')
      user = models.OneToOneField(User, on_delete=models.CASCADE, related_name="profile")
      address1 = models.CharField(max_length=255, blank=True)
      address2 = models.CharField(max_length=255, blank=True)
      eircode = models.CharField(max_length=7, default="V93CY93")
      email = models.CharField(max_length=50, blank=True, null=True)
      phone = models.CharField(max_length=10, blank=True)
      dob = models.CharField(max_length=10, blank=True)
      gender = models.CharField(max_length=1, blank=True)

      class KidProfile(models.Model):
      parent = models.ForeignKey(User, related_name='kids')
      name = models.CharField(max_length=255, null=True, blank=True)
      dob = models.CharField(max_length=10, null=True, blank=True)
      gender = models.CharField(max_length=1, null=True, blank=True)

      def __str__ (self):
      return self.name






      django-models






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 20 '18 at 13:43









      Pierce O'NeillPierce O'Neill

      22110




      22110
























          1 Answer
          1






          active

          oldest

          votes


















          0














          You are trying to insert a null value into not null column named "postcode" in your table. postcode is not present in your "UserProfile" model class.






          share|improve this answer
























          • Thank you so much! Its working. We call postcode EIRCODE in Ireland.

            – Pierce O'Neill
            Nov 20 '18 at 14:22











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53394374%2fdjango-postcode-issue%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          You are trying to insert a null value into not null column named "postcode" in your table. postcode is not present in your "UserProfile" model class.






          share|improve this answer
























          • Thank you so much! Its working. We call postcode EIRCODE in Ireland.

            – Pierce O'Neill
            Nov 20 '18 at 14:22
















          0














          You are trying to insert a null value into not null column named "postcode" in your table. postcode is not present in your "UserProfile" model class.






          share|improve this answer
























          • Thank you so much! Its working. We call postcode EIRCODE in Ireland.

            – Pierce O'Neill
            Nov 20 '18 at 14:22














          0












          0








          0







          You are trying to insert a null value into not null column named "postcode" in your table. postcode is not present in your "UserProfile" model class.






          share|improve this answer













          You are trying to insert a null value into not null column named "postcode" in your table. postcode is not present in your "UserProfile" model class.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 20 '18 at 14:04









          Dinesh MandepudiDinesh Mandepudi

          261




          261













          • Thank you so much! Its working. We call postcode EIRCODE in Ireland.

            – Pierce O'Neill
            Nov 20 '18 at 14:22



















          • Thank you so much! Its working. We call postcode EIRCODE in Ireland.

            – Pierce O'Neill
            Nov 20 '18 at 14:22

















          Thank you so much! Its working. We call postcode EIRCODE in Ireland.

          – Pierce O'Neill
          Nov 20 '18 at 14:22





          Thank you so much! Its working. We call postcode EIRCODE in Ireland.

          – Pierce O'Neill
          Nov 20 '18 at 14:22


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53394374%2fdjango-postcode-issue%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          'app-layout' is not a known element: how to share Component with different Modules

          android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

          WPF add header to Image with URL pettitions [duplicate]