Hello.
I see that the Anti-Spam by CleanTalk plugin is deactivated or uninstalled at this moment. Could you please check its status and, if necessary, re-install it? You can use this guide to check all the steps including the correction of the access key: https://cleantalk.org/help/install-wordpress.
If you need further assistance please contact us via our private Ticket System: https://cleantalk.org/my/support/open. We might need to discuss some confidential data, and this way it will be safe.
ehhh.. it was installed and activated, so I deleted it to try and reinstall but now it failed: Installation failed: Download failed. cURL error 77.
ok I bypassed the issue by using plesk, and i was able to install clean talk. However, after syncing with the cloud I got this:
Nov 01 2023 06:59:59: Error occurred while checking account status. CONNECTION_ERROR : “Unknown Error. Last error: Required parameter $id follows optional parameter $avatar Nov 01 2023 06:59:59: Error occurred while Access key validating. Testing is failed. Please check the Access key.
When I attempted to get the access key by clicking, I got this: CONNECTION_ERROR : “Unknown Error. Last error: Required parameter $id follows optional parameter $avatar
Here are the debug errors:
ArrayObject Object
(
[storage:ArrayObject:private] => Array
(
[17:36:59_ACTION__FUNCTION_] => Array
(
[0] => Failed.
Query: ALTER TABLE wp_cleantalk_sfw_logs
CHANGE status status ENUM('PASS_SFW','DENY_SFW','PASS_SFW__BY_WHITELIST','PASS_SFW__BY_COOKIE','DENY_ANTICRAWLER','PASS_ANTICRAWLER','DENY_ANTIFLOOD','PASS_ANTIFLOOD') NOT NULL AFTER ip;
Error: Unknown column 'status' in 'wp_cleantalk_sfw_logs'
)
[09:39:32_ACTION__FUNCTION_] => Array
(
[0] => Failed.
Query: ALTER TABLE wp_cleantalk_sfw ADD COLUMN IF NOT EXISTS source TINYINT(1) NULL DEFAULT NULL AFTER status;
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS source TINYINT(1) NULL DEFAULT NULL AFTER status' at line 1
[1] => Failed.
Query: ALTER TABLE wp_cleantalk_sfw_logs ADD COLUMN IF NOT EXISTS source TINYINT(1) NULL DEFAULT NULL AFTER ua_name, ADD COLUMN IF NOT EXISTS network VARCHAR(20) NULL DEFAULT NULL AFTER source, ADD COLUMN IF NOT EXISTS first_url VARCHAR(100) NULL DEFAULT NULL AFTER network, ADD COLUMN IF NOT EXISTS last_url VARCHAR(100) NULL DEFAULT NULL AFTER first_url;
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS source TINYINT(1) NULL DEFAULT NULL AFTER ua_name, ADD COLUMN ' at line 1
)
[2023-10-31 21:28:541698787734.897_ACTION_sanitize_option_cleantalk_settings_FUNCTION_] => Array
(
[https://moderate1.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.054489135742188
)
[https://moderate2.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.037485122680664
)
[https://moderate3.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.15939712524414
)
[https://moderate4.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.15855598449707
)
[https://moderate5.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.12988209724426
)
[https://moderate6.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.06599497795105
)
[https://moderate7.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.15869998931885
)
[https://moderate9.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.041538000106812
)
[https://moderate10.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.15983486175537
)
[https://apix1.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.14690184593201
)
[https://apix2.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.040925979614258
)
[https://apix3.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.053380966186523
)
[https://apix4.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.093310832977295
)
[https://apix5.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.13719987869263
)
[https://apix6.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.09790301322937
)
[http://netserv2.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.28725981712341
)
[http://netserv3.cleantalk.org] => Array
(
[result] => OK
[exec_time] => 0.26267099380493
)
)
)
)
Could you please you reach out to our support team so we can gather some more information from you concerning this issue: https://cleantalk.org/my/support/open?
Please, paste the link to this topic, so we can identify you quickly.
The ini_get(‘curl.cainfo’) and ini_get(‘openssl.cafile’) functions returned empty strings. And should return the path to the .pem file.
It is necessary to check the php.ini config for php8. The post gives an example of how it should look: https://wordpress.org/support/topic/curl-error-77-5/#post-14594024.
Hello.
We haven’t heard back from you in a few days, so I’m going to mark this topic as “resolved”.
If you have any further questions, you can start a new topic or contact us via our private Ticket System: https://cleantalk.org/my/support/open.
