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
7302	Bug in the query statement	ygpark2@…	nobody	"
Lately, I got this error

Environment:

Request Method: GET
Request URL: http://127.0.0.1:8000/pages/
Django Version: 0.97-pre-SVN-7548
Python Version: 2.5.2
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.admin',
 'pages',
 'hierarchical']
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.middleware.doc.XViewMiddleware')


Traceback:
File ""/Users/ygpark/lib/django_trunk/django/core/handlers/base.py"" in get_response
  82.                 response = callback(request, *callback_args, **callback_kwargs)
File ""/Users/ygpark/lib/django-page-cms/utils.py"" in _dec
  9.         response = func(request, *args, **kwargs)
File ""/Users/ygpark/lib/django-page-cms/pages/views.py"" in details
  12.     pages = HierarchicalNode.get_first_level_objects(Page)
File ""/Users/ygpark/lib/django-page-cms/hierarchical/models.py"" in get_first_level_objects
  98.         return [obj.object for obj in objs]
File ""/Users/ygpark/lib/django_trunk/django/db/models/query.py"" in _result_iter
  78.                 self._fill_cache()
File ""/Users/ygpark/lib/django_trunk/django/db/models/query.py"" in _fill_cache
  490.                     self._result_cache.append(self._iter.next())
File ""/Users/ygpark/lib/django_trunk/django/db/models/query.py"" in iterator
  162.         for row in self.query.results_iter():
File ""/Users/ygpark/lib/django_trunk/django/db/models/sql/query.py"" in results_iter
  200.         for rows in self.execute_sql(MULTI):
File ""/Users/ygpark/lib/django_trunk/django/db/models/sql/query.py"" in execute_sql
  1466.         cursor.execute(sql, params)
File ""/Users/ygpark/lib/django_trunk/django/db/backends/util.py"" in execute
  18.             return self.cursor.execute(sql, params)
File ""/Users/ygpark/lib/django_trunk/django/db/backends/sqlite3/base.py"" in execute
  136.         return Database.Cursor.execute(self, query, params)

Exception Type: OperationalError at /pages/
Exception Value: near ""order"": syntax error


I think this kind of sql syntax error is caused in the django framework.

So can you check whether this is bug or not?"		new	Database layer (models, ORM)	dev			sqlite, db, wrapper		Unreviewed	0	0	0	0	0	0