Smush and manageWP – Database problems

  • Resolved jerm503

    (@jerm503)


    6 years, 7 months ago

    Hi,

    I’m getting this error when trying to backup with ManageWP. I don’t know if it’s them or you. Other backup/cloning solutions are also failing, but are a little less specific about the error.

    Restore Failed
    2 hours ago

    Failed restoring site https://www.leoketel.com/. error: We got an error during the database import: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'wp_smush_dir_images' already exists; query: CREATE TABLEwp_smush_dir_images(idmediumint(9) NOT NULL AUTO_INCREMENT,pathtext COLLATE utf8mb4_unicode_ci NOT NULL,path_hashchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,resizevarchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,lossyvarchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,errorvarchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,image_sizeint(10) unsigned DEFAULT NULL,orig_sizeint(10) unsigned DEFAULT NULL,file_timeint(10) unsigned DEFAULT NULL,last_scantimestamp NOT NULL DEFAULT '0000-00-00 00:00:00',metatext COLLATE utf8mb4_unicode_ci DEFAULT NULL, UNIQUE KEYid(id), UNIQUE KEYpath_hash(path_hash), KEYimage_size(image_size) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; (file mwp_db/lk_smush_dir_images.sql at 155-966 out of 1024 bytes). If you believe this is a temporary error, you can retry the process.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Anton Vanyukov

    (@vanyukov)

    6 years, 7 months ago

    Hi @jerm503,

    The error is saying that that the wp_smush_dir_images table already exists. If you are trying to import over a live database the import will probably not work. You need to import to an empty database or to a database that does not have the wp_smush_dir_images table.

    Best regards,
    Anton

    Thread Starter jerm503

    (@jerm503)

    6 years, 7 months ago

    Hi Anton!

    Thanks for the quick reply! The first attempt to clone was to a fresh database, and I scrubbed the database on later attempts, but kept getting the same error. I’m not sure this is a Smush problem. That error message is just the most obvious lead I’ve had.

    Anton Vanyukov

    (@vanyukov)

    6 years, 7 months ago

    No, this is not a Smush error. Smush will attempt to re-create this table if it’s removed. So if you’re importing on a live site, it might be a good idea to disable Smush and make sure that the table is not there before you import.

    Best regards,
    Anton

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

The topic ‘Smush and manageWP – Database problems’ is closed to new replies.