Title: Failed to Create Table
Last modified: August 30, 2016

---

# Failed to Create Table

 *  [DevilWoIf](https://wordpress.org/support/users/devilwoif/)
 * (@devilwoif)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/failed-to-create-table-1/)
 * I keep trying to create my table but I keep getting “Failed to Create Table”…
   even though everything is correct that is generated by the generator?
 * [https://wordpress.org/plugins/custom-database-tables/](https://wordpress.org/plugins/custom-database-tables/)

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

 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/failed-to-create-table-1/#post-6250138)
 * Sorry for my late reply.
 * Sorry to trouble you, please tell me the full statements of SQL which is displayed
   in a modal dialog for confirmation of when you will be creating a table.
 * Thank you,
 *  [ajmirg](https://wordpress.org/support/users/ajmirg/)
 * (@ajmirg)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/failed-to-create-table-1/#post-6250286)
 * Hello Ka2,
 * I’ve also encountered the same error and here is the info in my case:
 * CREATE TABLE `wp_activities` (
    `ID` int(11) unsigned NOT NULL AUTO_INCREMENT
   COMMENT ‘ID’, `activity_type` varchar() , `activity_order` int(11) , `activity_link`
   varchar() , `activity_done` bool , `done_date` date , `created` datetime NOT 
   NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘Created Date’, `updated` timestamp
   NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘Updated
   Date’, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=” ;
 * Thanks,
    Ajmir
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/failed-to-create-table-1/#post-6250287)
 * Thank you for your inquiry.
 * By column definition, the varchar type of column need the length of the string.
   So, varchar() instead, please put the number of the string length, such as varchar(
   255). Then, you are able to be table creation.
 * Please try it.

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

The topic ‘Failed to Create Table’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-database-tables_e4e2e2.svg)
 * [Custom DataBase Tables](https://wordpress.org/plugins/custom-database-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-database-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-database-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-database-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-database-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-database-tables/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [ka2](https://wordpress.org/support/users/ka2/)
 * Last activity: [10 years, 9 months ago](https://wordpress.org/support/topic/failed-to-create-table-1/#post-6250287)
 * Status: not resolved