/ posts / 12 / new-comment / NOT NULL约束处的IntegrityError失败:posts_comment.author_id

闪电妈妈

好吧,我在我的项目中添加了评论系统,但是出现了完整性错误。我不知道该怎么解决。我已经问过这个问题一次,但现在已经回答了。但是现在我再问一次,希望有人能详细回答。我将非常感谢你。

view.py

class CommentCreateView(CreateView):
    redirect_field_name='posts/post_detail.html' 
    model = Comment
    form_class = CommentForm
    template_name = "posts/snippets/comment_form.html"

    def form_valid(self, form):
        form.instance.post_id = self.kwargs['pk']
        return super().form_valid(form)

models.py

class Comment(models.Model):

    
    author = models.ForeignKey(User, on_delete=models.CASCADE)
    post = models.ForeignKey(Post,related_name='comments', on_delete=models.CASCADE)
    body = models.TextField()
    create_date = models.DateTimeField(auto_now_add=True)


    def __str__(self):
        return self.author.username

    def get_absolute_url(self):
        return reverse("posts:post_detail", kwargs={"pk": self.pk})

追溯:

Environment:


Request Method: POST
Request URL: http://127.0.0.1:8000/posts/12/new-comment/

Django Version: 3.0.3
Python Version: 3.8.3
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'bootstrap3',
 'accounts',
 'posts',
 'profiles']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware']



Traceback (most recent call last):
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\sqlite3\base.py", line 396, in execute
    return Database.Cursor.execute(self, query, params)

The above exception (NOT NULL constraint failed: posts_comment.author_id) was the direct cause of the following exception:
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\core\handlers\exception.py", line 34, in inner
    response = get_response(request)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\core\handlers\base.py", line 115, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\core\handlers\base.py", line 113, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\views\generic\base.py", line 71, in view
    return self.dispatch(request, *args, **kwargs)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\views\generic\base.py", line 97, in dispatch
    return handler(request, *args, **kwargs)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\views\generic\edit.py", line 172, in post
    return super().post(request, *args, **kwargs)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\views\generic\edit.py", line 142, in post
    return self.form_valid(form)
  File "C:\Users\AHMED\grapPub\grabpublic\posts\views.py", line 74, in form_valid
    return super().form_valid(form)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\views\generic\edit.py", line 125, in form_valid
    self.object = form.save()
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\forms\models.py", line 459, in save
    self.instance.save()
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\models\base.py", line 745, in save
    self.save_base(using=using, force_insert=force_insert,
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\models\base.py", line 782, in save_base
    updated = self._save_table(
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\models\base.py", line 887, in _save_table
    results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\models\base.py", line 924, in _do_insert
    return manager._insert(
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\models\manager.py", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\models\query.py", line 1204, in _insert
    return query.get_compiler(using=using).execute_sql(returning_fields)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\models\sql\compiler.py", line 1384, in execute_sql
    cursor.execute(sql, params)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\utils.py", line 100, in execute
    return super().execute(sql, params)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\utils.py", line 68, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "C:\Users\AHMED\anaconda3\lib\site-packages\django\db\backends\sqlite3\base.py", line 396, in execute
    return Database.Cursor.execute(self, query, params)

Exception Type: IntegrityError at /posts/12/new-comment/
Exception Value: NOT NULL constraint failed: posts_comment.author_id

如果需要更多细节,请告诉我。我将使用该信息更新答案。

威廉·范昂塞姆

您需要将登录用户分配为作者:

from django.contrib.auth.mixins import LoginRequiredMixin

class CommentCreateView(LoginRequiredMixin, CreateView):
    redirect_field_name='posts/post_detail.html' 
    model = Comment
    form_class = CommentForm
    template_name = "posts/snippets/comment_form.html"

    def form_valid(self, form):
        form.instance.post_id = self.kwargs['pk']
        form.instance.author = self.request.user
        return super().form_valid(form)

还有一个错误的.get_absolute_url(…)方法[Django的文档]中的Comment类,因为你使用的是职位的详细信息页面,该pk参数应该是的idpost对象,所以你可以使用self.post_id

class Comment(models.Model):
    # …
    
    def get_absolute_url(self):
        return reverse('posts:post_detail', kwargs={'pk': self.post_id})

注意:您可以使用LoginRequiredMixinmixin [Django-doc]将视图限制为基于类的视图,以供已认证的用户使用


注意:通常,最好使用settings.AUTH_USER_MODEL[Django-doc]来引用用户模型,而不是直接使用User模型[Django-doc]有关更多信息,请参见参考User文档模型部分

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

Laravel 5说:““字段列表”中的未知列“ user_id””,但是我有“ author_id”

来自分类Dev

New Relic是否支持openJDK12?

来自分类Dev

Author#new中的NoMethodError

来自分类Dev

通过另一个表CakePHP的author_id从另一个表获取用户名

来自分类Dev

Odoo v12查找视图ID

来自分类Dev

12小时格式的日期和时间字符串中的JavaScript New Date

来自分类Dev

苹果的New York字体可以在iOS 12中使用吗?

来自分类Dev

授予 new_user 角色在 12C 中不起作用

来自分类Dev

Not unique in the new ID space | ZK

来自分类Dev

从p12 / pem文件获取包ID

来自分类Dev

如何在Discordjs 12中按ID获取用户?

来自分类Dev

将每组 product_id 乘以 12 个月

来自分类Dev

ODOO12:如何检索登录用户的 id?

来自分类Dev

在 wordpress 中显示 id 12 到 25 之间的帖子

来自分类Dev

使用,htaccess将example.com?id=12重定向到example.com/index.php?id=12

来自分类Dev

ActiveRecord :: RecordNotFound找不到'id'= new

来自分类Dev

我想将URL http://www.website.com/picture.php?id=12重写为http://www.website.com/picture/id/12

来自分类Dev

为什么是Array.new(10){| e | e = e + 2}产生[0 2 4 6 8 10 12 14 16 18]?

来自分类Dev

android.content.res.Resources $ NotFoundException:字符串资源ID#0x12-onLocationChanged()

来自分类Dev

如何从Discord.js v12中的guild.fetch获取ID?

来自分类Dev

2020年12月,状态-“部署ID与当前项目未关联”

来自分类Dev

Qlikview文本对象(框)中最近12个月的ID计数

来自分类Dev

蓝牙适配器配置问题(ID 0a12:0001)

来自分类Dev

如何在 IOS 12 中用新收到的通知(包含相同的通知 ID)替换推送通知

来自分类Dev

如何获取网址“ / relationships / new?followed_id = bob”以代替阅读“ relationships / new / bob”?

来自分类Dev

Generating a new Mongo object id for each document in a collection?

来自分类Dev

SQLAlchemy:使用new_values(id,field)as(values(...,...))

来自分类Dev

触发函数中基于NEW.id的动态SUM

来自分类Dev

.new没有为新对象分配ID

来自分类Dev

如何正确地为 id 和 new 制作路由?

Related 相关文章

  1. 1

    Laravel 5说:““字段列表”中的未知列“ user_id””,但是我有“ author_id”

  2. 2

    New Relic是否支持openJDK12?

  3. 3

    Author#new中的NoMethodError

  4. 4

    通过另一个表CakePHP的author_id从另一个表获取用户名

  5. 5

    Odoo v12查找视图ID

  6. 6

    12小时格式的日期和时间字符串中的JavaScript New Date

  7. 7

    苹果的New York字体可以在iOS 12中使用吗?

  8. 8

    授予 new_user 角色在 12C 中不起作用

  9. 9

    Not unique in the new ID space | ZK

  10. 10

    从p12 / pem文件获取包ID

  11. 11

    如何在Discordjs 12中按ID获取用户?

  12. 12

    将每组 product_id 乘以 12 个月

  13. 13

    ODOO12:如何检索登录用户的 id?

  14. 14

    在 wordpress 中显示 id 12 到 25 之间的帖子

  15. 15

    使用,htaccess将example.com?id=12重定向到example.com/index.php?id=12

  16. 16

    ActiveRecord :: RecordNotFound找不到'id'= new

  17. 17

    我想将URL http://www.website.com/picture.php?id=12重写为http://www.website.com/picture/id/12

  18. 18

    为什么是Array.new(10){| e | e = e + 2}产生[0 2 4 6 8 10 12 14 16 18]?

  19. 19

    android.content.res.Resources $ NotFoundException:字符串资源ID#0x12-onLocationChanged()

  20. 20

    如何从Discord.js v12中的guild.fetch获取ID?

  21. 21

    2020年12月,状态-“部署ID与当前项目未关联”

  22. 22

    Qlikview文本对象(框)中最近12个月的ID计数

  23. 23

    蓝牙适配器配置问题(ID 0a12:0001)

  24. 24

    如何在 IOS 12 中用新收到的通知(包含相同的通知 ID)替换推送通知

  25. 25

    如何获取网址“ / relationships / new?followed_id = bob”以代替阅读“ relationships / new / bob”?

  26. 26

    Generating a new Mongo object id for each document in a collection?

  27. 27

    SQLAlchemy:使用new_values(id,field)as(values(...,...))

  28. 28

    触发函数中基于NEW.id的动态SUM

  29. 29

    .new没有为新对象分配ID

  30. 30

    如何正确地为 id 和 new 制作路由?

热门标签

归档