Title: Error on DB Last modified: August 21, 2016 --- # Error on DB * Resolved [moradpour](https://wordpress.org/support/users/moradpour/) * (@moradpour) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/) * this erorr when up to 1.5.2 * ``` WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] SHOW COLUMNS FROM wp_pluginSL_shorturl LIKE 'url_externe' WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] ALTER TABLE wp_pluginSL_shorturl ADD url_externe VARCHAR( 255 ) NOT NULL DEFAULT ''; WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] ALTER TABLE wp_pluginSL_shorturl DROP INDEX id_post; WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] ALTER TABLE wp_pluginSL_shorturl ADD CONSTRAINT id_post UNIQUE (id_post,url_externe) WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] SHOW COLUMNS FROM wp_pluginSL_shorturl LIKE 'nb_hits' WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] ALTER TABLE wp_pluginSL_shorturl ADD nb_hits mediumint(9); WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] SHOW COLUMNS FROM wp_pluginSL_shorturl LIKE 'comment' WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] ALTER TABLE wp_pluginSL_shorturl ADD comment TEXT; 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 'where key_name='id_post'' at line 1] SHOW INDEX FROM wp_pluginSL_shorturl WHERE where key_name='id_post' WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] ALTER TABLE wp_pluginSL_shorturl DROP INDEX id_post; WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] ALTER TABLE wp_pluginSL_shorturl MODIFY url_externe TEXT ; WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] SELECT short_url FROM wp_pluginSL_shorturl WHERE id_post=394 WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] SELECT id_post FROM wp_pluginSL_shorturl WHERE short_url='kwQo4' WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] DELETE FROM wp_pluginSL_shorturl WHERE id_post=394 WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] INSERT INTO wp_pluginSL_shorturl (id_post, short_url) VALUES ('394', 'kwQo4') WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] SELECT short_url FROM wp_pluginSL_shorturl WHERE id_post=394 WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] SELECT id_post FROM wp_pluginSL_shorturl WHERE short_url='WYQ7z' WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] DELETE FROM wp_pluginSL_shorturl WHERE id_post=394 WordPress database error: [Table 'admin_egil.wp_pluginSL_shorturl' doesn't exist] INSERT INTO wp_pluginSL_shorturl (id_post, short_url) VALUES ('394', 'WYQ7z ``` * [https://wordpress.org/plugins/shorten-url/](https://wordpress.org/plugins/shorten-url/) Viewing 15 replies - 1 through 15 (of 21 total) 1 [2](https://wordpress.org/support/topic/help-error-on-db/page/2/?output_format=md) [→](https://wordpress.org/support/topic/help-error-on-db/page/2/?output_format=md) * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793620) * That is why 1.5.4 has been released … should correct the problem * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793622) * Very strange that you were able to update your plugin in 1.5.2 : this version was online only during 10 minutes sunday … When did you update ? * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793651) * hum … after a more careful reading of the error, it appears that the SQL table does not exists … not normal : could you deactivate and reactivate the plugin? * Thread Starter [moradpour](https://wordpress.org/support/users/moradpour/) * (@moradpour) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793762) * this table not exist on DB but when create manual * Stopped by this error #1050 – Table ‘`admin_egil`.`wp_pluginSL_shorturl`‘ already exists * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793779) * It was not the point in creating the table manually ! Delete it … Update the plugin to version 1.5.4,Deactivate and reactivate the plugin * Thread Starter [moradpour](https://wordpress.org/support/users/moradpour/) * (@moradpour) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793789) * i cant find this table on DB with phpmyadmin * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793790) * Errrr … But you said you have created it no ? How have you done it ? * Thread Starter [moradpour](https://wordpress.org/support/users/moradpour/) * (@moradpour) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793792) * The table does not exist But When you want to create Stops with error : “#1050– Table ‘admin_egil.wp_pluginSL_shorturl’ already exists” * Thread Starter [moradpour](https://wordpress.org/support/users/moradpour/) * (@moradpour) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793793) * I’ve got six months of use No problem But when the new version was updated It happened… * please help * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793794) * Could you be more detailed ??! How do you try to create it ? Do you have some screenshot … Actually your explanation is as useful as you would say “does not work, any advice?” * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793795) * For instance what is your version ? Plugin and WP ? * Thread Starter [moradpour](https://wordpress.org/support/users/moradpour/) * (@moradpour) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793808) * last version * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793809) * Ok let do another way … Could you send me an email (my name @ my name .fr) with a login (WP, phpmyadmin and FTP) to see by myself as obviously we would not solve your issue on this forum * [Sed Lex](https://wordpress.org/support/users/sedlex/) * (@sedlex) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793810) * My name is sedlex .., * Thread Starter [moradpour](https://wordpress.org/support/users/moradpour/) * (@moradpour) * [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/#post-4793818) * fix it * Table “wp_pluginSL_shorturl” was hiding in a database So I was forced I change the name of the file shorten-url.php “wp_pluginSL_shorturl” to “wp_pluginsl_shorturl” * But the table with all data (2000 records) were unavailable All of them can be rearranged * thank you dear Sen Lex 🙂 Viewing 15 replies - 1 through 15 (of 21 total) 1 [2](https://wordpress.org/support/topic/help-error-on-db/page/2/?output_format=md) [→](https://wordpress.org/support/topic/help-error-on-db/page/2/?output_format=md) The topic ‘Error on DB’ 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/) * 21 replies * 2 participants * Last reply from: [moradpour](https://wordpress.org/support/users/moradpour/) * Last activity: [12 years, 1 month ago](https://wordpress.org/support/topic/help-error-on-db/page/2/#post-4793843) * Status: resolved