ERROR! Could not save the data. Please try again

This error message was added in Squirrly SEO plugin since 2019.

If you’re getting this error, the plugin can’t save the SEO Snippet into database.

Situations when this error is triggered:

  1. The database table (wp)_qss is deleted and the plugin doesn’t have the permission to create it again.
  2. The table integrity is affected and not all columns are present in the table:


  3. The table Character Set is not set to UTF8 or UTF8mb4 and the saving data doesn’t match.

Solutions:

1. Create the table with the correct WordPress table prefix and the name _qss. We will use the default WordPress prefix but you need to change the wp prefix with the one you set in wp-config.php

CREATE TABLE wp_qss (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT ,
blog_id int(10) NOT NULL ,
URL varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
url_hash varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
seo text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
date_time datetime NOT NULL ,
post varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' ,
PRIMARY KEY (id),
UNIQUE INDEX url_hash (url_hash) USING BTREE ,
INDEX blog_id_url_hash (blog_id, url_hash) USING BTREE
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

2. Alter the table with this SQL command:

ALTER TABLE wp_qss ADD COLUMN post varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ''

3. Run the SQL command:

ALTER TABLE wp_qss DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci