Re: django passing a parameter for a view in a url produces Error: Circuitinfotable matching query does not exist.

34 views
Skip to first unread message

Integr@te System

unread,
Nov 14, 2019, 4:17:55 PM11/14/19
to django...@googlegroups.com
Hi Informer,
check you model Circuitinfotable, 
Method call must include object instance as argument.


On Thu, Nov 14, 2019, 21:42 Patrick Carra <pcar...@gmail.com> wrote:
I am passing a parameter in a url to another view and during the process it gets changed.  An original parameter example that produces the error is OQYX/173774//ZYO but gets changed to '/viewLit/OQYX/173774/ZYO/' It drops the second / between 173774 and ZYO. I assumed this was because it was treating it as an escape character? So I tried adding an r in the urls.py file but it did not have any effect. Here is my template code for the page that generates the hyperlink:

<html>
<head>
<meta charset="UTF-8">
<title>Circuits</title>
<style>
h1 {
color:blue;
}
h4 {
color:red;
}
.tabledata {
  background: #395870; color:#fff;
}
.tablerow:nth-child(even) {
  background-color: #f2f2f2;
}
.form{
  width:100%;
}
.field {
  background: #white; float: left; margin: 1%; width: 200;
}
</style>
{% block content %}
  <h1 align="center">Search Lit Circuits</h1>
    <h6 align="center">Enter your search criteria below:</h6>
    <form method="get">
        <table class="form" style="width:100%">
          <tr>
            <th align="right">Circuit ID:</th><td><input type="text" name="circuitid" maxlength="100"></td>
            <th align="right">Bandwidth:</th><td><input type="text" name="bandwidth" maxlength="100"></td>
            <th align="right">Region:</th><td><input type="text" name="region" maxlength="100"></td>
          </tr>
          <tr>
            <th align="right">Carrier:</th><td><input type="text" name="carrier" maxlength="100"></td>
            <th align="right">Status:</th><td><input type="text" name="status" maxlength="100"></td>
            <th align="right">Segmentname:</th><td><input type="text" name="segmentname" maxlength="100"></td>
          </tr>
          <tr>
            <th align="right">MRC:</th><td><input type="text" name="mrcnew" maxlength="100"></td>
          </tr>
        </table>
        <button type="submit">Search</button>
        <a href="/searchlit/customsearch">
        <input type="button" value="Clear" /></a>
  </form>
<body>
<p>{{ filter.qs.count }} circuits returned</p>
<div>
  <table style="width:100%">
    <thead class="tabledata">
      <tr>
        <th>
          {% if user.is_authenticated %}
            Edit/
          {% endif %}
            View
        </th>
        <th>CircuitID</th>
        <th>Bandwidth</th>
        <th>Region</th>
        <th>Carrier</th>
<th>Status</th> <th>Segmentname</th> <th>MRC</th> </tr> </thead> <tbody> {% for circuit in filter.qs %} <tr class="tablerow"> <td class="actions"> {% if user.is_authenticated %} <a href="/editLit/{{ circuit.circuitid }}" target="_blank" class="edit-item" title="Edit">Edit</a> {% endif %} <a href="/viewLit/{{ circuit.circuitid }}" target="_blank" class="view-item" title="View">View</a> </td> <td>{{ circuit.circuitid }}</td> <td>{{ circuit.bandwidth }}</td> <td>{{ circuit.region }}</td> <td>{{ circuit.carrier }}</td> <td>{{ circuit.status }}</td> <td>{{ circuit.segmentname }}</td> <td>{{ circuit.mrcnew }}</td> </tr> {% endfor %} </tbody> </table> </div> </body> {% endblock %} </html>


My project level urls.py file:
"""ciopsdb URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:
Examples:
Function views
    1. Add an import:  from my_app import views
    2. Add a URL to urlpatterns:  path('', views.home, name='home')
Class-based views
    1. Add an import:  from other_app.views import Home
    2. Add a URL to urlpatterns:  path('', Home.as_view(), name='home')
Including another URLconf
    1. Import the include() function: from django.urls import include, path
    2. Add a URL to urlpatterns:  path('blog/', include('blog.urls'))
"""
from django.contrib import admin
from django.urls import path, include
from django.conf.urls import url

urlpatterns = [
    path('admin/', admin.site.urls),
    path('', include('homepage.urls')),
    path('searchlit/', include('searchLit.urls')),
    path('viewLit/', include('viewLit.urls')),
]


My viewLit app's urls.py

from django.urls import path, include
from django.conf.urls import  url
from . import views

urlpatterns= [
     path(r'<path:circuitid>/', views.viewLit, name='viewLit'),
]


My viewLit app's views.py

from django.shortcuts import render
from django.http import HttpResponse
from django.views.generic import TemplateView

from . models import Circuitinfotable, Budgettable, Xcinventorytable

# Create your views here.
def viewLit(request, circuitid):
    record = Circuitinfotable.objects.get(circuitid=circuitid)
    template = 'viewLit/viewCircuit.html'
    context = {'record':record}
    return render(request, template, context)


The traceback that I receive as an error:

Traceback:

File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/core/handlers/exception.py" in inner
  34.             response = get_response(request)

File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/core/handlers/base.py" in _get_response
  115.                 response = self.process_exception_by_middleware(e, request)

File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/core/handlers/base.py" in _get_response
  113.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/home/db_user/ciopsdb/viewLit/views.py" in viewLit
  9.     record = Circuitinfotable.objects.get(circuitid=circuitid)

File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/db/models/manager.py" in manager_method
  82.                 return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/db/models/query.py" in get
  408.                 self.model._meta.object_name

Exception Type: DoesNotExist at /viewLit/OQYX/173774/ZYO/
Exception Value: Circuitinfotable matching query does not exist.

Any suggestions are appreciated.  

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/49da6357-27be-42fa-8b88-fc9c223654d8%40googlegroups.com.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 5:04:54 PM11/14/19
to django...@googlegroups.com
check on your a link you are including vieset/ and there is not on your url

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP5HUWqOnTrZvzArw77fnyDRHP4BA9QmoUEdR4a9boMFVxggRg%40mail.gmail.com.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 5:06:09 PM11/14/19
to django...@googlegroups.com
a href="/viewLit/{{ circuit.circuitid }}" t

and in your urls.py 

 path(r'<path:circuitid>/', views.viewLit, name='viewLit'),
Message has been deleted

Patrick Carra

unread,
Nov 14, 2019, 6:02:17 PM11/14/19
to Django users
Could you provide an example of what you mean?  I'm not sure what you mean by method call must include an object instance as argument.  This code works for other values of circuitid but does not work for one that contains a //.  This tells me, along with the traceback code, that django at some point drops one of the /'s and the result is it cannot find a matching circuitid in the Circuitinfotable during the query.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:27:03 PM11/14/19
to django...@googlegroups.com
then use the templatetag |safe

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:29:00 PM11/14/19
to django...@googlegroups.com
ok i didn't see your app name is viewList sorry uset templatetag to scape weird character because you are using url encoding

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:34:11 PM11/14/19
to django...@googlegroups.com
mmm sorry you are pasing the id you dont have any weird character let me see 

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:35:00 PM11/14/19
to django...@googlegroups.com
is this your id  OQYX/173774/ZYO/ i mean the if from your model?

Patrick Carra

unread,
Nov 14, 2019, 7:41:35 PM11/14/19
to Django users
That is a value from the table in models called Circuitinfotable and the field it is pulled from is called circuitid.

Patrick Carra

unread,
Nov 14, 2019, 7:43:44 PM11/14/19
to Django users
and the actual value is OQYX/173774//ZYO but Django is interpreting it as OQYX/173774/ZYO/

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:46:50 PM11/14/19
to django...@googlegroups.com
then use |safe template tag from django

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/55203f72-f8fb-48d9-8ace-09aa652e1721%40googlegroups.com.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:47:02 PM11/14/19
to django...@googlegroups.com
<a href=example/{{ value|safe }} ...

Patrick Carra

unread,
Nov 14, 2019, 7:52:36 PM11/14/19
to Django users
There was no change after adding |safe after the value within {{}}
example: <a href="/viewLit/{{ circuit.circuitid|safe }}" target="_blank" class="view-item" title="View">View</a>

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:55:48 PM11/14/19
to django...@googlegroups.com
{% autoescape on %}
    {{ post.content }}
{% endautoescape %}



try this

El jue., 14 nov. 2019 a las 20:53, Patrick Carra (<pcar...@gmail.com>) escribió:
There was no change after adding |safe after the value within {{}}
example: <a href="/viewLit/{{ circuit.circuitid|safe }}" target="_blank" class="view-item" title="View">View</a>

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e023361a-1544-4095-ab6d-53461996947b%40googlegroups.com.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:56:48 PM11/14/19
to django...@googlegroups.com
or |escape  is the same

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 7:57:32 PM11/14/19
to django...@googlegroups.com
or try to send another unique value it will be easy

Patrick Carra

unread,
Nov 14, 2019, 8:08:21 PM11/14/19
to Django users
No change Daniel I looked that up and I think that is used for something else.  The name makes since but its purpose is for something else.

Patrick Carra

unread,
Nov 14, 2019, 8:14:29 PM11/14/19
to Django users
I think my assumption was wrong stackoverflow is down right now so I can't go to the link but it seems like somebody is suggesting this is an apache/mod_wsgi error

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 8:19:24 PM11/14/19
to django...@googlegroups.com
the main problem is tha you have especial character in a url and the codification on an url does this to transport the data and your have to fix it in the request then 
at least tray  using  urllib.parse from python check some where an example

El jue., 14 nov. 2019 a las 21:15, Patrick Carra (<pcar...@gmail.com>) escribió:
I think my assumption was wrong stackoverflow is down right now so I can't go to the link but it seems like somebody is suggesting this is an apache/mod_wsgi error

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/120e943c-55f6-4971-b80e-64713b095b7b%40googlegroups.com.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 8:29:49 PM11/14/19
to django...@googlegroups.com
https://docs.djangoproject.com/en/2.2/_modules/django/utils/html/
here you have some tricks to do on your view maybe

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 8:29:57 PM11/14/19
to django...@googlegroups.com
https://www.webforefront.com/django/regexpdjangourls.html?
is maybe something related to your url pattern i don't know but something is wrong because is not working  or did you found a solutions?

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 8:56:01 PM11/14/19
to django...@googlegroups.com
>>> r.encoding
'utf-8'
>>> r.encoding = 'ISO-8859-1'

r is your request use different encoding

Patrick Carra

unread,
Nov 14, 2019, 8:56:14 PM11/14/19
to Django users
Yea I think what I may have to do is write some regex in the template to catch anytime there is a // and convert it to something that won't interfere with the apache/mod_wsgi due to the url and then when I pass it back into my view convert it back to the original in order to perform the query and get the correct response.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 8:59:57 PM11/14/19
to django...@googlegroups.com
Yes at the moment because is all related to the slash character 

On Thu, 14 Nov 2019, 21:57 Patrick Carra, <pcar...@gmail.com> wrote:
Yea I think what I may have to do is write some regex in the template to catch anytime there is a // and convert it to something that won't interfere with the apache/mod_wsgi due to the url and then when I pass it back into my view convert it back to the original in order to perform the query and get the correct response.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/fa54b31d-c8b6-4900-93d7-e03d8f7ab6c6%40googlegroups.com.

DANIEL URBANO DE LA RUA

unread,
Nov 14, 2019, 9:01:15 PM11/14/19
to django...@googlegroups.com
Or send it as a post and finish your problem 

Patrick Carra

unread,
Nov 15, 2019, 5:01:00 PM11/15/19
to Django users
In case anyone is interested I fixed this with some simple regex in my view.  I identified the patterns for which apache was removing the // and replacing with a single / and then wrote some rules around that and replaced the single / with the // before passing it to my query.

DANIEL URBANO DE LA RUA

unread,
Nov 15, 2019, 5:14:46 PM11/15/19
to django...@googlegroups.com
Nice but i am always with nginx and i dont know if it has the same problem or not

On Fri, 15 Nov 2019, 18:02 Patrick Carra, <pcar...@gmail.com> wrote:
In case anyone is interested I fixed this with some simple regex in my view.  I identified the patterns for which apache was removing the // and replacing with a single / and then wrote some rules around that and replaced the single / with the // before passing it to my query.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2752a54f-4bdc-4781-b8ba-a842ffcb1a36%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages