id summary reporter owner description type status priority component severity resolution keywords cc release 11234 ProgrammingError: non-integer constant in ORDER BY roland.wells@… Jun Omae "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 }}}" defect closed normal ContactsPlugin normal fixed