Database errors

  • Resolved stijnsupport

    (@stijnsupport)


    4 years, 5 months ago

    I’m getting the following database (Apache) errors.

    AH01071: Got error ‘_wp_e807c.Z0i09X5I8_icwp_wpsf_scanq`’ exists. Please DISCARD the tablespace before IMPORT bij query CREATE TABLE Z0i09X5I8_icwp_wpsf_scanq (\r\n\t\t\tid int(11) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n\t\t\tscan varchar(3) NOT NULL DEFAULT 0 COMMENT ‘Scan Slug’,\r\n\t\t\titems text COMMENT ‘Array of scan items’,\r\n\t\t\tresults text COMMENT ‘Array of results’,\r\n\t\t\tmeta text COMMENT ‘Meta Data’,\r\n\t\t\tstarted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘TS Started’,\r\n\t\t\tfinished_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘TS Finished’,\r\n\t\t\tcreated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘TS Created’,\r\n\t\t\tdeleted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘TS Soft Deleted’,\r\n\t\t\tPRIMARY KEY (id)\r\n\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; gemaakt door require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->d…

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Jelena

    (@jmisic)

    Hi,

    Can you tell us if this is a once-off, or is it repeating error, please?

    Also, it’s worth reinstalling Shield to ensure nothing is broken there.

    Thanks.

    Jelena

    Thread Starter stijnsupport

    (@stijnsupport)

    Hi,

    I’m working with a VPS containing multiple sites. Some have this error, some don’t. All use Shield.

    This error will seemingly spontaneously occur, even after a fresh (re)install. The log rapidly fills with these errors, causing a problem for drive space.

    Plugin Author Paul

    (@paultgoodchild)

    This isn’t an error by the Shield plugin itself, it seems to be an issue with your database.

    Here’s a quick example:
    https://stackoverflow.com/questions/17914446/mysqldump-problems-with-restore-error-please-discard-the-tablespace-before-imp

    Also, Shield doesn’t do an “IMPORT”, so it seems you have something performing an import?

    I honestly don’t know what’s causing it, but it’s not the plugin itself – something funky is going on with your database by the looks of it..

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database errors’ is closed to new replies.