Exception when clicking on outgoing reviews link

*NOTE: Do not post confidential information in this bug report.*

What's the URL of the page containing the problem?
http://reviewboard.eng.vmware.com/dashboard/?view=outgoing

What steps will reproduce the problem?
1. Click on outgoing reviews link  
2. Result is:
MultipleObjectsReturned at /dashboard/
get() returned more than one ReviewRequestDraft -- it returned 2! Lookup 
parameters were {}
Request Method: GET 
Request URL: http://reviewboard.eng.vmware.com/dashboard/ 
Exception Type: MultipleObjectsReturned 
Exception Value: get() returned more than one ReviewRequestDraft -- it 
returned 2! Lookup parameters were {} 
Exception Location: /usr/lib/python2.5/site-
packages/django/db/models/query.py in get, line 265 
Python Executable: /usr/bin/python 
Python Version: 2.5.1 

Template error
In template /root/reviewboard/templates/reviews/dashboard.html, error at 
line 67

Caught an exception while rendering: get() returned more than one 
ReviewRequestDraft -- it returned 2! Lookup parameters were {}
57      <tr class="headers">

58       <th><img src="/images/convo.png" width="18" height="16" alt="{% 
trans "New Replies" %}" /></th>

59       <th><img src="/images/star_on.png" width="16" height="15" alt="{% 
trans "Starred" %}" /></th>

60       {% column_header "summary"      "Summary"      %}

61       {% column_header "submitter"    "Submitter"    %}

62       {% column_header "time_added"   "Posted"       %}

63       {% column_header "last_updated" "Last Updated" %}

64      </tr>

65     </thead>

66     <tbody>

67 {% for review_request in review_request_list %}

68      <tr class="{% cycle odd,even %}">

69       <td>{% ifnewreviews review_request %}<img src="/images/convo.png" 
width="18" height="16" alt="" />{% endifnewreviews %}</td>

70       <td>{% star review_request %}</td>

71       <td class="summary" 
onclick="javascript:window.location='{{review_request.get_absolute_url}}'; 
return false;"><a href="{{review_request.get_absolute_url}}">{% 
reviewsummary review_request %}</a></td>

72       <td><a href="{{review_request.submitter.get_absolute_url}}">
{{review_request.submitter}}</a></td>

73       <td class="{% ageid review_request.time_added %}">
{{review_request.time_added|date:"F jS, Y, P"}}</td>

74       <td class="{% ageid review_request.last_updated %}">
{{review_request.last_updated|timesince}} ago</td>

75      </tr>

76 {% endfor %}

77     </tbody>

Traceback Switch to copy-and-paste view
/usr/lib/python2.5/site-packages/django/template/__init__.py in 
render_node 
    def render_node(self, node, context):        return node.render
(context)class DebugNodeList(NodeList):    def render_node(self, node, 
context):        try:            result = node.render(context) ...        
except TemplateSyntaxError, e:            if not hasattr
(e, 'source'):                e.source = node.source            
raise        except Exception, e:            from sys import exc_info▶ 
Local vars 
Variable Value 
context [{'forloop': {'parentloop': {}, 'last': True, 'counter': 
2, 'revcounter0': 0, 'revcounter': 1, 'counter0': 1, 'first': False}, 
u'review_request': <ReviewRequest: Fix Host General Section to update cpu 
and memmory bars according overallCpuUsage and overallMemoryUsage 
properties updates.>}, {'block': <Block Node: content. Contents: [<Text 
Node: ' '>, <djblets.util.decorators.BlockTagNode object at 0xe28db8c>, 
<Text Node: ' '>]>}, {'app_path': u'/dashboard/', 'group': '', 'title': 
u'All Outgoing Review Requests', 'request': <WSGIRequest GET:<QueryDict: 
{u'view': [u'outgoing']}>, POST:<QueryDict: {}>, COOKIES:
{'CFID': '5584275', 'CFTOKEN': 'b6e65b2cb2a65f7e-BABBFD6B-5056-AD18-
888974F1A5A18117', 'CP': 'null*', 'bn_u': '27877276', 'collapsediffs': 'Tru
e', 'sessionid': '6598c671b295e3dd8f235f602d0048d6', 'uid': '10.19.248.5.15
161190023723742'}, META:
{'DOCUMENT_ROOT': '/root/reviewboard/htdocs/', 'GATEWAY_INTERFACE': 'CGI/1.
1', 'HTTP_ACCEPT': '*/*', 'HTTP_ACCEPT_ENCODING': 'gzip, 
deflate', 'HTTP_ACCEPT_LANGUAGE': 'bg-bg', 'HTTP_CACHE_CONTROL': 'max-
age=259200', 'HTTP_CONNECTION': 'keep-
alive', 'HTTP_COOKIE': 'CFID=5584275; CFTOKEN=b6e65b2cb2a65f7e-BABBFD6B-
5056-AD18-888974F1A5A18117; uid=10.19.248.5.15161190023723742; 
bn_u=27877276; CP=null*; sessionid=6598c671b295e3dd8f235f602d0048d6; 
collapsediffs=True', 'HTTP_HOST': 'reviewboard.eng.vmware.com', 'HTTP_REFER
ER': 'http://reviewboard.eng.vmware.com/dashboard/', 'HTTP_UA_CPU': 'x86', 
'HTTP_USER_AGENT': 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 
5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 
3.0.04506.30)', 'HTTP_VIA': '1.1 proxy.vmware.com:3128 
(squid/2.5.STABLE14)', 'HTTP_X_FORWARDED_FOR': '10.20.108.78, 
unknown', 'PATH': '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:
/bin:/usr/bin/X11:/usr/games', 'PATH_INFO': '/dashboard/', 'PATH_TRANSLATED
': '/root/reviewboard/htdocs/reviewboard.fcgi/dashboard/', 'QUERY_STRING': 
'view=outgoing', 'REMOTE_ADDR': '10.16.65.251', 'REMOTE_PORT': '42674', 'RE
QUEST_METHOD': 'GET', 'REQUEST_URI': '/dashboard/?
view=outgoing', 'SCRIPT_FILENAME': '/root/reviewboard/htdocs/reviewboard.fc
gi', 'SCRIPT_NAME': '', 'SCRIPT_URI': 'http://reviewboard.eng.vmware.com/da
shboard/', 'SCRIPT_URL': '/dashboard/', 'SERVER_ADDR': '10.18.66.1', 'SERVE
R_ADMIN': '[no address 
given]', 'SERVER_NAME': 'reviewboard.eng.vmware.com', 'SERVER_PORT': '80', 
'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SIGNATURE': '<address>Apache/2.2.3 
(Ubuntu) mod_fastcgi/2.4.2 mod_python/3.2.10 Python/2.5.1c1 Server at 
reviewboard.eng.vmware.com Port 
80</address>\n', 'SERVER_SOFTWARE': 'Apache/2.2.3 (Ubuntu) 
mod_fastcgi/2.4.2 mod_python/3.2.10 Python/2.5.1c1', 'wsgi.errors': 
<flup.server.fcgi_base.TeeOutputStream object at 0x9cc294c>, 'wsgi.input': 
<flup.server.fcgi_base.InputStream object at 
0x9cc2dec>, 'wsgi.multiprocess': True, 'wsgi.multithread': 
False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': 
(1, 0)}>, 'sort_list': [u'-last_updated'], 'show_submitted': 0, 'view': 
u'outgoing'}, {'MEDIA_URL': '/'}, {'LANGUAGES': (('ar', 'Arabic'), 
('bn', 'Bengali'), ('bg', 'Bulgarian'), ('ca', 'Catalan'), 
('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), 
('el', 'Greek'), ('en', 'English'), ('es', 'Spanish'), 
('es_AR', 'Argentinean Spanish'), ('fa', 'Persian'), ('fi', 'Finnish'), 
('fr', 'French'), ('ga', 'Gaeilge'), ('gl', 'Galician'), 
('hu', 'Hungarian'), ('he', 'Hebrew'), ('hr', 'Croatian'), 
('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), 
('ko', 'Korean'), ('km', 'Khmer'), ('kn', 'Kannada'), ('lv', 'Latvian'), 
('mk', 'Macedonian'), ('nl', 'Dutch'), ('no', 'Norwegian'), 
('pl', 'Polish'), ('pt', 'Portugese'), ('pt-br', 'Brazilian'), 
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), 
('sl', 'Slovenian'), ('sr', 'Serbian'), ('sv', 'Swedish'), 
('ta', 'Tamil'), ('te', 'Telugu'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), 
('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional 
Chinese')), 'LANGUAGE_BIDI': False, 'LANGUAGE_CODE': 'bg'}, {}, {'perms': 
<django.core.context_processors.PermWrapper object at 
0x92838ec>, 'messages': [], 'user': <User: idragoev>}, {'has_next': 
False, 'review_request_list': [<ReviewRequest: Wizard refactoring>, 
<ReviewRequest: Fix Host General Section to update cpu and memmory bars 
according overallCpuUsage and overallMemoryUsage properties 
updates.>], 'pages': 1, 'hits': 2, 'next': 2, 'page_range': 
[1], 'results_per_page': 50, 'first_on_page': 1, 'has_previous': 
False, 'is_paginated': False, 'page': 1, 'last_on_page': 2, 'previous': 
0}] 
e MultipleObjectsReturned('get() returned more than one 
ReviewRequestDraft -- it returned 2! Lookup parameters were {}',) 
exc_info <built-in function exc_info> 
node <For Node: for review_request in review_request_list, tail_len: 25> 
self [<Text Node: ' <colgroup> <col'>, 
<django.templatetags.i18n.TranslateNode object at 0xe28d64c>, <Text 
Node: '" /></th> <th><img '>, <django.templatetags.i18n.TranslateNode 
object at 0xe28d44c>, <Text Node: '" /></th> '>, 
<django.template.InclusionNode object at 0x992c90c>, <Text Node: ' '>, 
<django.template.InclusionNode object at 0x992cb4c>, <Text Node: ' '>, 
<django.template.InclusionNode object at 0x992cdac>, <Text Node: ' '>, 
<django.template.InclusionNode object at 0x992c40c>, <Text Node: ' </tr> 
</thead> '>, <For Node: for review_request in review_request_list, 
tail_len: 25>, <Text Node: ' </tbody> '>] 
wrapped TemplateSyntaxError('Caught an exception while rendering: get() 
returned more than one ReviewRequestDraft -- it returned 2! Lookup 
parameters were {}',) 

/usr/lib/python2.5/site-packages/django/template/defaulttags.py in render 
            if unpack:                # If there are multiple loop 
variables, unpack the item into                # them.                
context.update(dict(zip(self.loopvars, item)))            
else:                context[self.loopvars[0]] = item            for node 
in self.nodelist_loop:                nodelist.append(node.render
(context)) ...            if unpack:                # The loop variables 
were pushed on to the context so pop them                # off again. This 
is necessary because the tag lets the length                # of loopvars 
differ to the length of each set of items and we                # don't 
want to leave any vars from the previous loop on the                # 
context.▶ Local vars 
Variable Value 
context [{'forloop': {'parentloop': {}, 'last': True, 'counter': 
2, 'revcounter0': 0, 'revcounter': 1, 'counter0': 1, 'first': False}, 
u'review_request': <ReviewRequest: Fix Host General Section to update cpu 
and memmory bars according overallCpuUsage and overallMemoryUsage 
properties updates.>}, {'block': <Block Node: content. Contents: [<Text 
Node: ' '>, <djblets.util.decorators.BlockTagNode object at 0xe28db8c>, 
<Text Node: ' '>]>}, {'app_path': u'/dashboard/', 'group': '', 'title': 
u'All Outgoing Review Requests', 'request': <WSGIRequest GET:<QueryDict: 
{u'view': [u'outgoing']}>, POST:<QueryDict: {}>, COOKIES:
{'CFID': '5584275', 'CFTOKEN': 'b6e65b2cb2a65f7e-BABBFD6B-5056-AD18-
888974F1A5A18117', 'CP': 'null*', 'bn_u': '27877276', 'collapsediffs': 'Tru
e', 'sessionid': '6598c671b295e3dd8f235f602d0048d6', 'uid': '10.19.248.5.15
161190023723742'}, META:
{'DOCUMENT_ROOT': '/root/reviewboard/htdocs/', 'GATEWAY_INTERFACE': 'CGI/1.
1', 'HTTP_ACCEPT': '*/*', 'HTTP_ACCEPT_ENCODING': 'gzip, 
deflate', 'HTTP_ACCEPT_LANGUAGE': 'bg-bg', 'HTTP_CACHE_CONTROL': 'max-
age=259200', 'HTTP_CONNECTION': 'keep-
alive', 'HTTP_COOKIE': 'CFID=5584275; CFTOKEN=b6e65b2cb2a65f7e-BABBFD6B-
5056-AD18-888974F1A5A18117; uid=10.19.248.5.15161190023723742; 
bn_u=27877276; CP=null*; sessionid=6598c671b295e3dd8f235f602d0048d6; 
collapsediffs=True', 'HTTP_HOST': 'reviewboard.eng.vmware.com', 'HTTP_REFER
ER': 'http://reviewboard.eng.vmware.com/dashboard/', 'HTTP_UA_CPU': 'x86', 
'HTTP_USER_AGENT': 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 
5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 
3.0.04506.30)', 'HTTP_VIA': '1.1 proxy.vmware.com:3128 
(squid/2.5.STABLE14)', 'HTTP_X_FORWARDED_FOR': '10.20.108.78, 
unknown', 'PATH': '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:
/bin:/usr/bin/X11:/usr/games', 'PATH_INFO': '/dashboard/', 'PATH_TRANSLATED
': '/root/reviewboard/htdocs/reviewboard.fcgi/dashboard/', 'QUERY_STRING': 
'view=outgoing', 'REMOTE_ADDR': '10.16.65.251', 'REMOTE_PORT': '42674', 'RE
QUEST_METHOD': 'GET', 'REQUEST_URI': '/dashboard/?
view=outgoing', 'SCRIPT_FILENAME': '/root/reviewboard/htdocs/reviewboard.fc
gi', 'SCRIPT_NAME': '', 'SCRIPT_URI': 'http://reviewboard.eng.vmware.com/da
shboard/', 'SCRIPT_URL': '/dashboard/', 'SERVER_ADDR': '10.18.66.1', 'SERVE
R_ADMIN': '[no address 
given]', 'SERVER_NAME': 'reviewboard.eng.vmware.com', 'SERVER_PORT': '80', 
'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SIGNATURE': '<address>Apache/2.2.3 
(Ubuntu) mod_fastcgi/2.4.2 mod_python/3.2.10 Python/2.5.1c1 Server at 
reviewboard.eng.vmware.com Port 
80</address>\n', 'SERVER_SOFTWARE': 'Apache/2.2.3 (Ubuntu) 
mod_fastcgi/2.4.2 mod_python/3.2.10 Python/2.5.1c1', 'wsgi.errors': 
<flup.server.fcgi_base.TeeOutputStream object at 0x9cc294c>, 'wsgi.input': 
<flup.server.fcgi_base.InputStream object at 
0x9cc2dec>, 'wsgi.multiprocess': True, 'wsgi.multithread': 
False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': 
(1, 0)}>, 'sort_list': [u'-last_updated'], 'show_submitted': 0, 'view': 
u'outgoing'}, {'MEDIA_URL': '/'}, {'LANGUAGES': (('ar', 'Arabic'), 
('bn', 'Bengali'), ('bg', 'Bulgarian'), ('ca', 'Catalan'), 
('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), 
('el', 'Greek'), ('en', 'English'), ('es', 'Spanish'), 
('es_AR', 'Argentinean Spanish'), ('fa', 'Persian'), ('fi', 'Finnish'), 
('fr', 'French'), ('ga', 'Gaeilge'), ('gl', 'Galician'), 
('hu', 'Hungarian'), ('he', 'Hebrew'), ('hr', 'Croatian'), 
('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), 
('ko', 'Korean'), ('km', 'Khmer'), ('kn', 'Kannada'), ('lv', 'Latvian'), 
('mk', 'Macedonian'), ('nl', 'Dutch'), ('no', 'Norwegian'), 
('pl', 'Polish'), ('pt', 'Portugese'), ('pt-br', 'Brazilian'), 
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), 
('sl', 'Slovenian'), ('sr', 'Serbian'), ('sv', 'Swedish'), 
('ta', 'Tamil'), ('te', 'Telugu'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), 
('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional 
Chinese')), 'LANGUAGE_BIDI': False, 'LANGUAGE_CODE': 'bg'}, {}, {'perms': 
<django.core.context_processors.PermWrapper object at 
0x92838ec>, 'messages': [], 'user': <User: idragoev>}, {'has_next': 
False, 'review_request_list': [<ReviewRequest: Wizard refactoring>, 
<ReviewRequest: Fix Host General Section to update cpu and memmory bars 
according overallCpuUsage and overallMemoryUsage properties 
updates.>], 'pages': 1, 'hits': 2, 'next': 2, 'page_range': 
[1], 'results_per_page': 50, 'first_on_page': 1, 'has_previous': 
False, 'is_paginated': False, 'page': 1, 'last_on_page': 2, 'previous': 
0}] 
i 1 
item <ReviewRequest: Fix Host General Section to update cpu and memmory 
bars according overallCpuUsage and overallMemoryUsage properties updates.> 
len_values 2 
node <django.templatetags.reviewtags.ReviewSummary object at 0x93e16ac> 
nodelist [u'\n <tr class="', u'odd', u'">\n <td>', '', u'</td>\n <td>', 
u'\n<img class="star" src="/images/star_off.png" width="16" height="15" 
border="0" alt="" onclick="toggleStar(this, \'reviewrequests\', \'7572\', 
0);" />\n\n', u'</td>\n <td class="summary" 
onclick="javascript:window.location=\'', u'/r/7572/', u'\'; return 
false;"><a href="', u'/r/7572/', u'">', u'Wizard refactoring', 
u'</a></td>\n <td><a href="', u'/users/idragoev/', u'">', u'idragoev', 
u'</a></td>\n <td class="', 'age1', u'">', u'\u0414\u0435\u043a\u0435
\u043c\u0432\u0440\u0438 13th, 2007, 9:52 a.m.', u'</td>\n <td 
class="', 'age1', u'">', u'4 \u043c\u0438\u043d\u0443\u0442\u0438', u' 
ago</td>\n </tr>\n', u'\n <tr class="', u'even', u'">\n <td>', '', 
u'</td>\n <td>', u'\n<img class="star" src="/images/star_off.png" 
width="16" height="15" border="0" alt="" onclick="toggleStar(this, 
\'reviewrequests\', \'7315\', 0);" />\n\n', u'</td>\n <td class="summary" 
onclick="javascript:window.location=\'', u'/r/7315/', u'\'; return 
false;"><a href="', u'/r/7315/', u'">'] 
parentloop {} 
self <For Node: for review_request in review_request_list, tail_len: 25> 
unpack False 
values [<ReviewRequest: Wizard refactoring>, <ReviewRequest: Fix Host 
General Section to update cpu and memmory bars according overallCpuUsage 
and overallMemoryUsage properties updates.>] 

/root/reviewboard/reviews/templatetags/reviewtags.py in render 
                "Invalid variable %s passed to reviewsummary tag." % 
\                self.review_request        summary = conditional_escape
(review_request.summary)        if review_request.submitter == context.get
('user', None):            try:                draft = 
review_request.reviewrequestdraft_set.get() ...                
return "<span class=\"draftlabel\">[Draft]</span> " + 
\                       summary            except 
ReviewRequestDraft.DoesNotExist:                pass            if not 
review_request.public:▶ Local vars 
Variable Value 
context [{'forloop': {'parentloop': {}, 'last': True, 'counter': 
2, 'revcounter0': 0, 'revcounter': 1, 'counter0': 1, 'first': False}, 
u'review_request': <ReviewRequest: Fix Host General Section to update cpu 
and memmory bars according overallCpuUsage and overallMemoryUsage 
properties updates.>}, {'block': <Block Node: content. Contents: [<Text 
Node: ' '>, <djblets.util.decorators.BlockTagNode object at 0xe28db8c>, 
<Text Node: ' '>]>}, {'app_path': u'/dashboard/', 'group': '', 'title': 
u'All Outgoing Review Requests', 'request': <WSGIRequest GET:<QueryDict: 
{u'view': [u'outgoing']}>, POST:<QueryDict: {}>, COOKIES:
{'CFID': '5584275', 'CFTOKEN': 'b6e65b2cb2a65f7e-BABBFD6B-5056-AD18-
888974F1A5A18117', 'CP': 'null*', 'bn_u': '27877276', 'collapsediffs': 'Tru
e', 'sessionid': '6598c671b295e3dd8f235f602d0048d6', 'uid': '10.19.248.5.15
161190023723742'}, META:
{'DOCUMENT_ROOT': '/root/reviewboard/htdocs/', 'GATEWAY_INTERFACE': 'CGI/1.
1', 'HTTP_ACCEPT': '*/*', 'HTTP_ACCEPT_ENCODING': 'gzip, 
deflate', 'HTTP_ACCEPT_LANGUAGE': 'bg-bg', 'HTTP_CACHE_CONTROL': 'max-
age=259200', 'HTTP_CONNECTION': 'keep-
alive', 'HTTP_COOKIE': 'CFID=5584275; CFTOKEN=b6e65b2cb2a65f7e-BABBFD6B-
5056-AD18-888974F1A5A18117; uid=10.19.248.5.15161190023723742; 
bn_u=27877276; CP=null*; sessionid=6598c671b295e3dd8f235f602d0048d6; 
collapsediffs=True', 'HTTP_HOST': 'reviewboard.eng.vmware.com', 'HTTP_REFER
ER': 'http://reviewboard.eng.vmware.com/dashboard/', 'HTTP_UA_CPU': 'x86', 
'HTTP_USER_AGENT': 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 
5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 
3.0.04506.30)', 'HTTP_VIA': '1.1 proxy.vmware.com:3128 
(squid/2.5.STABLE14)', 'HTTP_X_FORWARDED_FOR': '10.20.108.78, 
unknown', 'PATH': '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:
/bin:/usr/bin/X11:/usr/games', 'PATH_INFO': '/dashboard/', 'PATH_TRANSLATED
': '/root/reviewboard/htdocs/reviewboard.fcgi/dashboard/', 'QUERY_STRING': 
'view=outgoing', 'REMOTE_ADDR': '10.16.65.251', 'REMOTE_PORT': '42674', 'RE
QUEST_METHOD': 'GET', 'REQUEST_URI': '/dashboard/?
view=outgoing', 'SCRIPT_FILENAME': '/root/reviewboard/htdocs/reviewboard.fc
gi', 'SCRIPT_NAME': '', 'SCRIPT_URI': 'http://reviewboard.eng.vmware.com/da
shboard/', 'SCRIPT_URL': '/dashboard/', 'SERVER_ADDR': '10.18.66.1', 'SERVE
R_ADMIN': '[no address 
given]', 'SERVER_NAME': 'reviewboard.eng.vmware.com', 'SERVER_PORT': '80', 
'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SIGNATURE': '<address>Apache/2.2.3 
(Ubuntu) mod_fastcgi/2.4.2 mod_python/3.2.10 Python/2.5.1c1 Server at 
reviewboard.eng.vmware.com Port 
80</address>\n', 'SERVER_SOFTWARE': 'Apache/2.2.3 (Ubuntu) 
mod_fastcgi/2.4.2 mod_python/3.2.10 Python/2.5.1c1', 'wsgi.errors': 
<flup.server.fcgi_base.TeeOutputStream object at 0x9cc294c>, 'wsgi.input': 
<flup.server.fcgi_base.InputStream object at 
0x9cc2dec>, 'wsgi.multiprocess': True, 'wsgi.multithread': 
False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': 
(1, 0)}>, 'sort_list': [u'-last_updated'], 'show_submitted': 0, 'view': 
u'outgoing'}, {'MEDIA_URL': '/'}, {'LANGUAGES': (('ar', 'Arabic'), 
('bn', 'Bengali'), ('bg', 'Bulgarian'), ('ca', 'Catalan'), 
('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), 
('el', 'Greek'), ('en', 'English'), ('es', 'Spanish'), 
('es_AR', 'Argentinean Spanish'), ('fa', 'Persian'), ('fi', 'Finnish'), 
('fr', 'French'), ('ga', 'Gaeilge'), ('gl', 'Galician'), 
('hu', 'Hungarian'), ('he', 'Hebrew'), ('hr', 'Croatian'), 
('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), 
('ko', 'Korean'), ('km', 'Khmer'), ('kn', 'Kannada'), ('lv', 'Latvian'), 
('mk', 'Macedonian'), ('nl', 'Dutch'), ('no', 'Norwegian'), 
('pl', 'Polish'), ('pt', 'Portugese'), ('pt-br', 'Brazilian'), 
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), 
('sl', 'Slovenian'), ('sr', 'Serbian'), ('sv', 'Swedish'), 
('ta', 'Tamil'), ('te', 'Telugu'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), 
('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional 
Chinese')), 'LANGUAGE_BIDI': False, 'LANGUAGE_CODE': 'bg'}, {}, {'perms': 
<django.core.context_processors.PermWrapper object at 
0x92838ec>, 'messages': [], 'user': <User: idragoev>}, {'has_next': 
False, 'review_request_list': [<ReviewRequest: Wizard refactoring>, 
<ReviewRequest: Fix Host General Section to update cpu and memmory bars 
according overallCpuUsage and overallMemoryUsage properties 
updates.>], 'pages': 1, 'hits': 2, 'next': 2, 'page_range': 
[1], 'results_per_page': 50, 'first_on_page': 1, 'has_previous': 
False, 'is_paginated': False, 'page': 1, 'last_on_page': 2, 'previous': 
0}] 
review_request <ReviewRequest: Fix Host General Section to update cpu and 
memmory bars according overallCpuUsage and overallMemoryUsage properties 
updates.> 
self <django.templatetags.reviewtags.ReviewSummary object at 0x93e16ac> 
summary u'Fix Host General Section to update cpu and memmory bars 
according overallCpuUsage and overallMemoryUsage properties updates.' 

/usr/lib/python2.5/site-packages/django/db/models/manager.py in get 
    def distinct(self, *args, **kwargs):        return self.get_query_set
().distinct(*args, **kwargs)    def extra(self, *args, **kwargs):        
return self.get_query_set().extra(*args, **kwargs)    def get(self, *args, 
**kwargs):        return self.get_query_set().get(*args, **kwargs) ...    
def get_or_create(self, **kwargs):        return self.get_query_set
().get_or_create(**kwargs)            def create(self, **kwargs):        
return self.get_query_set().create(**kwargs)▶ Local vars 
Variable Value 
args () 
kwargs {} 
self <django.db.models.fields.related.RelatedManager object at 0x9ef95ec> 

/usr/lib/python2.5/site-packages/django/db/models/query.py in get 
        # clean up SQL by removing unneeded ORDER BY        if not 
clone._order_by:            clone._order_by = ()        obj_list = list
(clone)        if len(obj_list) < 1:            raise 
self.model.DoesNotExist, "%s matching query does not exist." % 
self.model._meta.object_name        elif len(obj_list) > 1:            
raise self.model.MultipleObjectsReturned, "get() returned more than one %
s -- it returned %s! Lookup parameters were %s" % 
(self.model._meta.object_name, len(obj_list), kwargs) ...        return 
obj_list[0]    def create(self, **kwargs):        """        Create a new 
object with the given kwargs, saving it to the database        and 
returning the created object.▶ Local vars 
------------------------------------------------------------

3. Addtional stack trace:
Environment:

Request Method: GET
Request URL: http://reviewboard.eng.vmware.com/dashboard/
Django Version: 0.97-pre-SVN-unknown
Python Version: 2.5.1
Installed Applications: 
   ['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sites',
 'django.contrib.sessions',
 'djblets.util',
 'reviewboard.accounts',
 'reviewboard.datagrid',
 'reviewboard.diffviewer',
 'reviewboard.iphone',
 'reviewboard.reports',
 'reviewboard.reviews',
 'reviewboard.scmtools',
 'reviewboard.utils']
Installed Middleware: 
   ('django.middleware.common.CommonMiddleware',
 'django.middleware.doc.XViewMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware')

Template error:
In template /root/reviewboard/templates/reviews/dashboard.html, error at 
line 67
   Caught an exception while rendering: get() returned more than one 
ReviewRequestDraft -- it returned 2! Lookup parameters were {}
   57 :      <tr class="headers">

   58 :       <th><img src="/images/convo.png" width="18" height="16" 
alt="{% trans "New Replies" %}" /></th>

   59 :       <th><img src="/images/star_on.png" width="16" height="15" 
alt="{% trans "Starred" %}" /></th>

   60 :       {% column_header "summary"      "Summary"      %}

   61 :       {% column_header "submitter"    "Submitter"    %}

   62 :       {% column_header "time_added"   "Posted"       %}

   63 :       {% column_header "last_updated" "Last Updated" %}

   64 :      </tr>

   65 :     </thead>

   66 :     <tbody>

   67 :  {% for review_request in review_request_list %} 

   68 :      <tr class="{% cycle odd,even %}">

   69 :       <td>{% ifnewreviews review_request %}<img 
src="/images/convo.png" width="18" height="16" alt="" />{% endifnewreviews 
%}</td>

   70 :       <td>{% star review_request %}</td>

   71 :       <td class="summary" 
onclick="javascript:window.location='{{review_request.get_absolute_url}}'; 
return false;"><a href="{{review_request.get_absolute_url}}">{% 
reviewsummary review_request %}</a></td>

   72 :       <td><a href="{{review_request.submitter.get_absolute_url}}">
{{review_request.submitter}}</a></td>

   73 :       <td class="{% ageid review_request.time_added %}">
{{review_request.time_added|date:"F jS, Y, P"}}</td>

   74 :       <td class="{% ageid review_request.last_updated %}">
{{review_request.last_updated|timesince}} ago</td>

   75 :      </tr>

   76 : {% endfor %}

   77 :     </tbody>

Traceback:
File "/usr/lib/python2.5/site-packages/django/template/__init__.py" in 
render_node
  822.             result = node.render(context)
File "/usr/lib/python2.5/site-packages/django/template/defaulttags.py" in 
render
  151.                 nodelist.append(node.render(context))
File "/root/reviewboard/reviews/templatetags/reviewtags.py" in render
  38.                 draft = review_request.reviewrequestdraft_set.get()
File "/usr/lib/python2.5/site-packages/django/db/models/manager.py" in get
  69.         return self.get_query_set().get(*args, **kwargs)
File "/usr/lib/python2.5/site-packages/django/db/models/query.py" in get
  265.             raise self.model.MultipleObjectsReturned, "get() 
returned more than one %s -- it returned %s! Lookup parameters were %s" % 
(self.model._meta.object_name, len(obj_list), kwargs)

Exception Type: MultipleObjectsReturned at /dashboard/
Exception Value: get() returned more than one ReviewRequestDraft -- it 
returned 2! Lookup parameters were {}

What is the expected output? What do you see instead?

What operating system are you using? What browser?

Please provide any additional information below.
Original issue reported on code.google.com by ilko.dra...@gmail.com on 13 Dec 2007 at 6:03
sureshvv / reviewboard

Exception when clicking on outgoing reviews link #320
