Error occurred while API key validating. Error: Testing is failed. Please check

Hello, @wporgyvonne

Please, try to reactivate the Anti-Spam plugin with “Complete deactivation” option enabled.

1. Enter to the Antispam by Cleantalk plugin settings. (Wordrpess Dashboard -> Settings -> Antispam by Cleantalk -> Advanced settings)

2. Check the last settings “Complete deactivation” and save changes.

3. Deactivate the plugin in the “Plugins” page in WordPress Dashboard.

4. Then activate it.

5. Save the access key

Did it help?

All good, thanks for the prompt response.

I am getting the same error:

CLEANTALK_AJAX_USE_BUFFER NOT_DEFINED
CLEANTALK_AJAX_USE_FOOTER_HEADER NOT_DEFINED
CLEANTALK_ACCESS_KEY NOT_DEFINED
CLEANTALK_CHECK_COMMENTS_NUMBER NOT_DEFINED
CLEANTALK_CHECK_MESSAGES_NUMBER NOT_DEFINED
CLEANTALK_PLUGIN_DIR /code/wp-content/plugins/cleantalk-spam-protect/
WP_ALLOW_MULTISITE NOT_DEFINED

My host is Pantheon, and wp-contents on Live is read only, but on Dev I got the same error, so I don’t think it’s that.

Additional information on the error report, this was also presented below the error (all caps in my initial post):

ArrayObject Object
(
[storage:ArrayObject:private] => Array
(
[16:23:24_ACTION_activate_cleantalk-spam-protect/cleantalk.php_FUNCTION_] => Array
(
[0] => Failed.
Query: CREATE TABLE IF NOT EXISTS wp_cleantalk_ua_bl (
id INT(11) NOT NULL,
ua_template VARCHAR(512) NULL DEFAULT NULL,
ua_status TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY ( id ),
INDEX ( ua_template )
);
Error: Index column size too large. The maximum column size is 767 bytes.
)

)

)

Hello @silverliebt
We will check this and tell you what is wrong and how to fix this. At the moment I recommend you to reinstall the plugin with the “Complete deactivation” option enabled.
You can find this option at the bottom of the plugin advanced settings.
Be well,

OK, I tried that already, but not after completely removing the plugin, which I will try now.

After checking “complete deactivation” and then deactivating, and then deleting, I reinstalled the plugin. Upon activation, same error. Again I tried checking “complete deactivation” and deactivating/re-activating, but errors persist.

CLEANTALK_AJAX_USE_BUFFER NOT_DEFINED
CLEANTALK_AJAX_USE_FOOTER_HEADER NOT_DEFINED
CLEANTALK_ACCESS_KEY NOT_DEFINED
CLEANTALK_CHECK_COMMENTS_NUMBER NOT_DEFINED
CLEANTALK_CHECK_MESSAGES_NUMBER NOT_DEFINED
CLEANTALK_PLUGIN_DIR /code/wp-content/plugins/cleantalk-spam-protect/
WP_ALLOW_MULTISITE NOT_DEFINED
Debug log: Drop debug data
ArrayObject Object
(
[storage:ArrayObject:private] => Array
(
[16:41:04_ACTION_activate_cleantalk-spam-protect/cleantalk.php_FUNCTION_] => Array
(
[0] => Failed.
Query: CREATE TABLE IF NOT EXISTS wp_cleantalk_ua_bl (
id INT(11) NOT NULL,
ua_template VARCHAR(512) NULL DEFAULT NULL,
ua_status TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY ( id ),
INDEX ( ua_template )
);
Error: Index column size too large. The maximum column size is 767 bytes.
)

)

)

Thank you for your feedback. We will check what is wrong.
All the best,

Hello.

We have fixed the problem. All the changes will be included in the next stable release.

Please, reinstall the plugin. ( Download link: https://github.com/CleanTalk/wordpress-antispam/releases/download/dev-version/cleantalk-spam-protect.zip )

Here is a guide for you:

Go to WordPress Administrator Panel —> Plugins.
Find the plugin “Spam Protection by CleanTalk” —> Deactivate.
After the automatic page refreshing find the plugin again “Spam Protection by CleanTalk” —> Delete. Confirm “Yes, delete these files”.
Download the plugin archive from the link above.
Go to Plugins —> Add New —> Upload Plugin.
Choose the downloaded archive and press “Install Now”.

Contact us if you have any questions.

Best wishes,

Excellent, I will take these steps now and report back. Big thanks in advance.

The install worked on Pantheon’s Dev environment, but when moved to Test, failed with the same error. Please be aware of Pantheon’s hosting setup:
https://pantheon.io/docs/pantheon-workflow
Also, this might be even more useful:
https://pantheon.io/docs/plugins-known-issues
Have you had other customers hosted at Pantheon?

Sorry for the bad news. I’m considering recommending a migration to Kinsta to my client, which is where I host all new sites. Much easier.

Debug:
Constants:
CLEANTALK_AJAX_USE_BUFFER NOT_DEFINED
CLEANTALK_AJAX_USE_FOOTER_HEADER NOT_DEFINED
CLEANTALK_ACCESS_KEY NOT_DEFINED
CLEANTALK_CHECK_COMMENTS_NUMBER NOT_DEFINED
CLEANTALK_CHECK_MESSAGES_NUMBER NOT_DEFINED
CLEANTALK_PLUGIN_DIR /code/wp-content/plugins/cleantalk-spam-protect/
WP_ALLOW_MULTISITE NOT_DEFINED
Debug log: Drop debug data
ArrayObject Object
(
[storage:ArrayObject:private] => Array
(
[16:07:44_ACTION_activate_cleantalk-spam-protect/cleantalk.php_FUNCTION_] => Array
(
[0] => Failed.
Query: CREATE TABLE IF NOT EXISTS wp_cleantalk_ua_bl (
id INT(11) NOT NULL,
ua_template VARCHAR(512) NULL DEFAULT NULL,
ua_status TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY ( id ),
INDEX ( ua_template )
);
Error: Index column size too large. The maximum column size is 767 bytes.
)

)

)

By the way, you can spin up a WP sandbox account at Pantheon for free, and test the Cleantalk plugin there, if you so desire. It might help in troubleshooting the issue.

I transfer this to the developer.
Thank you!

Great, you are very welcome. Thanks to you as well.