Title: Error in SQL Statements
Last modified: August 20, 2016

---

# Error in SQL Statements

 *  [rmullins9](https://wordpress.org/support/users/rmullins9/)
 * (@rmullins9)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/error-in-sql-statements/)
 * Hi,
 * This is more FYI than a request for support, as I’ve resolved my own issue.
 * In the latest release of ndizi 0.9.7.0, the SQL statements to create the necessary
   tables have error that cause the tables to not be installed (at least with MySQL
   version 5.1.57).
 * This issue will cause you to not be able to enter any clients, projects, etc 
   after activating the plugin.
 * The problem is that the ‘description’ fields in each table are being create as
   a TEXT type with a DEFAULT value.
 * According to MySQL, that is a no-no.
 * You can fix this problem by opening Ndizi.class.php in notepad and deleting “
   DEFAULT ”” from each statement that’s creating a table.
 * [http://wordpress.org/extend/plugins/ndizi-project-management/](http://wordpress.org/extend/plugins/ndizi-project-management/)

The topic ‘Error in SQL Statements’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/ndizi-project-management.svg)
 * [Ndizi Project Management](https://wordpress.org/plugins/ndizi-project-management/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ndizi-project-management/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ndizi-project-management/)
 * [Active Topics](https://wordpress.org/support/plugin/ndizi-project-management/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ndizi-project-management/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ndizi-project-management/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [rmullins9](https://wordpress.org/support/users/rmullins9/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/error-in-sql-statements/)
 * Status: not resolved