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 reviewboard@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to