callistodig
Forum Replies Created
-
Forum: Plugins
In reply to: [CleanTalk Anti-Spam. Spam Firewall & Bot protection] No Primary Key on TableOn this dev version, I am getting many entries to my error_log looking like:
[03-Oct-2020 23:53:50 UTC] WordPress database error Unknown column ‘status’ in ‘field list’ for query SELECT
network, mask, status
FROM wp_XXXXXXXX_cleantalk_sfw
WHERE network IN (587202560,595591168,599785472,601882624,602931200,603193344,603258880,603267072,603267200,603267264,603267272,603267276,603267278)
AND network = 603267278 & mask made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/cleantalk-spam-protect/cleantalk.php’), apbct_sfw__check, Cleantalk\Common\Firewall->run, Cleantalk\ApbctWP\Firewall\SFW->check, Cleantalk\ApbctWP\DB->fetch_allForum: Plugins
In reply to: [CleanTalk Anti-Spam. Spam Firewall & Bot protection] No Primary Key on TableThank you! Really appreciate the fix!
Forum: Plugins
In reply to: [CleanTalk Anti-Spam. Spam Firewall & Bot protection] No Primary Key on TableConfirmed, thank you! Installed and activated successfully. I assume this will be rolled up into the next update?
Forum: Plugins
In reply to: [CleanTalk Anti-Spam. Spam Firewall & Bot protection] No Primary Key on TableHi,
First I went into Settings > Anti-Spam by CleanTalk and clicked “Drop debug data” to be sure no previous errors remained in the database. Then I followed your directions. However, I still receive the following after activating the plugin:
ArrayObject Object
(
[storage:ArrayObject:private] => Array
(
[02:23:06_ACTION_activate_cleantalk-spam-protect/cleantalk.php_FUNCTION_] => Array
(
[0] => Failed.
Query: CREATE TABLE IF NOT EXISTSwp_XXXXXXXXXX_cleantalk_sfw(
networkint(11) unsigned NOT NULL,
maskint(11) unsigned NOT NULL,
statusTINYINT(1) NOT NULL DEFAULT 0,
INDEX (network,mask)
);
Error: Unable to create or change a table without a primary key, when the system variable ‘sql_require_primary_key’ is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
))
)
The function apbct_activation does not reflect it is trying to create the table with a primary key:
$sqls[] = ‘CREATE TABLE IF NOT EXISTS
%scleantalk_sfw(
networkint(11) unsigned NOT NULL,
maskint(11) unsigned NOT NULL,
statusTINYINT(1) NOT NULL DEFAULT 0,
INDEX (network,mask)
);’;Forum: Plugins
In reply to: [CleanTalk Anti-Spam. Spam Firewall & Bot protection] No Primary Key on TableHi, any news? I’d really like to be able to activate and use the plugin on this site.
Forum: Plugins
In reply to: [CleanTalk Anti-Spam. Spam Firewall & Bot protection] No Primary Key on TableHi,
Just wanted to check-in on this.
Thanks!