ProgrammingError at /guide/real-estate/east/woodbine-corridor/

Request Method:	GET
Request URL:	http://www.torontolife.com/guide/real-estate/east/woodbine-corridor/
Exception Type:	ProgrammingError
Exception Value:	ERROR: cannot convert empty polygon to circle SELECT a.listing_id,a.id,point(a.longitude,a.latitude) FROM city_guides_restaurantlocations AS a, city_guides_hoods AS b WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL AND circle(b.hood_polygon) ~ point(a.longitude,a.latitude) AND b.id = 75
Exception Location:	/var/devel/django/core/db/base.py in execute, line 9

30	{% if listing.vibe_info %}
31	<h5>Vibe</h5>
32	<p>{{listing.vibe_info}}</p>
33	{% endif %}
34
35	{% if listing.selling_features %}
36	<h5>Selling Features</h5>
37	<p>{{listing.selling_features}}</p>
38	{% endif %}
39	</div>
40	{% nearby_restaurants for listing as neareats %}
41	<!-- googleoff: index -->
42	<div class="divider">
43	<h5>Nearby Restaurants</h5>
44	{% if neareats %}
45	{% for r in neareats\|slice:":7" %}
46	<h6 class="alt_link"><a href="{{r.url}}">{{r.name}}</a></h6>
47	<p>{{r.content\|truncatewords:"15"}} ({{r.distance}} km away)</p>
48	{% endfor %}
49
50	<ul>

Traceback (innermost last)

/usr/lib/python2.4/django-old/django/core/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:
from sys import exc_info

▶ Local vars

Variable	Value
context	[{'block': <Block Node: content. Contents: [<Text Node: ' <div id="content"> '>, <Variable Node: guide>, <Text Node: ' Guide</a> › <a hre'>, <Variable Node: category>, <Text Node: '</a></h2> <h1 class='>, <Variable Node: listing>, <Text Node: '</h1> '>, <If node>, <Text Node: ' <div id="c0a"> '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' </div> '>, <django.templatetags.hood_extras.NearRestaurantNode instance at 0x9b1e6ac>, <Text Node: ' <!-- googleoff: in'>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x963c0ec>, <Text Node: ' </div> '>, <django.templatetags.hood_extras.NearShopNode instance at 0x963c18c>, <Text Node: ' <div class='>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x946496c>, <Text Node: ' </div> <!-- '>, <django.core.template.defaulttags.CommentNode instance at 0x945806c>, <Text Node: ' </div> '>, <django.core.template.defaulttags.CommentNode instance at 0x9475f2c>, <Text Node: ' <style> '>, <Block Node: guide_info. Contents: [<Text Node: ' <script t'>, <Variable Node: listing.hood_polygon>, <Text Node: '"; </script> '>, <django.templatetags.hood_extras.HoodMarkNode instance at 0x9475b0c>, <Text Node: ' '>, <django.templatetags.hood_extras.HoodMarkNode instance at 0x94b408c>, <Text Node: ' <dl class="gu'>, <For Node: for n in intersections, tail_len: 5>, <Text Node: ' '>, <For Node: for n in ttc\|slice:":3", tail_len: 5>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x96d6c8c>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x94ad68c>, <Text Node: ' </dl> <p '>]>, <Text Node: ' '>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x94ad3ec>, <Text Node: ' </div> '>, <Block Node: guide_search. Contents: [<Text Node: ' '>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x94ad12c>, <Text Node: ' '>]>, <Text Node: ' <div id="issue-link'>, <django.core.template.defaulttags.LoadNode instance at 0x94adbec>, <Text Node: ' '>, <django.templatetags.contents_cover.CoverNode instance at 0x94ad9ec>, <Text Node: ' <a href="'>, <Variable Node: latest_cover.get_absolute_url>, <Text Node: '"><img src="'>, <Variable Node: latest_cover.get_image_small_url>, <Text Node: '" alt="Current Issue" ali'>, <django.core.template.defaulttags.LoadNode instance at 0x94addac>, <Text Node: ' '>, <django.templatetags.contest_extras.ContestNode instance at 0x9b00b2c>, <Text Node: ' '>, <For Node: for contest in contest_list, tail_len: 7>, <Text Node: ' </ul> <'>, <django.core.template.SimpleNode instance at 0x9b0066c>, <Text Node: '/img/cityguides.gif" alt='>, <django.core.template.defaulttags.LoadNode instance at 0x9b007cc>, <Text Node: ' '>, <torontolife.utils.template.GenericListNode instance at 0x9b02e4c>, <Text Node: ' '>, <For Node: for guide in footer_guides, tail_len: 5>, <Text Node: ' </ul> </d'>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x9b1e62c>, <Text Node: ' </div> </div> '>, <django.templatetags.tracking_tags.TracViewNode instance at 0x9b1e98c>, <Text Node: ' '>]>}, [{}, {'request': <DjangoRequest GET:<MultiValueDict: {}>, POST:<MultiValueDict: {}>, COOKIES:{}, META:{'DJANGO_SETTINGS_MODULE': 'torontolife.settings', 'DOCUMENT_ROOT': '/var/www/torontolife/', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'Accept: application/xhtml+xml,text/html;q=0.9,text/plain;', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip', 'HTTP_ACCEPT_LANGUAGE': 'en-us,en;q=0.5', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': 'www.torontolife.com', 'HTTP_PRAGMA': 'no-cache', 'HTTP_USER_AGENT': 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 'PATH': '/sbin:/usr/sbin:/bin:/usr/bin', 'PATH_INFO': '/guide/real-estate/east/woodbine-corridor/', 'PATH_TRANSLATED': '/var/www/torontolife/torontolife.fcgi/guide/real-estate/east/woodbine-corridor/', 'PYTHONPATH': '/usr/lib/python2.4/django-old', 'QUERY_STRING': '', 'REMOTE_ADDR': '38.103.63.18', 'REMOTE_PORT': '41981', 'REQUEST_METHOD': 'GET', 'REQUEST_URI': '/guide/real-estate/east/woodbine-corridor/', 'SCRIPT_FILENAME': '/var/www/torontolife/torontolife.fcgi', 'SCRIPT_NAME': '/torontolife.fcgi', 'SCRIPT_URI': 'http://www.torontolife.com/guide/real-estate/east/woodbine-corridor/', 'SCRIPT_URL': '/guide/real-estate/east/woodbine-corridor/', 'SERVER_ADDR': '192.168.11.38', 'SERVER_ADMIN': 'jfernandes@stjosephmedia.com', 'SERVER_NAME': 'www.torontolife.com', 'SERVER_PORT': '80', 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SIGNATURE': '<address>Apache/2.2.8 (EL) Server at www.torontolife.com Port 80</address>\n', 'SERVER_SOFTWARE': 'Apache/2.2.8 (EL)', 'wsgi.errors': <flup.server.fcgi_base.OutputStream object at 0x9b02b2c>, 'wsgi.input': <flup.server.fcgi_base.InputStream object at 0x9b0256c>, 'wsgi.multiprocess': False, 'wsgi.multithread': True, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': (1, 0)}>}, {'LANGUAGES': (('bn', 'Bengali'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('en', 'English'), ('es', 'Spanish'), ('fr', 'French'), ('gl', 'Galician'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('pt-br', 'Brazilian'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sr', 'Serbian'), ('sv', 'Swedish'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese')), 'LANGUAGE_CODE': 'en-us'}, {}, {'perms': <django.core.context_processors.PermWrapper instance at 0x945870c>, 'messages': [], 'user': AnonymousUser}, {'category': East, 'tab_name': 'overview', 'upgraded_listings': [], 'guide': Real Estate, 'stuff': {'listing_content_truncated_at_75': False}, 'listing': Woodbine Corridor, 'slug': 'real-estate'}]]
exc_info	<built-in function exc_info>
node	<django.templatetags.hood_extras.NearRestaurantNode instance at 0x9b1e6ac>
self	[<Text Node: ' <div id="content"> '>, <Variable Node: guide>, <Text Node: ' Guide</a> › <a hre'>, <Variable Node: category>, <Text Node: '</a></h2> <h1 class='>, <Variable Node: listing>, <Text Node: '</h1> '>, <If node>, <Text Node: ' <div id="c0a"> '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' </div> '>, <django.templatetags.hood_extras.NearRestaurantNode instance at 0x9b1e6ac>, <Text Node: ' <!-- googleoff: in'>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x963c0ec>, <Text Node: ' </div> '>, <django.templatetags.hood_extras.NearShopNode instance at 0x963c18c>, <Text Node: ' <div class='>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x946496c>, <Text Node: ' </div> <!-- '>, <django.core.template.defaulttags.CommentNode instance at 0x945806c>, <Text Node: ' </div> '>, <django.core.template.defaulttags.CommentNode instance at 0x9475f2c>, <Text Node: ' <style> '>, <Block Node: guide_info. Contents: [<Text Node: ' <script t'>, <Variable Node: listing.hood_polygon>, <Text Node: '"; </script> '>, <django.templatetags.hood_extras.HoodMarkNode instance at 0x9475b0c>, <Text Node: ' '>, <django.templatetags.hood_extras.HoodMarkNode instance at 0x94b408c>, <Text Node: ' <dl class="gu'>, <For Node: for n in intersections, tail_len: 5>, <Text Node: ' '>, <For Node: for n in ttc\|slice:":3", tail_len: 5>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x96d6c8c>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x94ad68c>, <Text Node: ' </dl> <p '>]>, <Text Node: ' '>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x94ad3ec>, <Text Node: ' </div> '>, <Block Node: guide_search. Contents: [<Text Node: ' '>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x94ad12c>, <Text Node: ' '>]>, <Text Node: ' <div id="issue-link'>, <django.core.template.defaulttags.LoadNode instance at 0x94adbec>, <Text Node: ' '>, <django.templatetags.contents_cover.CoverNode instance at 0x94ad9ec>, <Text Node: ' <a href="'>, <Variable Node: latest_cover.get_absolute_url>, <Text Node: '"><img src="'>, <Variable Node: latest_cover.get_image_small_url>, <Text Node: '" alt="Current Issue" ali'>, <django.core.template.defaulttags.LoadNode instance at 0x94addac>, <Text Node: ' '>, <django.templatetags.contest_extras.ContestNode instance at 0x9b00b2c>, <Text Node: ' '>, <For Node: for contest in contest_list, tail_len: 7>, <Text Node: ' </ul> <'>, <django.core.template.SimpleNode instance at 0x9b0066c>, <Text Node: '/img/cityguides.gif" alt='>, <django.core.template.defaulttags.LoadNode instance at 0x9b007cc>, <Text Node: ' '>, <torontolife.utils.template.GenericListNode instance at 0x9b02e4c>, <Text Node: ' '>, <For Node: for guide in footer_guides, tail_len: 5>, <Text Node: ' </ul> </d'>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x9b1e62c>, <Text Node: ' </div> </div> '>, <django.templatetags.tracking_tags.TracViewNode instance at 0x9b1e98c>, <Text Node: ' '>]
wrapped	<django.core.template.TemplateSyntaxError instance at 0x96f938c>

/usr/lib/python2.4/site-packages/torontolife/city_guides/templatetags/hood_extras.py in render

cur.close()
#return [r[0] for r in rs]
return rs
def render(self, context):
r = []
listing = context[self.listing_name]
if listing.hood_polygon:

n = self.get_those_within_polygon_circle(listing) ...

if n:
r = [ {'content':i.content,'url':i.get_absolute_url(),'name':i.title,'id':i.id} for i in restaurants.get_list(enabled__exact=True,id__in=[i[0] for i in n]) ]
if r: #ok we have some results calculate distances and sort
#make an n hash
nhash = {}
for i in n:

▶ Local vars

Variable	Value
context	[{'block': <Block Node: content. Contents: [<Text Node: ' <div id="content"> '>, <Variable Node: guide>, <Text Node: ' Guide</a> › <a hre'>, <Variable Node: category>, <Text Node: '</a></h2> <h1 class='>, <Variable Node: listing>, <Text Node: '</h1> '>, <If node>, <Text Node: ' <div id="c0a"> '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' </div> '>, <django.templatetags.hood_extras.NearRestaurantNode instance at 0x9b1e6ac>, <Text Node: ' <!-- googleoff: in'>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x963c0ec>, <Text Node: ' </div> '>, <django.templatetags.hood_extras.NearShopNode instance at 0x963c18c>, <Text Node: ' <div class='>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x946496c>, <Text Node: ' </div> <!-- '>, <django.core.template.defaulttags.CommentNode instance at 0x945806c>, <Text Node: ' </div> '>, <django.core.template.defaulttags.CommentNode instance at 0x9475f2c>, <Text Node: ' <style> '>, <Block Node: guide_info. Contents: [<Text Node: ' <script t'>, <Variable Node: listing.hood_polygon>, <Text Node: '"; </script> '>, <django.templatetags.hood_extras.HoodMarkNode instance at 0x9475b0c>, <Text Node: ' '>, <django.templatetags.hood_extras.HoodMarkNode instance at 0x94b408c>, <Text Node: ' <dl class="gu'>, <For Node: for n in intersections, tail_len: 5>, <Text Node: ' '>, <For Node: for n in ttc\|slice:":3", tail_len: 5>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x96d6c8c>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <If node>, <Text Node: ' '>, <django.core.template.defaulttags.CommentNode instance at 0x94ad68c>, <Text Node: ' </dl> <p '>]>, <Text Node: ' '>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x94ad3ec>, <Text Node: ' </div> '>, <Block Node: guide_search. Contents: [<Text Node: ' '>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x94ad12c>, <Text Node: ' '>]>, <Text Node: ' <div id="issue-link'>, <django.core.template.defaulttags.LoadNode instance at 0x94adbec>, <Text Node: ' '>, <django.templatetags.contents_cover.CoverNode instance at 0x94ad9ec>, <Text Node: ' <a href="'>, <Variable Node: latest_cover.get_absolute_url>, <Text Node: '"><img src="'>, <Variable Node: latest_cover.get_image_small_url>, <Text Node: '" alt="Current Issue" ali'>, <django.core.template.defaulttags.LoadNode instance at 0x94addac>, <Text Node: ' '>, <django.templatetags.contest_extras.ContestNode instance at 0x9b00b2c>, <Text Node: ' '>, <For Node: for contest in contest_list, tail_len: 7>, <Text Node: ' </ul> <'>, <django.core.template.SimpleNode instance at 0x9b0066c>, <Text Node: '/img/cityguides.gif" alt='>, <django.core.template.defaulttags.LoadNode instance at 0x9b007cc>, <Text Node: ' '>, <torontolife.utils.template.GenericListNode instance at 0x9b02e4c>, <Text Node: ' '>, <For Node: for guide in footer_guides, tail_len: 5>, <Text Node: ' </ul> </d'>, <django.core.template.loader_tags.ConstantIncludeNode instance at 0x9b1e62c>, <Text Node: ' </div> </div> '>, <django.templatetags.tracking_tags.TracViewNode instance at 0x9b1e98c>, <Text Node: ' '>]>}, [{}, {'request': <DjangoRequest GET:<MultiValueDict: {}>, POST:<MultiValueDict: {}>, COOKIES:{}, META:{'DJANGO_SETTINGS_MODULE': 'torontolife.settings', 'DOCUMENT_ROOT': '/var/www/torontolife/', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'Accept: application/xhtml+xml,text/html;q=0.9,text/plain;', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip', 'HTTP_ACCEPT_LANGUAGE': 'en-us,en;q=0.5', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': 'www.torontolife.com', 'HTTP_PRAGMA': 'no-cache', 'HTTP_USER_AGENT': 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 'PATH': '/sbin:/usr/sbin:/bin:/usr/bin', 'PATH_INFO': '/guide/real-estate/east/woodbine-corridor/', 'PATH_TRANSLATED': '/var/www/torontolife/torontolife.fcgi/guide/real-estate/east/woodbine-corridor/', 'PYTHONPATH': '/usr/lib/python2.4/django-old', 'QUERY_STRING': '', 'REMOTE_ADDR': '38.103.63.18', 'REMOTE_PORT': '41981', 'REQUEST_METHOD': 'GET', 'REQUEST_URI': '/guide/real-estate/east/woodbine-corridor/', 'SCRIPT_FILENAME': '/var/www/torontolife/torontolife.fcgi', 'SCRIPT_NAME': '/torontolife.fcgi', 'SCRIPT_URI': 'http://www.torontolife.com/guide/real-estate/east/woodbine-corridor/', 'SCRIPT_URL': '/guide/real-estate/east/woodbine-corridor/', 'SERVER_ADDR': '192.168.11.38', 'SERVER_ADMIN': 'jfernandes@stjosephmedia.com', 'SERVER_NAME': 'www.torontolife.com', 'SERVER_PORT': '80', 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SIGNATURE': '<address>Apache/2.2.8 (EL) Server at www.torontolife.com Port 80</address>\n', 'SERVER_SOFTWARE': 'Apache/2.2.8 (EL)', 'wsgi.errors': <flup.server.fcgi_base.OutputStream object at 0x9b02b2c>, 'wsgi.input': <flup.server.fcgi_base.InputStream object at 0x9b0256c>, 'wsgi.multiprocess': False, 'wsgi.multithread': True, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': (1, 0)}>}, {'LANGUAGES': (('bn', 'Bengali'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('en', 'English'), ('es', 'Spanish'), ('fr', 'French'), ('gl', 'Galician'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('pt-br', 'Brazilian'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sr', 'Serbian'), ('sv', 'Swedish'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese')), 'LANGUAGE_CODE': 'en-us'}, {}, {'perms': <django.core.context_processors.PermWrapper instance at 0x945870c>, 'messages': [], 'user': AnonymousUser}, {'category': East, 'tab_name': 'overview', 'upgraded_listings': [], 'guide': Real Estate, 'stuff': {'listing_content_truncated_at_75': False}, 'listing': Woodbine Corridor, 'slug': 'real-estate'}]]
listing	Woodbine Corridor
r	[]
self	<django.templatetags.hood_extras.NearRestaurantNode instance at 0x9b1e6ac>

/usr/lib/python2.4/site-packages/torontolife/city_guides/templatetags/hood_extras.py in get_those_within_polygon_circle

class NearRestaurantNode(Node):
def __init__(self, listing_name,var_name):
self.listing_name = listing_name
self.var_name = var_name
def get_those_within_polygon_circle(self,listing):
sql = "SELECT a.listing_id,a.id,point(a.longitude,a.latitude) FROM city_guides_restaurantlocations AS a, city_guides_hoods AS b WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL AND circle(b.hood_polygon) ~ point(a.longitude,a.latitude) AND b.id = %d"
cur = db.cursor()

cur.execute(sql,(listing.id,)) ...

rs = cur.fetchall()
cur.close()
#return [r[0] for r in rs]
return rs
def render(self, context):
r = []

▶ Local vars

Variable	Value
cur	<django.core.db.base.CursorDebugWrapper instance at 0x9b6188c>
listing	Woodbine Corridor
self	<django.templatetags.hood_extras.NearRestaurantNode instance at 0x9b1e6ac>
sql	'SELECT a.listing_id,a.id,point(a.longitude,a.latitude) FROM city_guides_restaurantlocations AS a, city_guides_hoods AS b WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL AND circle(b.hood_polygon) ~ point(a.longitude,a.latitude) AND b.id = %d'

/var/devel/django/core/db/base.py in execute

▶ Local vars

Variable	Value
params	(75,)
self	<django.core.db.base.CursorDebugWrapper instance at 0x9b6188c>
sql	'SELECT a.listing_id,a.id,point(a.longitude,a.latitude) FROM city_guides_restaurantlocations AS a, city_guides_hoods AS b WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL AND circle(b.hood_polygon) ~ point(a.longitude,a.latitude) AND b.id = %d'
start	1210342467.839257

Request information

GET

No GET data

POST

No POST data

No cookie data

Variable	Value
DJANGO_SETTINGS_MODULE	'torontolife.settings'
DOCUMENT_ROOT	'/var/www/torontolife/'
GATEWAY_INTERFACE	'CGI/1.1'
HTTP_ACCEPT	'Accept: application/xhtml+xml,text/html;q=0.9,text/plain;'
HTTP_ACCEPT_CHARSET	'ISO-8859-1,utf-8;q=0.7,*;q=0.7'
HTTP_ACCEPT_ENCODING	'gzip'
HTTP_ACCEPT_LANGUAGE	'en-us,en;q=0.5'
HTTP_CACHE_CONTROL	'no-cache'
HTTP_CONNECTION	'close'
HTTP_HOST	'www.torontolife.com'
HTTP_PRAGMA	'no-cache'
HTTP_USER_AGENT	'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
PATH	'/sbin:/usr/sbin:/bin:/usr/bin'
PATH_INFO	'/guide/real-estate/east/woodbine-corridor/'
PATH_TRANSLATED	'/var/www/torontolife/torontolife.fcgi/guide/real-estate/east/woodbine-corridor/'
PYTHONPATH	'/usr/lib/python2.4/django-old'
QUERY_STRING	''
REMOTE_ADDR	'38.103.63.18'
REMOTE_PORT	'41981'
REQUEST_METHOD	'GET'
REQUEST_URI	'/guide/real-estate/east/woodbine-corridor/'
SCRIPT_FILENAME	'/var/www/torontolife/torontolife.fcgi'
SCRIPT_NAME	'/torontolife.fcgi'
SCRIPT_URI	'http://www.torontolife.com/guide/real-estate/east/woodbine-corridor/'
SCRIPT_URL	'/guide/real-estate/east/woodbine-corridor/'
SERVER_ADDR	'192.168.11.38'
SERVER_ADMIN	'jfernandes@stjosephmedia.com'
SERVER_NAME	'www.torontolife.com'
SERVER_PORT	'80'
SERVER_PROTOCOL	'HTTP/1.1'
SERVER_SIGNATURE	'<address>Apache/2.2.8 (EL) Server at www.torontolife.com Port 80</address>\n'
SERVER_SOFTWARE	'Apache/2.2.8 (EL)'
wsgi.errors	<flup.server.fcgi_base.OutputStream object at 0x9b02b2c>
wsgi.input	<flup.server.fcgi_base.InputStream object at 0x9b0256c>
wsgi.multiprocess	False
wsgi.multithread	True
wsgi.run_once	False
wsgi.url_scheme	'http'
wsgi.version	(1, 0)

Settings

Using settings module `torontolife.settings`

Setting	Value
ABSOLUTE_URL_OVERRIDES	{}
ADMINS	(('John', 'jfernandes@stjosephmedia.com'),)
ADMIN_FOR	()
ADMIN_MEDIA_PREFIX	'http://media.torontolife.com/admin/'
ALLOWED_INCLUDE_ROOTS	()
APPEND_SLASH	True
BANNED_IPS	()
CACHE_BACKEND	'memcached://127.0.0.1:11211/?timeout=600'
CACHE_MIDDLEWARE_ANONYMOUS_ONLY	True
CACHE_MIDDLEWARE_KEY_PREFIX	'TL'
CACHE_MIDDLEWARE_SECONDS	600
COMMENTS_ALLOW_PROFANITIES	False
COMMENTS_BANNED_USERS_GROUP	None
COMMENTS_FIRST_FEW	0
COMMENTS_MODERATORS_GROUP	None
COMMENTS_SKETCHY_USERS_GROUP	None
DATABASE_ENGINE	'postgresql'
DATABASE_HOST	'192.168.11.40'
DATABASE_NAME	'torontolife'
DATABASE_PASSWORD	'********************'
DATABASE_PORT	'5432'
DATABASE_USER	'sa'
DATETIME_FORMAT	'N j, Y, P'
DATE_FORMAT	'N j, Y'
DEBUG	True
DEFAULT_CHARSET	'utf-8'
DEFAULT_CONTENT_TYPE	'text/html'
DEFAULT_FROM_EMAIL	'webmaster@torontolife.com'
DISALLOWED_USER_AGENTS	()
EMAIL_HOST	'localhost'
EMAIL_SUBJECT_PREFIX	'[Django] '
ENABLE_PSYCO	False
ENV	'live'
ENVIRONMENT_VARIABLE	'DJANGO_SETTINGS_MODULE'
GOOGLE_MAPS_KEY	'ABQIAAAA9Z4Bx_9SyU1R8oUhhz44SRTz6RWnNdg6fFBvdfSYjqZuFj5qmBQXkgzgVNMJZKCvvfooWWDPTRpEPQ'
GPG_HOME	'/var/wwwgpg'
HTTPS_MEDIA_URL	'/media/'
HTTP_MEDIA_URL	'http://media.torontolife.com'
IGNORABLE_404_ENDS	('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php')
IGNORABLE_404_STARTS	('/cgi-bin/', '/_vti_bin', '/_vti_inf')
INSTALLED_APPS	['django.contrib.admin', 'django.contrib.flatpages', 'django.contrib.redirects', 'sjm.apps.blogtool', 'sjm.apps.discussion', 'sjm.apps.tracking', 'sjm.apps.tredirects', 'sjm.apps.errorform', 'sjm.apps.captcha', 'torontolife.accounts', 'torontolife.assorted', 'torontolife.blog', 'torontolife.button_management', 'torontolife.city_guides', 'torontolife.comments', 'torontolife.conradblack', 'torontolife.contents_cover', 'torontolife.contest', 'torontolife.custom_promo', 'torontolife.feature_articles', 'torontolife.feeds', 'torontolife.homepage', 'torontolife.landmarks', 'torontolife.marketplace', 'torontolife.miscellaneous', 'torontolife.movieblog', 'torontolife.orders', 'torontolife.pillars', 'torontolife.smsalert', 'torontolife.template_admin', 'torontolife.temp_registration', 'torontolife.todo_today', 'torontolife.urban_decoder', 'torontolife.user', 'torontolife.weather_feed', 'torontolife.wineblog', 'geopy']
INTERNAL_IPS	()
JING_PATH	'/usr/bin/jing'
LANGUAGES	(('bn', 'Bengali'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('en', 'English'), ('es', 'Spanish'), ('fr', 'French'), ('gl', 'Galician'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('pt-br', 'Brazilian'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sr', 'Serbian'), ('sv', 'Swedish'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese'))
LANGUAGE_CODE	'en-us'
LEGACY_HOST	'legacy.torontolife.com'
LOGGER	None
LOGGER_FILE	'/tmp/torontolife.log'
LOGGER_NAME	'TorontoLife'
MANAGERS	(('John', 'jfernandes@stjosephmedia.com'),)
MEDIA_ROOT	'/var/www/torontolife/media/'
MEDIA_URL	'http://media.torontolife.com'
MIDDLEWARE_CLASSES	('django.middleware.common.CommonMiddleware', 'django.middleware.sessions.SessionMiddleware', 'django.middleware.doc.XViewMiddleware', 'django.middleware.cache.CacheMiddleware', 'sjm.utils.middleware.GZipMiddleware', 'sjm.utils.middleware.MediaUrlMiddleware', 'sjm.utils.middleware.SwitchToHttpMiddleware', 'sjm.apps.tredirects.middleware.RedirectFallbackMiddleware', 'django.contrib.redirects.middleware.RedirectFallbackMiddleware', 'torontolife.utils.middleware.FlatpageFallbackMiddleware')
ORDERS_LOCAL_USER	'webmaster@torontolife.com'
ORDERS_PHRASE	'Miloofthe cool12345-'
ORDERS_RECIPIENTS	['mlam@stjosephmedia.com', 'agabrielian@stjosephmedia.com']
PREPEND_WWW	False
RE_SUBCOLLECTION	'tl_realestate'
ROOT_URLCONF	'torontolife.urls'
SEARCH_PAGE_SIZE	10
SEARCH_SERVER	'206.191.88.168'
SECRET_KEY	'********************'
SEND_BROKEN_LINK_EMAILS	False
SERVER_EMAIL	'django@torontolife.com'
SESSION_COOKIE_AGE	1209600
SESSION_COOKIE_DOMAIN	None
SESSION_COOKIE_NAME	'sessionid'
SESSION_SAVE_EVERY_REQUEST	False
SETTINGS_MODULE	'torontolife.settings'
SITE_ID	1
SUBCOLLECTION	'torontolife'
TEMPLATE_CONTEXT_PROCESSORS	('django.core.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.request', 'sjm.utils.context_processors.browser_detection')
TEMPLATE_DEBUG	True
TEMPLATE_DIRS	('/var/devel/torontolife/templates',)
TEMPLATE_FILE_EXTENSION	'.html'
TEMPLATE_LOADERS	('django.core.template.loaders.filesystem.load_template_source', 'sjm.template.loaders.load_template_source', 'django.core.template.loaders.app_directories.load_template_source')
TEMPLATE_STRING_IF_INVALID	''
TIME_FORMAT	'P'
TIME_ZONE	'America/Toronto'
USE_ETAGS	False
UUMS_SITE_ID	5
YAHOO_MAPS_KEY	'u6a3ZnTV34FPvGpyeHZRv_PZooXkmdlUQDhev6G6eAh.NSTry.TIS4Q_MPMb814-'

ProgrammingError at /guide/real-estate/east/woodbine-corridor/

ERROR: cannot convert empty polygon to circle SELECT a.listing_id,a.id,point(a.longitude,a.latitude) FROM city_guides_restaurantlocations AS a, city_guides_hoods AS b WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL AND circle(b.hood_polygon) ~ point(a.longitude,a.latitude) AND b.id = 75

Template error

Caught an exception while rendering.

Traceback (innermost last)

Request information

GET

POST

META

Settings

Using settings module `torontolife.settings`

ProgrammingError at /guide/real-estate/east/woodbine-corridor/

ERROR: cannot convert empty polygon to circle SELECT a.listing_id,a.id,point(a.longitude,a.latitude) FROM city_guides_restaurantlocations AS a, city_guides_hoods AS b WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL AND circle(b.hood_polygon) ~ point(a.longitude,a.latitude) AND b.id = 75

Template error

Caught an exception while rendering.

Traceback (innermost last)

Request information

GET

POST

COOKIES

META

Settings

Using settings module torontolife.settings

Using settings module `torontolife.settings`