Some errors on install – Local Installation
-
Hello there!
Hope you are doing well!
We had conversed on
https://www.ads-software.com/support/topic/display-a-custom-column-on-inbound-messages-table-2/I finally found the time to get to your plugin!
My local setup:
WordPress version: 5.8
WooCommerce version: 5.6.0
Contact Form 7 by Takayuki Miyoshi – 5.4.2
AntiSpam for Contact Form 7 by Codekraft – 0.2.5Flamingo was missing on this instance.
On my local installation with debug.log enabled, I saw the below errors in my log file:
[06-Sep-2021 12:52:58 UTC] WordPress database error Specified key was too long; max key length is 767 bytes for query CREATE TABLE IF NOT EXISTS wp_cf7a_blacklist ( <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT, <code>ip</code> varchar(255) NOT NULL, <code>status</code> int(10) unsigned DEFAULT NULL, <code>meta</code> longtext, PRIMARY KEY (<code>id</code>), UNIQUE KEY <code>id</code> (<code>ip</code>) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by activate_plugin, do_action('activate_cf7-antispam/cf7-antispam.php'), WP_Hook->do_action, WP_Hook->apply_filters, activate_cf7_antispam, CF7_AntiSpam_Activator::activate, CF7_AntiSpam_Activator::install, dbDelta [06-Sep-2021 12:53:25 UTC] WordPress database error Table 'prehugged.wp_cf7a_blacklist' doesn't exist for query SELECT * FROM wp_cf7a_blacklist ORDER BY <code>status</code> DESC LIMIT 1000 made by do_action('contact_page_cf7-antispam'), WP_Hook->do_action, WP_Hook->apply_filters, CF7_AntiSpam_Admin->cf7a_admin_dashboard, CF7_AntiSpam_Admin_Display->display_dashboard, do_action('cf7a_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, CF7_AntiSpam_Admin_Display->cf7a_display_debug, CF7_AntiSpam_Admin_Tools::cf7a_get_blacklisted_table [06-Sep-2021 12:55:23 UTC] WordPress database error Table 'prehugged.wp_cf7a_blacklist' doesn't exist for query SELECT * FROM wp_cf7a_blacklist ORDER BY <code>status</code> DESC LIMIT 1000 made by do_action('contact_page_cf7-antispam'), WP_Hook->do_action, WP_Hook->apply_filters, CF7_AntiSpam_Admin->cf7a_admin_dashboard, CF7_AntiSpam_Admin_Display->display_dashboard, do_action('cf7a_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, CF7_AntiSpam_Admin_Display->cf7a_display_debug, CF7_AntiSpam_Admin_Tools::cf7a_get_blacklisted_tablePlease review and guide.
Thanks
Take care, stay safe!
-
Ciao @koolpal,
sure of course I remember you! And I’m sorry I haven’t yet put in place a way to filter users by nationality as you requested but I need to decide on an effective method… Because using geoip is accurate but isn’t easy to configure for users (api registration etc) and, on the other hand, detecting an user by keyboard or browser language may be too much imprecise (and I don’t want to use external services)!Back to your issue seems related to this:https://stackoverflow.com/questions/1814532/mysql-error-1071-specified-key-was-too-long-max-key-length-is-767-bytes
i’ve set
varchar(254)but your default collation (utf8mb4) allows only 190 characters (767 / 4 = 191).thanks for pointing this out, I’ll fix it as soon as possible!
—
the fix (if you are a dev) is to change the plugins/cf7-antispam/includes/cf7a-activator.php line 126 and 137 replacingvarchar(254)withvarchar(190)or if you are handy with github you can find the pre-release over therehello @koolpal and thank you for the detailed feedback! i’ll try to explain how to solve:
1) This happens because the plugin has failed the activation with v0.2.5 and, to get the it working you need to uninstall and install it again. The uninstall script will reset any data created with cf7-antispam plugin, so after that you can perform a clean installation.
2) “wpcf7 is not defined” means that contact form 7 isn’t enabled or the wpcf7 script isn’t loaded. do you load the contact form script in a customised way in the frontend? (anyway thanks also for this I will make an alert for admins in the next version)
thank you again and ask me if you need anything. Erik
Maybe the issue is related to “Cf7 Fields Repeater” plugin. checked with w3c validator the demo page and it seems to shows the same issue.
There is a way to mute this warning but I believe it is correct to show that alert if the html code is not valid (anyway it’s displayed only while debugging is enabled).
if needed, you can mute that warning disabling honeypot in cf7-antispam configuration
—
About js/css prevent loading I will fix in the next version, I will load anti-spam scripts only if cf7 is scripts are loaded too (thanks for this report)
- The topic ‘Some errors on install – Local Installation’ is closed to new replies.
