id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 11370,"GeoQuery works fine in 1.0.2, but chokes on latest SVN",anonymous,nobody,"Here is the query: {{{ bounds = Envelope( (ex_W, ex_N, ex_E, ex_S) ) # these are all floats Base.objects.filter(location__intersects=bounds.wkt)[:1000] }}} the actual query that gets executed is: {{{ SELECT ""main_opbase"".""id"", ""main_opbase"".""operation_id"", ""main_opbase"".""base_id"", ""main_opbase"".""workforce_size"" FROM ""main_opbase"" WHERE ""main_opbase"".""base_id"" IN (SELECT U0.""identifier"" FROM ""main_base"" U0 WHERE ST_Intersects(""U0"".""location"", %s) LIMIT 1000) }}} here is the error output: {{{ Environment: Request Method: GET Request URL: http://localhost:8000/overlay_5_4_12_DMB/ Django Version: 1.1 beta 1 SVN-10952 Python Version: 2.6.2 Installed Applications: ['main', 'django_extensions', 'django.contrib.comments', 'django.contrib.admindocs', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.gis', 'django.contrib.humanize', 'registration', 'debug_toolbar', 'django_authopenid'] Installed Middleware: ('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware', 'django_authopenid.middleware.OpenIDMiddleware') Traceback: File ""/usr/lib/python2.6/dist-packages/django/core/handlers/base.py"" in get_response 92. response = callback(request, *callback_args, **callback_kwargs) File ""/home/chris/Websites/jobmap/main/overlays.py"" in overlay_view 202. ov.output().save(response, ""PNG"") File ""/home/chris/Websites/jobmap/main/overlays.py"" in output 99. self.create_queryset(self.o) File ""/home/chris/Websites/jobmap/main/overlays.py"" in create_queryset 150. if opbases: File ""/usr/lib/python2.6/dist-packages/django/db/models/query.py"" in __nonzero__ 112. iter(self).next() File ""/usr/lib/python2.6/dist-packages/django/db/models/query.py"" in _result_iter 106. self._fill_cache() File ""/usr/lib/python2.6/dist-packages/django/db/models/query.py"" in _fill_cache 692. self._result_cache.append(self._iter.next()) File ""/usr/lib/python2.6/dist-packages/django/db/models/query.py"" in iterator 238. for row in self.query.results_iter(): File ""/usr/lib/python2.6/dist-packages/django/db/models/sql/query.py"" in results_iter 287. for rows in self.execute_sql(MULTI): File ""/usr/lib/python2.6/dist-packages/django/db/models/sql/query.py"" in execute_sql 2369. cursor.execute(sql, params) File ""/usr/local/lib/python2.6/dist-packages/django_debug_toolbar-0.7.0-py2.6.egg/debug_toolbar/panels/sql.py"" in execute 44. return self.cursor.execute(sql, params) Exception Type: ProgrammingError at /overlay_5_4_12_DMB/ Exception Value: missing FROM-clause entry in subquery for table ""U0"" LINE 1: ...entifier"" FROM ""main_base"" U0 WHERE ST_Intersects(""U0"".""loca... }}} I'm using postGIS. I don't normally post bugs, so if I left anything essential out, please let me know and I'll add whatever is needed.",,closed,GIS,1.0,,invalid,,,Unreviewed,0,0,0,0,0,0