Database error Duplicate column name

  • Resolved rekcah

    (@rekcah)


    4 years, 10 months ago

    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: https://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

    (@demonisblack)

    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

    (@rekcah)

    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

    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

    Thank you!

    Plugin Author demonisblack

    (@demonisblack)

    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.