Just discovered this error message

Does anyone know how I can fix this? This error shows up when someone tries to access a deleted post:

WordPress database error: [You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near ‘ORDER BY post_date ASC LIMIT 1’ at line 1]
SELECT ID,post_title FROM wp_posts WHERE post_date > ” AND post_date
< ‘2006-05-10 09:29:42’ AND post_status = ‘publish’ AND ID != ORDER BY
post_date ASC LIMIT 1

Sorry, no posts matched your criteria.

———————————————-

The problem is further complicated by the fact that when I copied the theme to my test area to troubleshoot the error, I couldn’t get it to repeat. What I received on my test site was a 404 error, which is what it should have been all along.

My live site and my test site are using the same database; which I do NOT have access to. My site is on a friend’s server and he says this is a WP error, not a database error, so I have to fix it myself.

If you need to see this in action on both my sites:

http://www.jaynedarcy.us/?p=263 – this is a deleted post on my live site and shows the error message.

http://www.jaynedarcy.us/sites/test/archives/16 – this is a deleted post on my test site that shows the 404 error.