Title: WordPress database error
Last modified: August 21, 2016

---

# WordPress database error

 *  Resolved [homonk](https://wordpress.org/support/users/homonk/)
 * (@homonk)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/)
 * Hi,
 * I am getting this error when I try to access the wp-admin login page:
 *     ```
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       SHOW COLUMNS FROM wp_pluginSL_shorturl LIKE 'url_externe'
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       ALTER TABLE wp_pluginSL_shorturl ADD url_externe VARCHAR( 255 ) NOT NULL DEFAULT '';
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       ALTER TABLE wp_pluginSL_shorturl DROP INDEX id_post;
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       ALTER TABLE wp_pluginSL_shorturl ADD CONSTRAINT id_post UNIQUE (id_post,url_externe)
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       SHOW COLUMNS FROM wp_pluginSL_shorturl LIKE 'nb_hits'
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       ALTER TABLE wp_pluginSL_shorturl ADD nb_hits mediumint(9);
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       SHOW COLUMNS FROM wp_pluginSL_shorturl LIKE 'comment'
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       ALTER TABLE wp_pluginSL_shorturl ADD comment TEXT;
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       SHOW INDEX FROM wp_pluginSL_shorturl WHERE key_name='id_post'
   
       WordPress database error: [Table 'cityarts_wordpress.wp_pluginSL_shorturl' doesn't exist]
       ALTER TABLE wp_pluginSL_shorturl MODIFY url_externe TEXT ;
   
       Warning: Cannot modify header information - headers already sent by (output started at /home/cityarts/public_html/wp-includes/wp-db.php:1220) in /home/cityarts/public_html/wp-includes/pluggable.php on line 1121
       ```
   
 * Please help, I can’t even login and deactivate the plugin.
 * [https://wordpress.org/plugins/shorten-url/](https://wordpress.org/plugins/shorten-url/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929417)
 * Does this database exist ?
 * In the meanwhile, you may rename the shorten-url.php file into shorten-url.php.
   bak through FTP to deactivate the plugin
 *  Thread Starter [homonk](https://wordpress.org/support/users/homonk/)
 * (@homonk)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929425)
 * I’ve looked at phpmyadmin and can’t see the table.
 * What would have deleted it?
 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929430)
 * I have definitely no idea … the best way is to deactivate the plugin the way 
   I explain to you and then after checking that your are able to login, reinstall
   it
 *  Thread Starter [homonk](https://wordpress.org/support/users/homonk/)
 * (@homonk)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929437)
 * Thanks – I assume their is no easy way of restoring the previous links
 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929439)
 * Errr … indeed if the database have disappear, I have no idea how to restore the
   database … you didn’t export/save the database ?
 * Please note that there is an option in the plugin
 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929442)
 * The only way to delete a database is to uninstall the plugin … the method `uninstall_removedata`
   of the plugin will be called
 * No other drop table exists in the plugin …
 * Just to be sure You do not have a table like wp_shorturl or something like that?
 *  Thread Starter [homonk](https://wordpress.org/support/users/homonk/)
 * (@homonk)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929449)
 * No, nothing like that – never mind. Thanks for your help.
 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929458)
 * Sorry 🙁

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘WordPress database error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/shorten-url_ffffff.svg)
 * [Short URL](https://wordpress.org/plugins/shorten-url/)
 * [Support Threads](https://wordpress.org/support/plugin/shorten-url/)
 * [Active Topics](https://wordpress.org/support/plugin/shorten-url/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/shorten-url/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/shorten-url/reviews/)

## Tags

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

 * 8 replies
 * 2 participants
 * Last reply from: [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-84/#post-4929458)
 * Status: resolved