# DETAIL:  Failing row contains (9, null, miarisoa00@yahoo.de, , null).
IntegrityError at /contact/contact/
null value in column "name" of relation "contact_contact" violates not-null constraint
DETAIL:  Failing row contains (9, null, miarisoa00@yahoo.de, , null).
Request Method: POST
Request URL: http://127.0.0.1:8000/contact/contact/
Django Version: 3.2.15
Exception Type: IntegrityError
Exception Value:
null value in column "name" of relation "contact_contact" violates not-null constraint
DETAIL:  Failing row contains (9, null, miarisoa00@yahoo.de, , null).
Exception Location: D:\MKSD_SITE\MKSD_WEB\site\lib\site-packages\django\db\backends\utils.py, line 84, in _execute
Python Executable: D:\MKSD_SITE\MKSD_WEB\site\Scripts\python.exe
Python Version: 3.9.13
Python Path:
['D:\\MKSD_SITE\\MKSD_WEB\\site\\src',
 'C:\\Program Files\\Python39\\python39.zip',
 'C:\\Program Files\\Python39\\DLLs',
 'C:\\Program Files\\Python39\\lib',
 'C:\\Program Files\\Python39',
 'D:\\MKSD_SITE\\MKSD_WEB\\site',
 'D:\\MKSD_SITE\\MKSD_WEB\\site\\lib\\site-packages']
Server time: Sun, 04 Jun 2023 16:39:42 +0000
**views.py**
def Kontact(request):
    if request.method == 'POST':
        contact = Contact()
        message_name     = request.POST.get('message-name')
        from_email       = request.POST.get('from-email')
        ville            = request.POST.get('ville')
        message          = request.POST.get('message')
        contact.name = message_name
        contact.email = from_email
        ville            = ville
        contact.subject = message
        contact.save()
        message = f"""
        Name: {message_name}
        From: {from_email}
        Stadt: {ville}
        New message: \n\n{message}
        """
        # Send email
        send_mail(
            message_name, #subject
            message, #message
            from_email, #from email
            ['kontakt.mksd@gmail.com'], #to email
            fail_silently=False,
            )
        return render(request, 'contact.html', {'message_name': message_name})
    else:
        return render(request, 'contact.html', {})
**models.py**
class Contact(models.Model):
    name = models.CharField(max_length=50)
    email = models.EmailField(max_length=50)
    ville = models.CharField(max_length=100)
    subject = models.TextField(max_length=355)
    def __str__(self):
        return self.name
**Template - HTML**
<div class="row">
    <form method="post" class="was-validated">
        {% csrf_token %}
        <div class="col-lg-6">Email (erforderlich):
            <input type="email" name="from-email" class="form-control mb-30" placeholder="Your Email" required>
        </div>
        <div class="col-lg-6">Phone
            <input type="phone" name="phone" class="form-control mb-30" placeholder="yours">
        </div>
        <div class="col-lg-6">Name (erforderlich):
            <input type="name" name="name" class="form-control mb-30" placeholder="Name" required>
        </div>
        <div class="col-lg-6">Stadt
            <input type="stadt" name="stadt" class="form-control mb-30" placeholder=" City">
        </div>
        <br><br><br>
        <div class="col-12">
            <textarea name="text" class="form-control mb-30" placeholder="text">
            </textarea>
        </div>
        <div class="col-12 my-3">
            <button type="submit" class="btn btn-success">
                Send
            </button>
        </div>
    </form>
</div>

# views.py:
def kontakt(request):
    if request.method == 'POST':
        message_name = request.POST['name']
        from_email = request.POST['from-email']
        ville = request.POST['stadt']
        message = request.POST['text']
        Contact.objects.create(
            name=message_name, email=from_email, ville=ville, subject=message
        )
        message = f"""
        Name: {message_name}
        From: {from_email}
        Stadt: {ville}
        New message: \n\n{message}
        """
        # 发送电子邮件
        send_mail(
            message_name,  # 主题
            message,  # 消息
            from_email,  # 发件人电子邮件
            ['kontakt.mksd@gmail.com'],  # 收件人电子邮件
            fail_silently=False,
        )
        return redirect('<em>name-of-some-view</em>')
    else:
        return render(request, 'contact.html', {})