Title: Duplicator CREATE TABLE Deployment Errors – 'Invalid default value'
Last modified: August 31, 2016

---

# Duplicator CREATE TABLE Deployment Errors – 'Invalid default value'

 *  Resolved [joeflack4](https://wordpress.org/support/users/joeflack4/)
 * (@joeflack4)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/duplicator-create-table-deployment-errors-invalid-default-value/)
 * **Full log here**: [http://www.joeflack.net/static/installer-log.txt](http://www.joeflack.net/static/installer-log.txt)
 * I have followed several Duplicator tutorials, but there is not very much variance
   between them. No matter what I do, I am getting the same ~650 deployment errors.
 * **Example Error Text**
 *     ```
       **ERROR** database error write 'Invalid default value for 'comment_date'' - [sql=
       CREATE TABLE <code>wp_mlfc_comments</code> (
         <code>comment_ID</code> bigint(20) unsigned NOT N...]
       ```
   
 * I am guessing that the `NOT N...]` is simply truncated for `NOT NULL` and whatever
   might come after it, and not the result of a botched SQL statement.
 * I’m pretty sure this is the source of my errors, so I’ll leave it there.

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

 *  Thread Starter [joeflack4](https://wordpress.org/support/users/joeflack4/)
 * (@joeflack4)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/duplicator-create-table-deployment-errors-invalid-default-value/#post-7427564)
 * Gets me every time. After countless hours (in this case slept overnight) of troubleshooting,
   I find the answer as soon as I pot about it: [http://lifeinthegrid.com/support/knowledgebase.php?article=12#faq-trouble](http://lifeinthegrid.com/support/knowledgebase.php?article=12#faq-trouble)
 *  [SeanBennett](https://wordpress.org/support/users/seanbennett/)
 * (@seanbennett)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/duplicator-create-table-deployment-errors-invalid-default-value/#post-7427886)
 * Which of the solutions on that page resolved this for you? I’m running into the
   same issue and have had no luck.
 *  Thread Starter [joeflack4](https://wordpress.org/support/users/joeflack4/)
 * (@joeflack4)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/duplicator-create-table-deployment-errors-invalid-default-value/#post-7427887)
 * It looks like my hash link doesnt work anymore.
 * Go down to this question:
    I’m having Database issues what should I do?
 * I had to change the my.ini file as instructed. Seemed to be a mysql version issue.

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

The topic ‘Duplicator CREATE TABLE Deployment Errors – 'Invalid default value'’ 
is closed to new replies.

## Tags

 * [table doesn't exist](https://wordpress.org/support/topic-tag/table-doesnt-exist/)

 * 3 replies
 * 2 participants
 * Last reply from: [joeflack4](https://wordpress.org/support/users/joeflack4/)
 * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/duplicator-create-table-deployment-errors-invalid-default-value/#post-7427887)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics