Title: creating table error message
Last modified: March 8, 2025

---

# creating table error message

 *  Resolved [wp help](https://wordpress.org/support/users/platinumrealty/)
 * (@platinumrealty)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/creating-table-error-message/)
 * Hello,
 * Get the below error message when trying to create a table:
   **You have an error
   in your SQL syntax; check the manual that corresponds to your MySQL server version
   for the right syntax to use near ‘AUTO_INCREMENT,`PayerType` enum(‘Tenant’, ‘
   Landlord’, ‘Contractor’) NULL DEFAULT’ at line 1**
 * How do i fix it? Thanks
 * (unable to attach a screenshot of table design)

Viewing 1 replies (of 1 total)

 *  Thread Starter [wp help](https://wordpress.org/support/users/platinumrealty/)
 * (@platinumrealty)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/creating-table-error-message/#post-18349446)
 * disregard (unable to delete post)

Viewing 1 replies (of 1 total)

The topic ‘creating table error message’ 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/)

 * 1 reply
 * 1 participant
 * Last reply from: [wp help](https://wordpress.org/support/users/platinumrealty/)
 * Last activity: [1 year, 1 month ago](https://wordpress.org/support/topic/creating-table-error-message/#post-18349446)
 * Status: resolved