W3 Total Cache database query

  • TNELN

    (@tingaliin)


    9 years ago

    I am getting the following database error with W3 Total Cache:

    …
    Table ‘xxx_yyy.xxx_auth0_user‘ already exists
    …
    CREATE TABLE xxx_auth0_user (\n
    auth0_id VARCHAR(100) NOT NULL,\n
    wp_id INT(11) NOT NULL,\n
    auth0_obj TEXT,\n
    PRIMARY KEY (auth0_id)\n
    )
    …
    require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), call_user_func_array, WP_Auth0::check_update, WP_Auth0::install_db, dbDelta, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query, referer: http://www.site.com

    https://wordpress.org/plugins/auth0/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter TNELN

    (@tingaliin)

    9 years ago

    There is no auth0_user table created at all, do I need this part?

    $sql[] = “CREATE TABLE “.$wpdb->auth0_user.” (
    auth0_id VARCHAR(100) NOT NULL,
    wp_id INT(11) NOT NULL,
    auth0_obj TEXT,
    PRIMARY KEY (auth0_id)
    );”;

    Thread Starter TNELN

    (@tingaliin)

    9 years ago

    database error

    Thread Starter TNELN

    (@tingaliin)

    9 years ago

    InnoDB: You can drop the orphaned table inside InnoDB by
    InnoDB: creating an InnoDB table with the same name in another
    InnoDB: database and copying the .frm file to the current database.
    InnoDB: Then MySQL thinks the table exists, and DROP TABLE will
    InnoDB: succeed.

    Thread Starter TNELN

    (@tingaliin)

    9 years ago

    will watch the error log for a couple days to see if the problem persists

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘W3 Total Cache database query’ is closed to new replies.