Title: Primary Keys Missing
Last modified: April 2, 2021

---

# Primary Keys Missing

 *  Resolved [Timofey Drozhzhin](https://wordpress.org/support/users/drtimofey/)
 * (@drtimofey)
 * [5 years ago](https://wordpress.org/support/topic/primary-keys-missing/)
 * Column `id` is not set as the Primary Key on tables `wp_shortpixel_folders` and`
   wp_shortpixel_meta`. This may result in data loss for users using cloud MYSQL
   services, more specifically those who are scaling via row-based replication.
 * DigitalOcean, for example, uses row-based replication and requires all database
   tables to specify a Primary Key [https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/](https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/)
 * This is easily fixed by running:
    `ALTER TABLE wp_shortpixel_folders ADD PRIMARY
   KEY (id);` `ALTER TABLE wp_shortpixel_meta ADD PRIMARY KEY (id);`

Viewing 1 replies (of 1 total)

 *  [Gerard Blanco](https://wordpress.org/support/users/sixaxis/)
 * (@sixaxis)
 * [5 years ago](https://wordpress.org/support/topic/primary-keys-missing/#post-14276845)
 * Hi, Timofey!
 * Thanks for letting us know, we’ve filed a bug on our task list so we can fix 
   it.
 * Have a good one!

Viewing 1 replies (of 1 total)

The topic ‘Primary Keys Missing’ is closed to new replies.

 * ![](https://ps.w.org/shortpixel-image-optimiser/assets/icon-256x256.gif?rev=3245715)
 * [ShortPixel Image Optimizer - Optimize Images, Convert WebP & AVIF](https://wordpress.org/plugins/shortpixel-image-optimiser/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/shortpixel-image-optimiser/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/shortpixel-image-optimiser/)
 * [Active Topics](https://wordpress.org/support/plugin/shortpixel-image-optimiser/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/shortpixel-image-optimiser/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/shortpixel-image-optimiser/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Gerard Blanco](https://wordpress.org/support/users/sixaxis/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/primary-keys-missing/#post-14276845)
 * Status: resolved