Forums

[resolved] WordPress database error: [...] (13 posts)

  1. Charmax
    Member
    Posted 4 years ago #

    I have been running wordpress for some months now, I upgraded to 1.5 and everything was fine, I upgraded to 1.5.1 and it has been working great up until about 2 weeks ago. At first I was starting to get 505 errors, this was happening only occasionally, it was fine when I refreshed the page. I wasn't too concerned about this I just thought it was some issue with my server that would resolve it's self. Then today (about 6 hours ago) I was able to add a new post (this went fine until I came to try and edit) I was trying to delete an entry but it just wouldn't go.

    Now after coming back to update my site I get this error -
    http://bronze-ambition.net/siteerror.jpg

    I do not know if this is all server problems or is it something to do with wordpress? Is my database to full?

    I am not a "techy" so I have no idea. This is all new to me.

    At the top of the page it says -

    [backticks]

    WordPress database error: [�� ]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND 0=1 AND post_date_gmt <= '2005-09-01 19:48:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 20

    WordPress database error: [�� ]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-09-01 19:48:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY not (ID in (294)), post_date DESC LIMIT 0, 20

    WordPress database error: [�� ]
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < '2005-09-01 19:48:54' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC[backticks/]

    And on the sidebar it says -

    [backticks]

    WordPress database error: [�� ]
    SELECT cat_ID, cat_name, category_nicename, category_description, COUNT(wp_post2cat.post_id) AS cat_count FROM wp_categories INNER JOIN wp_post2cat ON (cat_ID = category_id) INNER JOIN wp_posts ON (ID = post_id) WHERE post_status = 'publish' AND post_date_gmt < '2005-09-01 19:48:54' GROUP BY category_id
    * No categories

    WordPress database error: [�� ]
    SELECT ID, post_title, post_name, post_parent ,UNIX_TIMESTAMP(post_modified) AS time_modified,UNIX_TIMESTAMP(post_date) AS time_created FROM wp_posts WHERE post_status = 'static' ORDER BY post_title ASC[/backticks]

    Does anyone know what the problem is?
    Many thanks in advance.

  2. jennmiller
    Member
    Posted 4 years ago #

    Hey there, I know you. Do you have any newish plugins you've added? It could be a conflict between them. I'm no techie either, but I hope you get it working ;)

    Does this mean it's working now?

  3. Charmax
    Member
    Posted 4 years ago #

    No I don't think it's anything to do with that... The last plugin I installed was Bad Behaviour, that was fine for a few days. Would it suddenly cause problems?

  4. Charmax
    Member
    Posted 4 years ago #

    No the problem is still there..

  5. jennmiller
    Member
    Posted 4 years ago #

    I use it, so I don't think it's the cause. Hmmm.

  6. Charmax
    Member
    Posted 4 years ago #

    It is odd. I thought I would ask here first before I went off to ask my hosts.

  7. Charmax
    Member
    Posted 4 years ago #

    I am now getting 500 errors on top...

  8. gorgonzola
    Member
    Posted 4 years ago #

    500 errors are probably either your host's fault or due to a badly configured .htaccess file.

  9. Charmax
    Member
    Posted 4 years ago #

    My server doesn't allow any hostee's to configure their .htaccess file. So can this whole mess be their issue?

  10. gorgonzola
    Member
    Posted 4 years ago #

    Only way to find out is to ask them :). Let us know what they say (either way).

  11. Charmax
    Member
    Posted 4 years ago #

    I would really like to know if the "wordpress database error" is a problem with wordpress before I go down the route of contacting them. If it's wordpress, then it's not their problem.

  12. jennmiller
    Member
    Posted 4 years ago #

    By there being no error number (the ??s), it seems it could very well be a serverside thing. I would guess that they'll need to at least tell you what the problem is, WordPress or not. As said, let us know what happens.

  13. Charmax
    Member
    Posted 4 years ago #

    I have sorted out the problem now - one of the tables had "crashed". Thanks for trying to help.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.