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!
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.
