You probably need to update your version of sqlite3, and the make sure that you python is actually using the newer version. I think DISTINCT came in after sqlite 3.2.1.
Joseph On Sep 2, 5:03 pm, cep21 <[EMAIL PROTECTED]> wrote: > Fresh install. Error on main page. Here is my console log and web > page log. Any help appreciated. Thanks. > ------------------------- > OperationalError at /dashboard/ > > near "DISTINCT": syntax error > ------------------- > > 16:58:28 [EMAIL PROTECTED]:me/reviewboard/reviewboard$ ./manage.py runserver > Running dependency checks (set DEBUG=False to turn this off)... > Warning: p4python (>=08.1) not found. Perforce integration will not > work. > Warning: PyLucene (with JCC) is required to enable search. See the > documentation for instructions. > Warning: Syntax highlighting requires the Pygments library, which is > not installed. > > Please seehttp://code.google.com/p/reviewboard/wiki/GettingStarted > for help setting up Review Board. > > Validating models... > 0 errors found > > Django version 1.0-beta_2-SVN-unknown, using settings > 'reviewboard.settings' > Development server is running athttp://127.0.0.1:8000/ > Quit the server with CONTROL-C. > [02/Sep/2008 17:00:30] "GET /dashboard/ HTTP/1.1" 500 122137 > > -------------------------------------- > Environment: > > Request Method: GET > Request URL:http://localhost:8000/dashboard/ > Django Version: 1.0-beta_2-SVN-unknown > Python Version: 2.4.1 > Installed Applications: > ['django.contrib.admin', > 'django.contrib.auth', > 'django.contrib.contenttypes', > 'django.contrib.markup', > 'django.contrib.sites', > 'django.contrib.sessions', > 'djblets.datagrid', > 'djblets.feedview', > 'djblets.siteconfig', > 'djblets.util', > 'djblets.webapi', > 'reviewboard.accounts', > 'reviewboard.admin', > 'reviewboard.diffviewer', > 'reviewboard.iphone', > 'reviewboard.reports', > 'reviewboard.reviews', > 'reviewboard.scmtools', > 'reviewboard.webapi', > 'django_evolution'] > Installed Middleware: > ('django.middleware.common.CommonMiddleware', > 'django.middleware.doc.XViewMiddleware', > 'django.middleware.locale.LocaleMiddleware', > 'django.contrib.sessions.middleware.SessionMiddleware', > 'django.contrib.auth.middleware.AuthenticationMiddleware', > 'reviewboard.admin.middleware.CheckUpdatesRequiredMiddleware') > > Traceback: > File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py" > in get_response > 86. response = callback(request, *callback_args, > **callback_kwargs) > File "/data/me/reviewboard/reviewboard/djblets/auth/util.py" in > _checklogin > 45. return view_func(request, *args, **kwargs) > File "/data/me/reviewboard/reviewboard/accounts/decorators.py" in > _check_valid_prefs > 43. return view_func(request, *args, **kwargs) > File "/data/me/reviewboard/reviewboard/reviews/views.py" in dashboard > 180. return grid.render_to_response(template_name) > File "/data/me/reviewboard/reviewboard/djblets/datagrid/grids.py" in > render_to_response > 558. self.load_state() > File "/data/me/reviewboard/reviewboard/djblets/datagrid/grids.py" in > load_state > 449. self.precompute_objects() > File "/data/me/reviewboard/reviewboard/djblets/datagrid/grids.py" in > precompute_objects > 508. self.page = self.paginator.page(page_num) > File "/usr/lib/python2.4/site-packages/django/core/paginator.py" in > page > 37. number = self.validate_number(number) > File "/usr/lib/python2.4/site-packages/django/core/paginator.py" in > validate_number > 28. if number > self.num_pages: > File "/usr/lib/python2.4/site-packages/django/core/paginator.py" in > _get_num_pages > 60. if self.count == 0 and not > self.allow_empty_first_page: > File "/usr/lib/python2.4/site-packages/django/core/paginator.py" in > _get_count > 48. self._count = self.object_list.count() > File "/usr/lib/python2.4/site-packages/django/db/models/query.py" in > count > 288. return self.query.get_count() > File "/usr/lib/python2.4/site-packages/django/db/models/sql/query.py" > in get_count > 237. data = obj.execute_sql(SINGLE) > File "/usr/lib/python2.4/site-packages/django/db/models/sql/query.py" > in execute_sql > 1652. cursor.execute(sql, params) > File "/usr/lib/python2.4/site-packages/django/db/backends/util.py" in > execute > 19. return self.cursor.execute(sql, params) > File "/usr/lib/python2.4/site-packages/django/db/backends/sqlite3/ > base.py" in execute > 167. return Database.Cursor.execute(self, query, params) > > Exception Type: OperationalError at /dashboard/ > Exception Value: near "DISTINCT": syntax error --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "reviewboard" 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/reviewboard?hl=en -~----------~----~----~----~------~----~------~--~---
