id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
11234	ProgrammingError: non-integer constant in ORDER BY	roland.wells@…	Ryan J Ollos	"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	accepted	normal	ContactsPlugin	normal