Title: Export / Import Bug?
Last modified: August 21, 2016

---

# Export / Import Bug?

 *  [mrbooie](https://wordpress.org/support/users/mrbooie/)
 * (@mrbooie)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/export-import-3/)
 * It seems there may be a bug in the export / import feature. With debug = true
   set, I’m getting a series of mysql insert errors. Seems like the same problem
   is happening with all of them.
 * `INSERT INTO`blog_ninja_forms`(`id`,`data`,`date_updated`) VALUES (”,’….’, ‘2014-
   04-09 15:37:38’)
    `
 * Essentially what’s happening is an empty string is being passed in for id. With
   id set to auto increment, the latest version of mysql doesn’t seem to like this.
   I think more than likely null is the value that should be passed here so the 
   auto increment works. I tested this and the statement executes correctly when
   you make this change.
 * [https://wordpress.org/plugins/ninja-forms/](https://wordpress.org/plugins/ninja-forms/)

The topic ‘Export / Import Bug?’ is closed to new replies.

 * ![](https://ps.w.org/ninja-forms/assets/icon-256x256.png?rev=1649747)
 * [Ninja Forms - The Contact Form Builder That Grows With You](https://wordpress.org/plugins/ninja-forms/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ninja-forms/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ninja-forms/)
 * [Active Topics](https://wordpress.org/support/plugin/ninja-forms/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ninja-forms/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ninja-forms/reviews/)

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [mysql bug](https://wordpress.org/support/topic-tag/mysql-bug/)

 * 0 replies
 * 1 participant
 * Last reply from: [mrbooie](https://wordpress.org/support/users/mrbooie/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/export-import-3/)
 * Status: not resolved