WordPress.org

Make WordPress Core

Opened 10 years ago

Closed 10 years ago

#1475 closed defect (bug) (worksforme)

mysql errors--automagically changing preferences?

Reported by: carla Owned by: markjaquith
Milestone: Priority: normal
Severity: blocker Version: 1.5.1.2
Component: Security Keywords: MySQL unreachable options error
Focuses: Cc:

Description

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"

Change History (3)

comment:1 @carla10 years ago

  • Severity changed from major to blocker

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...:(

comment:2 @markjaquith10 years ago

  • Component changed from General to Security
  • Keywords bg|dev-feedback added
  • Owner changed from anonymous to markjaquith
  • Priority changed from normal to highest
  • Status changed from new to assigned

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!

comment:3 @markjaquith10 years ago

  • Keywords bg|dev-feedback removed
  • Priority changed from highest to normal
  • Resolution set to worksforme
  • Status changed from assigned to closed

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

Note: See TracTickets for help on using tickets.