Title: Create table failed
Last modified: March 14, 2021

---

# Create table failed

 *  Resolved [artmuns](https://wordpress.org/support/users/artmuns/)
 * (@artmuns)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/create-table-failed-2/)
 * ERROR: CREATE TABLE failed.
 * Here’s the script.
 * CREATE TABLE `sb_incidents`
    (`incident_id` int(4) NOT NULL AUTO_INCREMENT ,`
   date` date(8) NULL ,`reported_by` text NULL ,`address` text(20) NULL ,`violation`
   text(20) NULL ,`note` text(500) NULL ,PRIMARY KEY (`incident_id`) ) ENGINE InnoDB
   DEFAULT CHARACTER SET latin1 COLLATE=latin1_swedish_ci;

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

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/create-table-failed-2/#post-14178687)
 * Hi Art,
 * The Data Designer allows you to add a max length to any column type, which it
   shouldn’t. Please leave the max length empty for date and text fields. If you
   want to limit the size of a text field, please use column type varchar. Sorry,
   I need to fix this!
 * Does this help?
    Peter
 *  Thread Starter [artmuns](https://wordpress.org/support/users/artmuns/)
 * (@artmuns)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/create-table-failed-2/#post-14179849)
 * That fixed it Peter. Thank you!

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

The topic ‘Create table failed’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [artmuns](https://wordpress.org/support/users/artmuns/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/create-table-failed-2/#post-14179849)
 * Status: resolved