WordPress.org

Support

Support » Installation » WordPress Database Error

WordPress Database Error

  • I tried to visit my blog today and, instead, received an installation screen. When I entered my email and site name, I received the lengthy string of error messages below.

    To the best of my knowledge, I have not downloaded the most recent version of Word Press. Indeed, I have steadfastly ignored the message to do so for about a month.

    Anyhow, rather than quoting the entire wall of text (because its enormous), here is a sample:

    WordPress database error: [Table ‘wp_options’ is marked as crashed and should be repaired]
    DESCRIBE wp_options;

    WordPress database error: [Table ‘wp_options’ is marked as crashed and should be repaired]
    SHOW INDEX FROM wp_options;

    WordPress database error: [Table ‘wp_options’ is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN option_id bigint(20) NOT NULL auto_increment

    WordPress database error: [Table ‘wp_options’ is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN blog_id int(11) NOT NULL default ‘0’

    WordPress database error: [Table ‘wp_options’ is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN option_name varchar(64) NOT NULL default ”

    WordPress database error: [Table ‘wp_options’ is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN option_value longtext NOT NULL

    WordPress database error: [Table ‘wp_options’ is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN autoload varchar(20) NOT NULL default ‘yes’

    Help?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Your database tables need repairing or rebuilding. If you are not capable – ask your host to do it for you.

    My comment db is crashed and says it needs to be repaired..how do I go about doing this
    phpadmin just lists the same error

    suggestions on how to repair the db, I dont care about the comments I just want the site to function

    You may need the help of your host – as it was advised above.

    Yesterday I had the same problem

    then delete all wordpress and now installed again, but , currently does not appear the error message. What is this?

    Help

    notes:
    I still can not install wordpress because it is not possible to access wp-admin/install.php

    how? Help

    What do you mean it isn’t possible to access wp-admin/intall.php? What happens when you try?

    this message appears:

    Erro de banco de dados do WordPress Table ‘anipa.wp_options’ doesn’t exist para a consulta INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1220975752;a:1:{s:17:\”wp_update_plugins\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) feita por add_option Erro de banco de dados do WordPress Table ‘anipa.wp_options’ doesn’t exist para a consulta INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘random_seed’, ‘3edd2bc9c9fce44d0a79ad2b8b78563f’, ‘yes’) feita por add_option Erro de banco de dados do WordPress Table ‘anipa.wp_options’ doesn’t exist para a consulta INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘auth_salt’, ‘GvzoD0508kFt’, ‘yes’) feita por add_option PHP Fatal error: Class ‘WP_Styles’ not found in E:\home\anipa\web\testes\wp-includes\general-template.php on line 1173

    banco de dados=database

    Ok I just had the same problem. Here they are just sending you to your host. But in case that you own your own servers it is hard to call your host cause you are the host. If this is your case here is how i fixed it:

    Log in to your phpMyAdmin:

    https://www.yourdomain/phpMyAdmin/index.php

    Go to Databases

    https://www.yourdomain/phpMyAdmin/server_databases.php

    Click on your data base

    Check all

    At the bottom right drop down click on repair database

    And that is it….

    Good luck…

    Hi,
    after updating my friends blog to WP to 2.8 I have got this error in php log, and part of theme, which is showing category excerpts isn’t showing first posts from each category. On 2.7.1 everything works well. Can someone help me?

    Theme doesn’t contain any direct MySQL requests, did some template tags changed since 2.8? It has something to do with taxonomies, doesn’t it?

    Could anybody help me fix it? I dunno what’s wrong, every line of code seems to be OK, but part of theme doesn’t work.

    I tried classic solution: disabling all plugins, nothing happened, error persisted.

    When I switch to default template, everything works OK, but that is not solution, I need to figure out and fix the trouble.

    Error:
    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 ASC' at line 1 for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY order ASC made by require, require_once, include, get_categories, get_terms

    Thanks

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘WordPress Database Error’ is closed to new replies.
Skip to toolbar