Issue 67: Swaps break on PostgreSQL
http://code.google.com/p/django-hotclub/issues/detail?id=67
Comment #1 by bengtfrost:
Confirm this 'errata' on my Debian system with python 2.5.2-11 and
python-psycopg
2.0.7-4 (plus libapache2-mod-wsgi - 2.3-1). Debug-Exception at bottom.
Works on OpenBSD 4.3 with python-2.5.2 and py-psycopg2-2.0.6.
(plus added extra port mod_wsgi-2.3)
Debug starts here:
INSERT INTO "crashlog_error"
("class_name", "message", "traceback", "datetime",
"url", "server_name")
VALUES (E'TemplateSyntaxError', E'Caught an exception while rendering:
FEL: operator
existerar inte: character varying = integer
LINE 1: ...s" FROM "swaps_offer" WHERE "swaps_offer"."state" = 1 ORDER...
^
HINT: No operator matches the given name and argument type(s). You might
need to add
explicit type casts.
', E'Traceback (most recent call last):
File
"/home/bfrost/development/python/django-trunk/django/core/handlers/base.py",
line 86, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File
"/home/bfrost/development/python/django-trunk/django/contrib/auth/decorators.py",
line 67, in __call__
return self.view_func(request, *args, **kwargs)
File
"/home/bfrost/development/python/django-hotclub/external_apps/swaps/views.py",
line 29, in offers
return render_to_response("swaps/offers.html", {"offers": offers},
context_instance=RequestContext(request))
File
"/home/bfrost/development/python/django-trunk/django/shortcuts/__init__.py",
line 18, in render_to_response
return HttpResponse(loader.render_to_string(*args, **kwargs),
**httpresponse_kwargs)
File "/home/bfrost/development/python/django-trunk/django/template/loader.py",
line
107, in render_to_string
return t.render(context_instance)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 176, in render
return self.nodelist.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 768, in render
bits.append(self.render_node(node, context))
File "/home/bfrost/development/python/django-trunk/django/template/debug.py",
line
71, in render_node
result = node.render(context)
File
"/home/bfrost/development/python/django-trunk/django/template/loader_tags.py",
line 97, in render
return compiled_parent.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 176, in render
return self.nodelist.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 768, in render
bits.append(self.render_node(node, context))
File "/home/bfrost/development/python/django-trunk/django/template/debug.py",
line
71, in render_node
result = node.render(context)
File
"/home/bfrost/development/python/django-trunk/django/template/loader_tags.py",
line 97, in render
return compiled_parent.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 176, in render
return self.nodelist.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 768, in render
bits.append(self.render_node(node, context))
File "/home/bfrost/development/python/django-trunk/django/template/debug.py",
line
71, in render_node
result = node.render(context)
File
"/home/bfrost/development/python/django-trunk/django/template/loader_tags.py",
line 97, in render
return compiled_parent.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 176, in render
return self.nodelist.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 768, in render
bits.append(self.render_node(node, context))
File "/home/bfrost/development/python/django-trunk/django/template/debug.py",
line
71, in render_node
result = node.render(context)
File
"/home/bfrost/development/python/django-trunk/django/template/loader_tags.py",
line 24, in render
result = self.nodelist.render(context)
File "/home/bfrost/development/python/django-trunk/django/template/__init__.py",
line 768, in render
bits.append(self.render_node(node, context))
File "/home/bfrost/development/python/django-trunk/django/template/debug.py",
line
81, in render_node
raise wrapped
TemplateSyntaxError: Caught an exception while rendering: FEL: operator
existerar
inte: character varying = integer
LINE 1: ...s" FROM "swaps_offer" WHERE "swaps_offer"."state" = 1 ORDER...
^
HINT: No operator matches the given name and argument type(s). You might
need to add
explicit type casts.
Original Traceback (most recent call last):
File "/home/bfrost/development/python/django-trunk/django/template/debug.py",
line
71, in render_node
result = node.render(context)
File
"/home/bfrost/development/python/django-trunk/django/template/defaulttags.py",
line 244, in render
if (value and not ifnot) or (ifnot and not value):
File "/home/bfrost/development/python/django-trunk/django/db/models/query.py",
line
185, in __nonzero__
iter(self).next()
File "/home/bfrost/development/python/django-trunk/django/db/models/query.py",
line
179, in _result_iter
self._fill_cache()
File "/home/bfrost/development/python/django-trunk/django/db/models/query.py",
line
612, in _fill_cache
self._result_cache.append(self._iter.next())
File "/home/bfrost/development/python/django-trunk/django/db/models/query.py",
line
269, in iterator
for row in self.query.results_iter():
File
"/home/bfrost/development/python/django-trunk/django/db/models/sql/query.py",
line 206, in results_iter
for rows in self.execute_sql(MULTI):
File
"/home/bfrost/development/python/django-trunk/django/db/models/sql/query.py",
line 1724, in execute_sql
cursor.execute(sql, params)
File "/home/bfrost/development/python/django-trunk/django/db/backends/util.py",
line 19, in execute
return self.cursor.execute(sql, params)
ProgrammingError: FEL: operator existerar inte: character varying = integer
LINE 1: ...s" FROM "swaps_offer" WHERE "swaps_offer"."state" = 1 ORDER...
^
HINT: No operator matches the given name and argument type(s). You might
need to add
explicit type casts.
', E'2008-10-01 14:58:48.396480', E'http://www.pinax.local/swaps/',
E'universe')
--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pinax-updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/pinax-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
