DB Error- Directory Table doesn’t exist

  • Resolved gastronimo

    (@gastronimo)


    7 years, 1 month ago

    With Smush Network Activated on my (dev) multiste I keep getting this repeated error on just the main site and 2 subsites of my network, and the error log is really slowing page load times:

    [20-Feb-2018 19:18:53 UTC] WordPress database error Table ‘MYSITE.mydb_20_smush_dir_images’ doesn’t exist for query CREATE TABLE mydb_20_smush_dir_images (id mediumint(9) NOT NULL AUTO_INCREMENT,
    path text NOT NULL,
    resize varchar(55),
    lossy varchar(55),
    error varchar(55) DEFAULT NULL,
    image_size int(10) unsigned,
    orig_size int(10) unsigned,
    file_time int(10) unsigned,
    last_scan timestamp DEFAULT ‘0000-00-00 00:00:00’,
    meta text,
    UNIQUE KEY id (id),
    UNIQUE KEY path (path(191)),
    KEY image_size (image_size)

    Any ideas what might the problem/solution be? I need to launch soon…
    Thanks in advance!

Viewing 16 replies (of 16 total)
  • Thread Starter gastronimo

    (@gastronimo)

    Thanks Umesh…his was more helpful, but I still ran into errors:

    MySQL said: Documentation
    #1005 – Can’t create table ‘mydb_smush_dir_images’ (errno: -1) (Details…)

    Since ghost tables (which are listed, but do not ‘exist’) were already present for each subsite, the only way around this was to create this smush table under a non-existant subsite ‘mydb_0_smush…’. Even then I was unable to copy OR rename ‘0’ table to the main site ‘mydb_smush…'(got same error).

    So, I copied the ‘0’ table to another non-existant subsite ‘mydb_1_smush…’, then I was able to remame ‘1’ to the main site.

    Next, using this procedure https://www.ads-software.com/support/topic/new-install-seeing-error/#post-10719066 , I had to manually delete each ghost table, then recreate the ‘0’ table by copying from one ‘good’ table, then rename it for each subsite. What a pain! Not blaming you though. Just sharing the process.

Viewing 16 replies (of 16 total)
  • The topic ‘DB Error- Directory Table doesn’t exist’ is closed to new replies.