Xtykutl

My goal is to let users upload files to user-specific folders.

The error I get is

no such column: notendur_document.user_id

Here is the relevant part of my views.py file. This is where the upload happens.

@login_required

def list(request):

    # Handle file upload

    if request.method == 'POST':

        form = DocumentForm(request.POST, request.FILES)

        if form.is_valid():

            newdoc = Document(docfile = request.FILES['docfile'])

            newdoc.save()



            # Redirect to the document list after POST

            return HttpResponseRedirect(reverse('notendur.views.list'))

    else:

        form = DocumentForm() # An empty, unbound form



    # Load documents for the list page

    documents = Document.objects.all()



    # Render list page with the documents and the form

    return render_to_response(

        'notendur/list.html',

        {'documents': documents, 'form': form},

        context_instance=RequestContext(request)

    )

This is my models.py file:

def _upload_path(instance,filename):

    return instance.get_upload_path(filename)



class Document(models.Model):

    docfile = models.FileField(upload_to=_upload_path)

    user = models.ForeignKey(User)



    def get_upload_path(self,filename):

        return "media/uploads/"+str(self.user.id) + "/" + '%Y.%m.%d' + filename

According to the relevant .html file, the error happens in the documents variable in list().

register user method in views.py:

def register_user(request):

    if request.method == "POST":

        form = UserCreationForm(request.POST)

        if form.is_valid():

            form.save()

            return HttpResponseRedirect('/accounts/register_success')



    args  = {}

    args.update(csrf(request))



    args['form'] = UserCreationForm()



    return render_to_response('register.html', args)

Just pass pk=True in your foreingkey
ex. user = models.ForeignKey(User,pk=True)
this will solve the issue