Title: W3 Total Cache database query
Last modified: August 24, 2016

---

# W3 Total Cache database query

 *  [TNELN](https://wordpress.org/support/users/tingaliin/)
 * (@tingaliin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/w3-total-cache-database-query/)
 * 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](http://www.site.com)
 * [https://wordpress.org/plugins/auth0/](https://wordpress.org/plugins/auth0/)

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

 *  Thread Starter [TNELN](https://wordpress.org/support/users/tingaliin/)
 * (@tingaliin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/w3-total-cache-database-query/#post-5999030)
 * 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](https://wordpress.org/support/users/tingaliin/)
 * (@tingaliin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/w3-total-cache-database-query/#post-5999088)
 * database error
 *  Thread Starter [TNELN](https://wordpress.org/support/users/tingaliin/)
 * (@tingaliin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/w3-total-cache-database-query/#post-5999103)
 * 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](https://wordpress.org/support/users/tingaliin/)
 * (@tingaliin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/w3-total-cache-database-query/#post-5999105)
 * 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.

 * ![](https://ps.w.org/auth0/assets/icon-256x256.png?rev=3351758)
 * [Login by Auth0](https://wordpress.org/plugins/auth0/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/auth0/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/auth0/)
 * [Active Topics](https://wordpress.org/support/plugin/auth0/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/auth0/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/auth0/reviews/)

 * 4 replies
 * 1 participant
 * Last reply from: [TNELN](https://wordpress.org/support/users/tingaliin/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/w3-total-cache-database-query/#post-5999105)
 * Status: not resolved