Databases
StackOverflow2013
Postsdbo
PODjango DatabaseError "more than one row returned by a subquery used as an expression" Editable related fields to object
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODjango DatabaseError "more than one row returned by a subquery used as an expression" Editable related fields to object
    primarykey
    data
    text
    <p>I am trying to add inlines to my template but continue to get a Database error:</p> <pre><code> more than one row returned by a subquery used as an expression </code></pre> <p>I have 3 objects in my models.py that relate to each other. The user will be able to see which Teacher is selected and have all Owners under that Teacher listed (Teacher and Owner will only appear as an uneditable list). I'd like to have all the Pets under the Owner listed and editable. Any ideas on why I am receiving this error? And how I may be able to accomplish my goal?</p> <p><strong>models.py</strong></p> <pre><code>class Teacher(models.Model): teacher = models.CharField(max_length=300) class Owner(models.Model): relevantteacher = models.ForeignKey(Teacher) owner = models.CharField(max_length=300) class PetName(models.Model): relevantowner = models.ForeignKey(Owner) pet_name = models.CharField(max_length=50) </code></pre> <p><strong>forms.py</strong></p> <pre><code>class OwnerForm(forms.ModelForm): class Meta: model = Owner PetNameFormSet = inlineformset_factory(Owner, PetName, can_delete=False, extra=3, form=OwnerForm) </code></pre> <p><strong>views.py</strong></p> <pre><code>def petname(request, teacher_id): teacher = get_object_or_404(Teacher, pk=teacher_id) owners = Owner.objects.filter(relevantteacher=teacher_id) if request.method == "POST": petNameInlineFormSet = PetNameFormSet(request.POST, request.FILES, instance=owners) if petNameInlineFormSet.is_valid(): petNameInlineFormSet.save() return HttpResponseRedirect(reverse('success')) else: petNameInlineFormSet = PetNameFormSet(instance=owners) //error might be here? context = {'teacher': teacher, 'owners': owners, 'petNameInlineFormSet' : petNameInlineFormSet} return render(request, 'petname.html', context) </code></pre> <p><strong>Update:</strong></p> <p>Here is the traceback:</p> <pre><code>File "hde/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response 111. response = callback(request, *callback_args, **callback_kwargs) File "/views.py" in petname 60. petNameInlineFormSet = PetNameFormSet(instance=owners) File "lib/python2.7/site-packages/django/forms/models.py" in __init__ 697. queryset=qs, **kwargs) File "lib/python2.7/site-packages/django/forms/models.py" in __init__ 424. super(BaseModelFormSet, self).__init__(**defaults) </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USnlr25
    1. USnlr25
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COPlease specify the exact line number where the error happened.
      singulars
      1. PODjango DatabaseError "more than one row returned by a subquery used as an expression" Editable related fields to object
      1. USAamir Adnan
    2. COI added a traceback. Is that what you wanted?
      singulars
      1. PODjango DatabaseError "more than one row returned by a subquery used as an expression" Editable related fields to object
      1. USnlr25
    3. CO`PetNameFormSet(instance=owners)` I think problem is here as your are passing multiple owners but instance should be given as a single model object e.g. `instance=owner_obj`
      singulars
      1. PODjango DatabaseError "more than one row returned by a subquery used as an expression" Editable related fields to object
      1. USAamir Adnan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload