在Django中自动填充User字段(没有这样的列)

Question

我试图在我的bucketlisttemform中自动填充'pub_date'字段。我已经能够使用时间和日期字段做到这一点，但在尝试使用'pub_by'字段做到这一点时，不断得到以下错误:

no such column: bucketlist_bucketlisttem。pub_by_id

在过去的几天里，我一直在玩我能想到的一切，并看着其他人在StackOverflow上发布了类似的问题，但似乎没有什么能解决我的问题。我将非常感激你能提供的任何帮助!

forms.py

class BucketListItemForm(forms.ModelForm):
class Meta:
    model = BucketListItem

models.py

class BucketListItem(models.Model):
text = models.CharField(max_length = 200)
pub_by = models.ForeignKey(User)
pub_date = models.DateTimeField(editable=False)
def __unicode__(self):
    return self.text
def recently_added(self):
    return self.pub_date >= timezone.now() - datetime.timedelta(days = 1)
recently_added.boolean = True
def save(self):
    if not self.id:
        self.pub_date = timezone.now()
    super(BucketListItem, self).save()

views.py

def index(request):
    all_list_items = BucketListItem.objects.all()
    context = {'all_list_items': all_list_items}
    return render(request, 'BucketList/index.html', context)
def my_list(request):
    personal_list = BucketListItem.objects.filter(pub_by = request.user.username)
    context = {'personal_list': personal_list,
                  'user': request.user.username}
    return render(request, 'BucketList/mylist.html', context)
def create(request):
    if request.POST:
        form = BucketListItemForm(request.POST)
        if form.is_valid():
            form.save()
            return HttpResponseRedirect('/bucketlist/mylist')
    else:
        form = BucketListItemForm()
    args = {}
    args.update(csrf(request))
    args['form'] = form
    return render_to_response('BucketList/create_item.html', args)

admin.py

class BucketListItemAdmin(admin.ModelAdmin):
    fieldsets = [
        ('Text',              {'fields': ['text']}),
    ]
    readonly_fields = ('pub_date',)
    list_display = ['text', 'pub_date', 'pub_by', 'recently_added']
    list_filter = ['pub_date', 'pub_by']
    search_fields = ['text']
def save_model(self, request, obj, form, change):
    if not change:
        obj.user = request.user
    super(self.__class__, self).save_model(request, obj, form, change)
admin.site.register(BucketListItem, BucketListItemAdmin)

mylist.html

{% if user %}
<h1>{{user}}'s Bucket List</h1>
{% if personal_list %}
    <ol>
    {% for item in personal_list %}
        <li>{{ item.text }}</li>
    {% endfor %}
    </ol>
{% else %}
    <p>You don't have any Bucket List items yet!  Better get on that.</p>
{% endif %}
{% else %}
    <p>Sorry, it doesn't seem like you are logged in!</p>
{% endif %}

create_item.html

<form action = "/bucketlist/create/" method = "post">{% csrf_token %}
<ul>
{{form.as_ul}}
</ul>
<input type = "submit" name = "submit" value = "Create BucketListItem">
</form>

Answer 1

看起来您在更新代码后忘记同步数据库了。尝试删除您正在使用的数据库(或删除它)并再次运行syncdb。我可以帮助你进一步，如果你张贴你的完整代码ie html文件与呈现的形式，如果这不起作用。