Opened 11 years ago

Last modified 9 years ago

#11234 closed defect

ProgrammingError: non-integer constant in ORDER BY — at Initial Version

Reported by: roland.wells@… Owned by: CM Lubinski
Priority: normal Component: ContactsPlugin
Severity: normal Keywords:
Cc: Trac Release:

Description

After installing and enabling the Contacts Plugin, I get the following error when navigating to the /contacts url.

Trac detected an internal error:
ProgrammingError: non-integer constant in ORDER BY

accompanied by the following error in the system log:

Jul 22 15:38:04 ledger postgres[36234]: [3-1] ERROR:  non-integer constant in ORDER BY
Jul 22 15:38:04 ledger postgres[36234]: [3-2] STATEMENT:  
Jul 22 15:38:04 ledger postgres[36234]: [3-3] SELECT id, first, last, position, email, phone
Jul 22 15:38:04 ledger postgres[36234]: [3-4] FROM contact ORDER BY E'last',E'first'

System Info: FreeBSD 8.3 postgresql-server-8.3.22 Trac 1.0.1 Babel 0.9.6 Docutils 0.10 FullBlog 0.1.1 Genshi 0.7 (with speedups) mod_wsgi 3.4 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL}) Pygments 1.6 Python 2.7.5 (default, Jul 22 2013, 00:04:17) [GCC 4.2.2 20070831 prerelease [FreeBSD]] pytz 2013b setuptools 0.6c11 Subversion 1.8.0 (r1490375) jQuery 1.4.4

Enabled Plugins: contacts 0.1 /home/wellsolives/trac/plugins/contacts-0.1-py2.7.egg graphviz 0.7.4 /usr/local/lib/python2.7/site-packages/graphviz-0.7.4-py2.7.egg TracFullBlogPlugin 0.1.1 /usr/local/lib/python2.7/site-packages/TracFullBlogPlugin-0.1.1-py2.7.egg TracTags 0.7dev /usr/local/lib/python2.7/site-packages/TracTags-0.7dev-py2.7.egg TracGuide — The Trac User and Administration Guide

Change History (0)

Note: See TracTickets for help on using tickets.