WPThumbs
Themes Plugins By purpose By industry Best-of lists Fix it guides
Free Plugin by omelhus v1.3

Primary Key Fixer

Plugins like Yoast and Slider Revolution doesn't create a PRIMARY KEY on tables when they are created. This is an issue when using services like …

Primary Key Fixer

The facts

Active installs
200+
Price
Free
Last updated
29 Aug 2021
Added
Aug 2020
Requires WP
5.1
Tested up to
WP 5.8.15
Requires PHP
7.2
Downloads
3,740

Our analysis

AI-assisted

Primary Key Fixer is a WordPress plugin designed to address issues with database table creation by certain plugins that do not include a PRIMARY KEY. It works by adding a query filter that detects CREATE TABLE and UNIQUE KEY queries lacking a PRIMARY KEY and inserts one accordingly.

This plugin is particularly useful for users with managed database services, like Digital Ocean, that require primary keys for replication purposes. It is suitable for those who use plugins such as Yoast and Slider Revolution that may create tables without this essential database structure.

Best for: This plugin suits WordPress users who rely on specific plugins that may not create primary keys in their database tables.

What it does well

  • Free to use from the WordPress.org directory
  • Addresses specific database issues with certain plugins
  • Helps ensure compatibility with managed database services

Where it falls short

  • Does not fix queries with multiple CREATE TABLE statements that already include a PRIMARY KEY
  • Limited information available about the plugin's performance and reliability

Verdict

Primary Key Fixer provides a targeted solution for a specific database issue, but its limitations may affect users with complex table structures.

From the developer

omelhus's own description of Primary Key Fixer, lightly tidied.

Plugins like Yoast and Slider Revolution doesn’t create a PRIMARY KEY on tables when they are created. This is an issue when using services like Digital Ocean managed databases etc that uses replication and requires primary keys.

By installing this plugin it will add a query filter and look for queries that include CREATE TABLE and UNIQUE KEY, but not PRIMARY KEY, and insert a PRIMARY KEY for the same field as the UNIQUE KEY.

It will not fix restore where the query includes multiple create table and some of them contains ‘primary key’.

Read the full description on the official page →

Tagged as

Alternatives

Other plugins for sliders and carousels.

Premium Addons for Elementor

Elementor Carousel, Mega Menu, Posts List/Slider, WooCommerce Widgets, Display Conditions, AI Abilities, Prema...

Free 600k+ installs 4.9★ (1,677)
Smart Slider 3

Responsive slider plugin to create sliders in visual editor easily. Build beautiful image slider, layer slider...

Free 800k+ installs 4.9★ (1,123)
Royal Addons for Elementor

Elementor templates, Header footer builder, Elementor Post Grid, Woocommerce Grid builder, Slider, Forms, Gall...

Free 600k+ installs 4.8★ (611)
SiteOrigin Widgets Bundle

Essential elements for modern websites. Add buttons, sliders, heroes, maps, images, carousels, features, icons...

Free 400k+ installs 4.9★ (134)
Depicter

Build Stunning Slider and Popup. Exit intent Popup, Image slider carousel, video slider carousel, post slider...

Free 80k+ installs 4.6★ (234)