Title: "Failed to Create Table" error
Last modified: August 31, 2016

---

# "Failed to Create Table" error

 *  Resolved [cerridwenlakshmi](https://wordpress.org/support/users/cerridwenlakshmi/)
 * (@cerridwenlakshmi)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/failed-to-create-table-error/)
 * Based on your response to the other person with this error, below is the code:
 * CREATE TABLE `wp_ha65rf_PIN` (
    `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT
   COMMENT ‘ID’, `DOB` date NOT NULL, `TOB` time NOT NULL, `Planet` enum(”Sun”,”
   Moon”,”Mars”,”Venus”,”Jupiter”,”Saturn”,”Uranus”,”Neptune”,”Pluto”) NOT NULL,`
   Sign` enum(”Aries”,”Taurus”,”Gemini”,”Cancer”,”Leo”,”Virgo”,”Libra”,”Scorpio”,”
   Sagittarius”,”Capricorn”,”Aquarius”,”Pisces”) NOT NULL, `House` enum(”First”,”
   Second”,”Third”,”Fourth”,”Fifth”,”Sixth”,”Seventh”,”Eighth”,”Ninth”,”Tenth”,”
   Eleventh”,”Twelfth”) NOT NULL, `Aspect` enum(”Conjunction”,”Opposition”,”Sextile”,”
   Semi-Sextile”,”Square”,”Semi-Square”,”Trine”,”Quincunx”,”Sesqui-Square”,”Quintile”,”
   Bi-Quintile”,”Parallel”,”Contra Parallel”) NOT NULL, `NP` enum(”Sun”,”Moon”,”
   Mars”,”Venus”,”Jupiter”,”Saturn”,”Uranus”,”Neptune”,”Pluto”) NOT NULL, `NS` enum(”
   Aries”,”Taurus”,”Gemini”,”Cancer”,”Leo”,”Virgo”,”Libra”,”Scorpio”,”Sagittarius”,”
   Capricorn”,”Aquarius”,”Pisces”) NOT NULL, `NH` enum(”First”,”Second”,”Third”,”
   Fourth”,”Fifth”,”Sixth”,”Seventh”,”Eighth”,”Ninth”,”Tenth”,”Eleventh”,”Twelfth”)
   NOT NULL, `OtherAs` enum(‘Yes’,’No’) NOT NULL, `Event` varchar(3000) NOT NULL,`
   created` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘Created Datetime’,`
   updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
   COMMENT ‘Updated Datetime’, PRIMARY KEY(`ID`) ) ENGINE=InnoDB DEFAULT CHARSET
   =utf8 COMMENT=’Planets in Transit’ AUTO_INCREMENT=1;
 * Thanks!
 * [https://wordpress.org/plugins/custom-database-tables/](https://wordpress.org/plugins/custom-database-tables/)

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

 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/failed-to-create-table-error/#post-7232880)
 * Thank you very much for reporting.
 * If there are capital letters in the table name, it will fail to table creation.
 * This plugin is developed in accordance with the MySQL setting (my.cnf) of “lower_case_table_names
   = 1”.
 * Thank you,
 *  Thread Starter [cerridwenlakshmi](https://wordpress.org/support/users/cerridwenlakshmi/)
 * (@cerridwenlakshmi)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/failed-to-create-table-error/#post-7232899)
 * I changed the table name to “pintable”, not the quotes of course. Gives same 
   error. I changed the columns name to all lower case just as a test. Still same
   error.
 * Thanks.
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/failed-to-create-table-error/#post-7232917)
 * Hi,
 * At the values of enum type, it should use single quote.
    I was able to successfully
   created table in the following SQL.
 *     ```
       CREATE TABLE wp_ha65rf_pin (
         ID bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
         DOB date NOT NULL,
         TOB time NOT NULL,
         Planet enum('Sun','Moon','Mars','Venus','Jupiter','Saturn','Uranus','Neptune','Pluto') NOT NULL,
         Sign enum('Aries','Taurus','Gemini','Cancer','Leo','Virgo','Libra','Scorpio','Sagittarius','Capricorn','Aquarius','Pisces') NOT NULL,
         House enum('First','Second','Third','Fourth','Fifth','Sixth','Seventh','Eighth','Ninth','Tenth','Eleventh','Twelfth') NOT NULL,
         Aspect enum('Conjunction','Opposition','Sextile','Semi-Sextile','Square','Semi-Square','Trine','Quincunx','Sesqui-Square','Quintile','Bi-Quintile','Parallel','Contra Parallel') NOT NULL,
         NP enum('Sun','Moon','Mars','Venus','Jupiter','Saturn','Uranus','Neptune','Pluto') NOT NULL,
         NS enum('Aries','Taurus','Gemini','Cancer','Leo','Virgo','Libra','Scorpio','Sagittarius','Capricorn','Aquarius','Pisces') NOT NULL,
         NH enum('First','Second','Third','Fourth','Fifth','Sixth','Seventh','Eighth','Ninth','Tenth','Eleventh','Twelfth') NOT NULL,
         OtherAs enum('Yes','No') NOT NULL,
         Event varchar(3000) NOT NULL,
         created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Created Datetime',
         updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated Datetime',
         PRIMARY KEY (ID)
       ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Planets in Transit'
       ```
   
 * Thank you,
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [10 years ago](https://wordpress.org/support/topic/failed-to-create-table-error/#post-7233005)
 * This ticket was closed to have corresponded already.

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

The topic ‘"Failed to Create Table" error’ 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/)

## Tags

 * [creator](https://wordpress.org/support/topic-tag/creator/)
 * [table](https://wordpress.org/support/topic-tag/table/)

 * 4 replies
 * 2 participants
 * Last reply from: [ka2](https://wordpress.org/support/users/ka2/)
 * Last activity: [10 years ago](https://wordpress.org/support/topic/failed-to-create-table-error/#post-7233005)
 * Status: resolved