Title: Database error Duplicate column name
Last modified: January 25, 2020

---

# Database error Duplicate column name

 *  Resolved [rekcah](https://wordpress.org/support/users/rekcah/)
 * (@rekcah)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-duplicate-column-name-2/)
 * Hi,
 * The error log is filled with the following:
    WordPress database error Duplicate
   column name ‘note_post_ID’ for query ALTER TABLE `wordpress_demon_imagenote` 
   ADD `note_post_ID` bigint(20) NOT NULL AFTER `note_comment_ID`; made by do_action(‘
   admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, dia_admin_init, dia_createtable,
   referer: [http://localhost/wp-admin/options-general.php](http://localhost/wp-admin/options-general.php)
 * I have tried to delete the demon_imagenote table and uninstall the plugin and
   reinstall the plugin with the same result.
 * Please advise.
 * Thank you!

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

 *  Plugin Author [demonisblack](https://wordpress.org/support/users/demonisblack/)
 * (@demonisblack)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/database-error-duplicate-column-name-2/#post-12547624)
 * Hi,
 * The plugin will try to create new table if it doesn’t exist, and if table exist
   with older version it will alter to latest structure, for your case it looks 
   like the plugins try to alter the latest table structure.
 * Can you check if table plugin is remove completely?
 *  Thread Starter [rekcah](https://wordpress.org/support/users/rekcah/)
 * (@rekcah)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-duplicate-column-name-2/#post-13034899)
 * Hi,
 * Yes I did. I made sure all traces of the plugin was uninstalled.
 * Are the image notes stored in the database? For some reason after I did an OS
   update and rebooted the notes got wiped. 🙁
 * I have been seeing the following in the logs. I have searched Google for a solution
   without avail. Can you advise?
 * WordPress database error Incorrect file format ‘wordpress_demon_imagenote’ for
   query ALTER TABLE `wordpress_demon_imagenote` ADD `note_post_ID` bigint(20) NOT
   NULL AFTER `note_comment_ID`; made by do_action(‘admin_init’), WP_Hook->do_action,
   WP_Hook->apply_filters, dia_admin_init, dia_createtable, referer: [https://localhost/wp-admin/plugins.php](https://localhost/wp-admin/plugins.php)
 * WordPress database error Incorrect file format ‘wordpress_demon_imagenote’ for
   query ALTER TABLE `wordpress_demon_imagenote` \n\t\t modify `note_ID` bigint(
   20) NOT NULL AUTO_INCREMENT,\n\t\t modify `note_comment_ID` bigint(20),\n\t\t
   modify `note_top` bigint(20),\n\t\t modify `note_left` bigint(20),\n\t\t modify`
   note_width` bigint(20),\n\t\t modify `note_height` bigint(20),\n\t\t modify `
   note_text` text,\n\t\t modify `note_approved` VARCHAR(20); made by do_action(‘
   admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, dia_admin_init, dia_createtable,
   referer: [https://localhost/wp-admin/plugins.php](https://localhost/wp-admin/plugins.php)
 * Thank you!
 *  Plugin Author [demonisblack](https://wordpress.org/support/users/demonisblack/)
 * (@demonisblack)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-duplicate-column-name-2/#post-13045000)
 * Hi,
 * All the notes are stored in the database table, for your case you need to remove
   plugin table ‘wordpress_demon_imagenote’ for a clean install, then install and
   active the plugin again should create the new table without any issue.

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

The topic ‘Database error Duplicate column name’ is closed to new replies.

 * ![](https://ps.w.org/demon-image-annotation/assets/icon-256x256.png?rev=2687162)
 * [demon image annotation](https://wordpress.org/plugins/demon-image-annotation/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/demon-image-annotation/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/demon-image-annotation/)
 * [Active Topics](https://wordpress.org/support/plugin/demon-image-annotation/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/demon-image-annotation/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/demon-image-annotation/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [demonisblack](https://wordpress.org/support/users/demonisblack/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-duplicate-column-name-2/#post-13045000)
 * Status: resolved