I'm having the same error at
http://singe.za.net/, full details below, but the pertinent error seems to be:
/ Unknown column 'orderkey' in 'order clause'
I upgrade from 1.4.1 when I was getting unexplained SQL errors (I had made some changes to packages on my side). I looked through the script in /sql and nothing makes a note of the 'orderkey' column.
Additionally, this is a significant amount of debugging info that reveals more to a potential attacker than I am comfortable with. Is there a way to turn debugging output like this off?
Software versions:
* php5/jaunty-security uptodate 5.2.6.dfsg.1-3ubuntu4.2
* php5-mysql/jaunty-security uptodate 5.2.6.dfsg.1-3ubuntu4.2
* mysql Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using readline 5.2
* serendipity 1.5-beta1
Full error below:
The search function did not work as expected. Notice for the administrator of this blog: This may happen because of missing index keys in your database. On MySQL systems your database user account needs to be privileged to execute this query:
CREATE FULLTEXT INDEX entry_idx on blog_entries (title,body,extended)
The specific error returned by the database was:
SELECT
e.id,
e.authorid,
a.realname AS author,
e.allow_comments,
e.moderate_comments,
a.email,
e.timestamp,
e.comments,
e.title,
e.body,
e.extended,
e.trackbacks,
e.exflag,
e.isdraft,
e.last_modified,
a.username AS loginname
FROM
blog_entries e
LEFT JOIN blog_authors a
ON e.authorid = a.authorid
LEFT JOIN blog_entrycat ec
ON e.id = ec.entryid
LEFT OUTER JOIN blog_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN blog_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN blog_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN blog_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE
(MATCH(title,body,extended) AGAINST('foooo*' IN BOOLEAN MODE))
AND isdraft = 'false' AND timestamp <= 1259155200 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 15
/ Unknown column 'orderkey' in 'order clause'
