WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Database Error (10 posts)

  1. Joey Michaels
    Member
    Posted 5 years ago #

    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?

  2. Samuel B
    moderator
    Posted 5 years ago #

    Your database tables need repairing or rebuilding. If you are not capable - ask your host to do it for you.

  3. jakobe75
    Member
    Posted 5 years ago #

    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

  4. moshu
    Member
    Posted 5 years ago #

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

  5. sleeping
    Member
    Posted 5 years ago #

    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

  6. sleeping
    Member
    Posted 5 years ago #

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

    how? Help

  7. thisisedie
    Member
    Posted 5 years ago #

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

  8. sleeping
    Member
    Posted 5 years ago #

    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

  9. qbano
    Member
    Posted 5 years ago #

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

  10. mijk
    Member
    Posted 5 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic