Title: Error when creating temporary table
Last modified: August 30, 2016

---

# Error when creating temporary table

 *  Resolved [SimonGiddings](https://wordpress.org/support/users/simongiddings/)
 * (@simongiddings)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/error-when-creating-temporary-table/)
 * MySql version – 5.5.30
    MySql client version – 5.0.45 PHP version – 5.2.5 OS :
   Windows XP
 * I am developing a shop site using WooCommerce.
    During its initialisation, WooCommerce
   adds extra tables to the database. Here is an example of the table name causing
   problems : prefix_woocommerce_downloadable_product_permissions It has 51 characters.
   When the plugin generates the temporary table name, it gives this : 1444147631184_prefix_woocommerce_downloadable_product_permissions
   It has 65 characters. The temporary table creation fails as the name exceeds 
   the 64 character limit.
 * Note that the log entry is misleading, here are two lines for information :
    [
   Tuesday 6th October 2015 : 06:10:49pm] Creating table prefix_woocommerce_downloadable_product_permissions
   has been failed. [Tuesday 6th October 2015 : 06:10:51pm] Table 1444147631184_prefix_woocommerce_downloadable_product_permissions
   has been created, BUT inserting rows failed. This happens sometimes when a table
   had been updated during staging process. Exclude this table from copying and 
   try again. Offset: 0
 * This is not a major problem for me as the table is empty, but it blocks the staging
   process.
 * [https://wordpress.org/plugins/wp-staging/](https://wordpress.org/plugins/wp-staging/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Rene Hermenau](https://wordpress.org/support/users/renehermi/)
 * (@renehermi)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/error-when-creating-temporary-table/#post-6622109)
 * This is a very good catch! I try to catch the max. table name length limit so
   that the error notice will be more clear in the future
 * In the meantime, please use a short staging name to prevent this e.g. dev than
   the name converts to: dev_prefix_woocommerce_downloadable_product_permissions
   which iws withing that character limit.

Viewing 1 replies (of 1 total)

The topic ‘Error when creating temporary table’ is closed to new replies.

 * ![](https://ps.w.org/wp-staging/assets/icon-256x256.png?rev=2972932)
 * [WP STAGING - WordPress Backup, Restore & Migration](https://wordpress.org/plugins/wp-staging/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-staging/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-staging/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-staging/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-staging/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-staging/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Rene Hermenau](https://wordpress.org/support/users/renehermi/)
 * Last activity: [10 years, 7 months ago](https://wordpress.org/support/topic/error-when-creating-temporary-table/#post-6622109)
 * Status: resolved