Error on DB

  • Resolved moradpour

    (@moradpour)


    10 years, 11 months ago

    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://www.ads-software.com/plugins/shorten-url/

Viewing 15 replies - 1 through 15 (of 21 total)

  • That is why 1.5.4 has been released … should correct the problem

    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 ?

    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

    (@moradpour)

    this table not exist on DB but when create manual

    Stopped by this error
    #1050 – Table ‘admin_egil.wp_pluginSL_shorturl‘ already exists

    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

    (@moradpour)

    i cant find this table on DB with phpmyadmin

    Errrr … But you said you have created it no ?
    How have you done it ?

    Thread Starter moradpour

    (@moradpour)

    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

    (@moradpour)

    I’ve got six months of use
    No problem
    But when the new version was updated
    It happened…

    please help

    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?”

    For instance what is your version ? Plugin and WP ?

    Thread Starter moradpour

    (@moradpour)

    last version

    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

    My name is sedlex ..,

    Thread Starter moradpour

    (@moradpour)

    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)
  • The topic ‘Error on DB’ is closed to new replies.