Title: Problem with db
Last modified: April 21, 2023

---

# Problem with db

 *  Resolved [piotrjan](https://wordpress.org/support/users/piotrjan/)
 * (@piotrjan)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-with-db/)
 * 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](https://wordpress.org/support/users/wordplus/)
 * (@wordplus)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-with-db/#post-16674541)
 * 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](https://wordpress.org/support/users/piotrjan/)
 * (@piotrjan)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-with-db/#post-16674568)
 * Thank you for the quick reply. It helped
 *  Thread Starter [piotrjan](https://wordpress.org/support/users/piotrjan/)
 * (@piotrjan)
 * [3 years ago](https://wordpress.org/support/topic/problem-with-db/#post-16767315)
 * 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](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.

 * ![](https://ps.w.org/bp-better-messages/assets/icon-256x256.png?rev=2835105)
 * [Better Messages - Chat Rooms, Group Chat, Private Messages & AI Chat Bots](https://wordpress.org/plugins/bp-better-messages/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/bp-better-messages/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/bp-better-messages/)
 * [Active Topics](https://wordpress.org/support/plugin/bp-better-messages/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/bp-better-messages/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/bp-better-messages/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [piotrjan](https://wordpress.org/support/users/piotrjan/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/problem-with-db/#post-16767315)
 * Status: resolved