mysql errors--automagically changing preferences?

[carla]

I'm not certain the cuase, but every once in a while (and more frequently now), my wp-options table gets changed, and my blog is then unreachable. This has been occurring across updates, and I cannot pinpoint a wayward plugin as the culprit.
When this happens, the only cure is for me to login to phpmyadmin, and enter: "update wp_options set option_value='​http://www.hauntedpalace.net/library' where option_id=1;"...then all is well for the time being.

The message received instead of my blog at ​http://www.hauntedpalace.net/library is as follows:

"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 'WHERE 1=1 AND post_date_gmt <= '2005-06-28 18:26:59' AND (post_]
SELECT DISTINCT * FROM wp_posts INNER JOIN wp_post2cat ON wp_posts.ID=wp_post2cat.post_id AND category_id= WHERE 1=1 AND post_date_gmt <= '2005-06-28 18:26:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC

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 'WHERE 1=1 AND post_date_gmt <= '2005-06-28 18:26:59' AND (post_]
SELECT DISTINCT * FROM wp_posts INNER JOIN wp_post2cat ON wp_posts.ID=wp_post2cat.post_id AND category_id= WHERE 1=1 AND post_date_gmt <= '2005-06-28 18:26:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5"

[carla]

Update: I've had to run this "repair" four times in a row, since posting this bug. I wish I had more information to offer...:(

[markjaquith]

What is your blog URI changed to in the options table? Is it blank, or does it get changed to something else? If it is changed to something specific, can you look in your access logs for a GET request that might have triggered it?

Please respond... this isn't good!

[markjaquith]

No response on this... I'm just going to attribute it to a user-specific problem. Please reopen if you can provide more info.