• 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/

    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)
  • Plugin Support Gerard Blanco

    (@sixaxis)

    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.