Title: WordPress Database Error
Last modified: August 19, 2016

---

# WordPress Database Error

 *  [joey-michaels](https://wordpress.org/support/users/joey-michaels/)
 * (@joey-michaels)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/)
 * 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)

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848114)
 * Your database tables need repairing or rebuilding. If you are not capable – ask
   your host to do it for you.
 *  [jakobe75](https://wordpress.org/support/users/jakobe75/)
 * (@jakobe75)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848371)
 * 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
 *  [moshu](https://wordpress.org/support/users/moshu/)
 * (@moshu)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848372)
 * You may need the help of your host – as it was advised above.
 *  [sleeping](https://wordpress.org/support/users/sleeping/)
 * (@sleeping)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848373)
 * 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
 *  [sleeping](https://wordpress.org/support/users/sleeping/)
 * (@sleeping)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848374)
 * notes:
    I still can not install wordpress because it is not possible to access
   wp-admin/install.php
 * how? Help
 *  [thisisedie](https://wordpress.org/support/users/thisisedie/)
 * (@thisisedie)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848376)
 * What do you mean it isn’t possible to access wp-admin/intall.php? What happens
   when you try?
 *  [sleeping](https://wordpress.org/support/users/sleeping/)
 * (@sleeping)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848377)
 * 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
 *  [qbano](https://wordpress.org/support/users/qbano/)
 * (@qbano)
 * [16 years, 12 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848524)
 * 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](https://www.yourdomain/phpMyAdmin/index.php)
 * Go to Databases
 * [https://www.yourdomain/phpMyAdmin/server_databases.php](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…
 *  [mijk](https://wordpress.org/support/users/mijk/)
 * (@mijk)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848528)
 * 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.

## Tags

 * [installation](https://wordpress.org/support/topic-tag/installation/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 9 replies
 * 8 participants
 * Last reply from: [mijk](https://wordpress.org/support/users/mijk/)
 * Last activity: [16 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-30/#post-848528)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
