Title: Database Table is Missing Primary Key
Last modified: April 2, 2021

---

# Database Table is Missing Primary Key

 *  Resolved [Timofey Drozhzhin](https://wordpress.org/support/users/drtimofey/)
 * (@drtimofey)
 * [5 years ago](https://wordpress.org/support/topic/database-table-is-missing-primary-key/)
 * Table `wp_mo_optin_advance_stat` is missing the Primary Key. Please consider 
   adding one, as it’s required for proper MYSQL row-based replication. For example,
   my host, Digital Ocean requires Primary Keys on all tables – see [https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/](https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/)
 * I’m using the following fix in the mean time:
    `ALTER TABLE wp_mo_optin_advance_stat
   ADD id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;`
 * Thanks,
    Tim

Viewing 1 replies (of 1 total)

 *  Plugin Author [Collins Agbonghama](https://wordpress.org/support/users/collizo4sky/)
 * (@collizo4sky)
 * [5 years ago](https://wordpress.org/support/topic/database-table-is-missing-primary-key/#post-14273988)
 * Done => [https://github.com/mailoptin/core/commit/42f286a7751859fe717ffa85a0bd1352c9caee54#diff-c53d9c45bab2b01b22573150882a24822e9c6dde1621b0dc642c2e9672313daeR217](https://github.com/mailoptin/core/commit/42f286a7751859fe717ffa85a0bd1352c9caee54#diff-c53d9c45bab2b01b22573150882a24822e9c6dde1621b0dc642c2e9672313daeR217)
 * Thanks for reporting.

Viewing 1 replies (of 1 total)

The topic ‘Database Table is Missing Primary Key’ is closed to new replies.

 * ![](https://ps.w.org/mailoptin/assets/icon-256x256.png?rev=1699978)
 * [MailOptin - Popup, Optin Forms & Email Newsletters for Mailchimp, HubSpot, AWeber Etc.](https://wordpress.org/plugins/mailoptin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/mailoptin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/mailoptin/)
 * [Active Topics](https://wordpress.org/support/plugin/mailoptin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/mailoptin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/mailoptin/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Collins Agbonghama](https://wordpress.org/support/users/collizo4sky/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/database-table-is-missing-primary-key/#post-14273988)
 * Status: resolved