尝试编辑/创建时，Django 管理员针对特定模型挂起（直到超时错误）

发布于 2024-11-04 02:07:23 字数 1341 浏览 3 评论 0原文

这个现在让我抓狂。以前没有发生过这种情况（甚至还得到了我必须为用户手册做的屏幕截图，因为客户需要它）。

我首先在生产服务器上注意到它，然后我检查了它，并且也发生在 Django 附带的开发服务器中。该模型出现在 django admin 的主页上，我可以单击它，它将显示销售点列表。每当我想要编辑现有实例或创建新实例时，就会出现问题。

我只需单击链接（或将其放在栏上），它就会挂起。

class PointOfSaleAdmin(admin.ModelAdmin):
    list_display = ('id','business', 'user', 'zipcode', 'address','date_registered')
    list_filter = ('business',)
    filter_horizontal = ('services',)
admin.site.register(models.PointOfSale, PointOfSaleAdmin)

这就是模型的注册。所有模型都在管理应用程序中注册，测试的用户是超级用户。该模型是：

class PointOfSale(models.Model):
    user = models.ForeignKey(User)
    zipcode = models.ForeignKey(Zipcode)
    business = models.ForeignKey(Business)
    services = models.ManyToManyField(Service, 
        verbose_name='available services')
    date_registered = models.DateField(auto_now_add=True)
    address = models.CharField(max_length=300)

加上一些实际上并不重要的方法。另外，在此之前我上次测试管理员是在我创建所有这些方法之后，所以这应该不重要。

管理员很少需要访问此页面。通常它只是列出 PoS，但这仍然困扰着我。知道为什么它会挂起来吗？所有其他型号都工作正常。

这发生在 Django 1.2.5 和 1.3

编辑：

我修改了超时限制。它正在工作，但不知何故需要几分钟才能真正发生。所以，背景中有一些东西需要很长时间才能完成。我不明白为什么它只发生在这个模型上，而且它发生在不同的环境中（并且数据集很小），

我几乎想打自己一巴掌。怪我这么久没睡觉。

问题是邮政编码列表相当大（数十万），并且外键字段作为 html 选择标记加载，这意味着它加载每个条目。这只是有多少数据的问题。

现在我想知道如何控制外键在管理中的显示方式。有人可以帮忙吗？

原文

This one is driving me nuts right now. It was not happening before (even got screenshots I had to do for the user-manual since the customer required it).

I first noticed it on production server and then I checked and also happens in the dev server that comes with Django. The model appears on the main-page of the django admin, I can click it and it will display the list of point of sales. The problem comes whenever I want to edit an existing instance or create a new one.

I just click on the link (or put it on the bar) and it just hangs.

class PointOfSaleAdmin(admin.ModelAdmin):
    list_display = ('id','business', 'user', 'zipcode', 'address','date_registered')
    list_filter = ('business',)
    filter_horizontal = ('services',)
admin.site.register(models.PointOfSale, PointOfSaleAdmin)

That's the registration of the model. All models are registered in the admin application and the user to test this is a super user. The model is:

class PointOfSale(models.Model):
    user = models.ForeignKey(User)
    zipcode = models.ForeignKey(Zipcode)
    business = models.ForeignKey(Business)
    services = models.ManyToManyField(Service, 
        verbose_name='available services')
    date_registered = models.DateField(auto_now_add=True)
    address = models.CharField(max_length=300)

Plus a few methods that shouldn't really matter much. Plus, last time before this that I tested the admin was right after I created all those methods, so it shouldn't matter on this.

The administrator very very rarely has to access this page. Usually it's just listing the PoS, but it still bothers me. Any idea of why it could be hanging? All other models are working just fine.

This is happening on both Django 1.2.5 and 1.3

EDIT:

I modified the timeout limits. It IS working, but somehow it takes several minutes for it to actually happen. So, there is something in the background that is taking ages. I don't understand how come it happens only for this model and it happens in different environments (and with small datasets)

I almost feel like slapping myself. My fault for not sleeping for so long.

The problem is that the zipcode list is pretty big (dozens of thousands) and the foreign key field is loaded as an html select tag, which means it loads every single entry. It's an issue with how much data there is simply.

Now I wonder how to control the way the foreign key is displayed in the admin. Anyone could help with that?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

一袭水袖舞倾城 2024-11-11 02:07:25

我只是想补充一点，这里的另一个选项是创建一个 read_only_fields 列表。如果与具有大量选择的模型存在关系（在我的情况下，大量用户和讨论线程之间的相关表编目标志），但您不需要编辑该字段。您可以将其添加到 read_only_fields 列表中，这样只会打印值而不是选项。

class FlaggedCommentsAdmin(ModelAdmin):
    list_display = ('user', 'discussion', 'flagged_on')
    readonly_fields = ('user', 'discussion')

I just wanted to add that another option here is creating a read_only_fields list. In cases where there is a relationship to a model with a large number of choices(in my case a rel table cataloging flags between a large number of users and discussion threads) but you don't need to edit the field. You can add it to the read_only_fields list will just print the value rather than the choices.

class FlaggedCommentsAdmin(ModelAdmin):
    list_display = ('user', 'discussion', 'flagged_on')
    readonly_fields = ('user', 'discussion')

回复收藏 0 原文

╰◇生如夏花灿烂 2024-11-11 02:07:25

对于仍然登陆此页面的人：正如 Mamsaac 在他的原始帖子中指出的那样，超时发生是因为 django 尝试将 ForeignKey 的所有实例加载到 html-select 中。 Django 2 允许您添加自动-完整字段，它允许您异步搜索ForeignKey来处理这个问题。在您的 admin.py 中执行以下操作：

from django.contrib import admin
from .models import Parent, Child

@admin.register(Parent)
class ParentAdmin(admin.ModelAdmin):
    # tell admin to autocomplete-select the "Parent"-field 'children'
    autocomplete_fields = ['children']

@admin.register(Child)
class ChildAdmin(admin.ModelAdmin):
    # when using an autocomplete to find a child, search in the field 'name'
    search_fields = ['name']

For people still landing on this page: As Mamsaac points out in his original post, the timeout happens because django tries to load all instances of a ForeignKey into an html-select. Django 2 lets you add an auto-complete field which asynchronously lets you search for the ForeignKey to deal with this. In your admin.py do something like this:

from django.contrib import admin
from .models import Parent, Child

@admin.register(Parent)
class ParentAdmin(admin.ModelAdmin):
    # tell admin to autocomplete-select the "Parent"-field 'children'
    autocomplete_fields = ['children']

@admin.register(Child)
class ChildAdmin(admin.ModelAdmin):
    # when using an autocomplete to find a child, search in the field 'name'
    search_fields = ['name']

回复收藏 0 原文