Problem with db

Resolved piotrjan
(@piotrjan)

3 years, 1 month ago

I have errors in my logs like below:

[Duplicate column name ‘is_pinned’]
ALTER TABLE wp_bm_message_recipients ADD is_pinned TINYINT(1) NOT NULL DEFAULT ‘0’ AFTER is_muted;

[Duplicate key name ‘is_pinned’]
ALTER TABLE wp_bm_message_recipients ADD INDEX is_pinned (is_pinned);

[Can’t DROP INDEX last_delivered; check that it exists]
ALTER TABLE fso_bm_message_recipients DROP INDEX last_delivered;

[Can’t DROP INDEX last_read; check that it exists]
ALTER TABLE fso_bm_message_recipients DROP INDEX last_read;

I delete column ‘is_pinned’ and key ‘is_pinned’.
Add INDEX last_delivered
Add INDEX last_read

After my actions, the error did not appear only on the first refresh of the page.
The second time I visit the page, I get the same error again

Could you help me with this error?

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

Plugin Author wordplus
(@wordplus)

3 years, 1 month ago

Hi there!

If you dont have alot of messages yet, I would suggest to reset database using plugin settings -> Tools -> Reset Database button

Thread Starter piotrjan
(@piotrjan)

3 years, 1 month ago

Thank you for the quick reply. It helped

Thread Starter piotrjan
(@piotrjan)

3 years ago

Hi,

The error reappears. Is there any other way than database reset?

Full error:

///
Got error ‘PHP message: WordPress database error Duplicate column name ‘is_pinned’ for query ALTER TABLE fso_bm_message_recipients ADD is_pinned TINYINT(1) NOT NULL DEFAULT ‘0’ AFTER is_muted; made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Better_Messages_Hooks->update_db_if_needed, Better_Messages_Rest_Api_DB_Migrate->install_tables, Better_Messages_Rest_Api_DB_Migrate->upgrade, QM_DB->queryPHP message: WordPress database error Duplicate key name ‘is_pinned’ for query ALTER TABLE fso_bm_message_recipients ADD INDEX is_pinned (is_pinned); made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Better_Messages_Hooks->update_db_if_needed, Better_Messages_Rest_Api_DB_Migrate->install_tables, Better_Messages_Rest_Api_DB_Migrate->upgrade, QM_DB->queryPHP message: WordPress database error Can’t DROP INDEX last_delivered; check that it exists for query ALTER TABLE fso_bm_message_recipients DROP INDEX last_delivered; made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Better_Messages_Hooks->update_db_if_needed, Better_Messages_Rest_Api_DB_Migrate->install_tables, Better_Messages_Rest_Api_DB_Migrate->upgrade, QM_DB->queryPHP message: WordPress database error Can’t DROP INDEX last_read; check that it exists for query ALTER TABLE fso_bm_message_recipients DROP INDEX last_read; made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Better_Messages_Hooks->update_db_if_needed, Better_Messages_Rest_Api_DB_Migrate->install_tables, Better_Messages_Rest_Api_DB_Migrate->upgrade, QM_DB->query’, referer: https://filmspringopen.eu/wp-admin/post.php?post=32061&action=edit&lang=pl
///

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

The topic ‘Problem with db’ is closed to new replies.