hansr00

So, given your last reply I waited for a new release. It was installed automatically a few days ago (1.11.14) and I just activated it. Unfortunately the issue was not resolved. See the error below – complete text as found in the logfile.

Kind regards, Hans

AH01071: Got error ‘PHP message: WordPress database 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 ‘1’ at line 7 for query \n\tCREATE TABLE IF NOT EXISTS bghy_blc_filters (\n\t\tid int(10) unsigned NOT NULL AUTO_INCREMENT,\n\t\tname varchar(100) NOT NULL,\n\t\tparams text NOT NULL,\n\n\t\tPRIMARY KEY (id)\n\t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::deltaPHP message: WordPress database 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 ‘1’ at line 16 for query \n\n\tCREATE TABLE IF NOT EXISTS bghy_blc_instances (\n\t\tinstance_id int(10) unsigned NOT NULL AUTO_INCREMENT,\n\t\tlink_id int(10) unsigned NOT NULL,\n\t\tcontainer_id int(10) unsigned NOT NULL,\n\t\tcontainer_type varchar(40) NOT NULL DEFAULT ‘post’,\n\t\tlink_text text NOT NULL DEFAULT ”,\n\t\tparser_type varchar(40) NOT NULL DEFAULT ‘link’,\n\t\tcontainer_field varchar(250) NOT NULL DEFAULT ”,\n\t\tlink_context varchar(250) NOT NULL DEFAULT ”,\n\t\traw_url text NOT NULL,\n\n\t\tPRIMARY KEY (instance_id),\n\t\tKEY link_id (link_id),\n\t\tKEY source_id (container_type, container_id),\n\t\tKEY parser_type (parser_type)\n\t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action…PHP message: WordPress database 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 ‘1’ at line 31 for query \n\n\tCREATE TABLE IF NOT EXISTS bghy_blc_links (\n\t\tlink_id int(20) unsigned NOT NULL AUTO_INCREMENT,\n\t\turl text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\n\t\tfirst_failure datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,\n\t\tlast_check datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,\n\t\tlast_success datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,\n\t\tlast_check_attempt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,\n\t\tcheck_count int(4) unsigned NOT NULL DEFAULT ‘0’,\n\t\tfinal_url text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,\n\t\tredirect_count smallint(5) unsigned NOT NULL DEFAULT ‘0’,\n\t\tlog text NOT NULL,\n\t\thttp_code smallint(6) NOT NULL DEFAULT ‘0’,\n\t\tstatus_code varchar(100) DEFAULT ”,\n\t\tstatus_text varchar(250) DEFAULT ”,\n\t\trequest_duration float NOT NULL DEF…PHP message: WordPress database 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 ‘1’ at line 9 for query \n\n\tCREATE TABLE IF NOT EXISTS bghy_blc_synch (\n\t\tcontainer_id int(20) unsigned NOT NULL,\n\t\tcontainer_type varchar(40) NOT NULL,\n\t\tsynched tinyint(2) unsigned NOT NULL,\n\t\tlast_synch datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,\n\n\t\tPRIMARY KEY (container_type,container_id),\n\t\tKEY synched (synched)\n\t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::deltaPHP message: WordPress database error Table ‘a75415_r93j1.bghy_blc_links’ doesn’t exist for query \n\t\t\t\tSELECT COUNT(*)\n\t\t\t\tFROM (\n\t\t\t\t\tSELECT 0\n\n\t\t\t\t\tFROM\n\t\t\t\t\t\tbghy_blc_links AS links\n\t\t\t\t\t\tJOIN bghy_blc_instances AS instances ON links.link_id = instances.link_id\n\n\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t( instances.parser_type IN (‘link’, ‘image’, ‘youtube-iframe’, ‘metadata’, ‘url_field’, ‘acf’) ) AND\n\t( instances.container_type IN (‘comment’, ‘post’, ‘page’, ‘dummy’) ) AND\n\t( ( broken = 1 ) ) AND\n\t( (dismissed = 0) ) \n\n\t\t\t\t GROUP BY links.link_id) AS foo made by require_once(‘wp-admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), WP_Hook->do_action, WP_Hook->apply_filters, wsBrokenLinkChecker->admin_menu, blcLinkQuery->get_filter_links, blcLinkQuery->get_links’, referer: https://meteo-wagenborgen.nl/wp/wp-admin/plugins.php

Thank you!

Mmm…. I regard this line really as an error:

Database 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 ‘1’ at line 31
[ ] CREATE TABLE IF NOT EXISTS bghy_blc_synch ( container_id int(20) unsigned NOT NULL, container_type varchar(40) NOT NULL, synched tinyint(2) unsigned NOT NULL, last_synch datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, PRIMARY KEY (container_type,container_id), KEY synched (synched) ) DEFAULT CHARACTER SET utf8mb4 COLLATE 1

But I will try the new release when it comes out.
An no, I do not regard this issue as resolved. Sorry.

Best regards,
Hans

Hello, I progressed to confirm positively (unfortunately) it is really the Broken Link Checker which has the problem.

I changed from Fast-CGI to PHP-FPM on PHP 7.3 and that did not help.

I can tell you that on my other WordPress site the Broken Link Checker works flawlessly. If you need access to the site or the database I can make a user and give it.

I can find the debug log on the first tab of the settings, but it is unclear to me how to share it with you so I give the installation log quoted below.

Activating the logging on the advanced tab does not produce any logfile (after how much time should it appear?)

Debug info in the ‘green’ screen:

Plugin activated at 2020-06-07 07:09:25.
Installation/update begins.
Upgrading the database…
… SHOW TABLES (0.004 seconds)
[ ] CREATE TABLE IF NOT EXISTS bghy_blc_filters ( id int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, params text NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARACTER SET utf8mb4 COLLATE 1
Database 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 ‘1’ at line 7
[ ] CREATE TABLE IF NOT EXISTS bghy_blc_instances ( instance_id int(10) unsigned NOT NULL AUTO_INCREMENT, link_id int(10) unsigned NOT NULL, container_id int(10) unsigned NOT NULL, container_type varchar(40) NOT NULL DEFAULT ‘post’, link_text text NOT NULL DEFAULT ”, parser_type varchar(40) NOT NULL DEFAULT ‘link’, container_field varchar(250) NOT NULL DEFAULT ”, link_context varchar(250) NOT NULL DEFAULT ”, raw_url text NOT NULL, PRIMARY KEY (instance_id), KEY link_id (link_id), KEY source_id (container_type, container_id), KEY parser_type (parser_type) ) DEFAULT CHARACTER SET utf8mb4 COLLATE 1
Database 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 ‘1’ at line 16
[ ] CREATE TABLE IF NOT EXISTS bghy_blc_links ( link_id int(20) unsigned NOT NULL AUTO_INCREMENT, url text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, first_failure datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, last_check datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, last_success datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, last_check_attempt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, check_count int(4) unsigned NOT NULL DEFAULT ‘0’, final_url text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, redirect_count smallint(5) unsigned NOT NULL DEFAULT ‘0’, log text NOT NULL, http_code smallint(6) NOT NULL DEFAULT ‘0’, status_code varchar(100) DEFAULT ”, status_text varchar(250) DEFAULT ”, request_duration float NOT NULL DEFAULT ‘0’, timeout tinyint(1) unsigned NOT NULL DEFAULT ‘0’, broken tinyint(1) unsigned NOT NULL DEFAULT ‘0’, warning tinyint(1) unsigned NOT NULL DEFAULT ‘0’, may_recheck tinyint(1) NOT NULL DEFAULT ‘1’, being_checked tinyint(1) NOT NULL DEFAULT ‘0’, result_hash varchar(200) NOT NULL DEFAULT ”, false_positive tinyint(1) NOT NULL DEFAULT ‘0’, dismissed tinyint(1) NOT NULL DEFAULT ‘0’, PRIMARY KEY (link_id), KEY url (url(150)), KEY final_url (final_url(150)), KEY http_code (http_code), KEY broken (broken) ) DEFAULT CHARACTER SET utf8mb4 COLLATE 1
Database 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 ‘1’ at line 31
[ ] CREATE TABLE IF NOT EXISTS bghy_blc_synch ( container_id int(20) unsigned NOT NULL, container_type varchar(40) NOT NULL, synched tinyint(2) unsigned NOT NULL, last_synch datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, PRIMARY KEY (container_type,container_id), KEY synched (synched) ) DEFAULT CHARACTER SET utf8mb4 COLLATE 1
Database 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 ‘1’ at line 9
Schema update took 0.009 seconds
Database schema updated.
— Total: 0.015 seconds
Cleaning up the database…
… Deleting invalid container records
… 0 synch records deleted in 0.000 seconds
… Deleting invalid link instances
… 0 instances deleted in 0.000 seconds
… 0 more instances deleted in 0.000 seconds
… Deleting orphaned links
… 0 links deleted in 0.000 seconds
— Total: 0.001 seconds
Notifying modules…
… Updating module cache
… Cache refresh took 0.000 seconds
… Loading modules
… 6 modules loaded in 0.007 seconds
… Notifying module “http”
… Notifying module “link”
… Notifying module “image”
… Notifying module “metadata”
… Notifying module “url_field”
… Notifying module “comment”
…… Deleting synch. records for removed comments
…… 0 rows deleted in 0.001 seconds
…… Creating synch. records for new comments
…… 0 rows inserted in 0.001 seconds
… Notifying module “acf”
… Notifying module “post”
…… Deleting synch records for removed posts & post with invalid status
DELETE synch.* FROM bghy_blc_synch AS synch WHERE synch.container_id NOT IN (‘560’, ‘506’, ‘447’, ‘409’, ‘398’, ‘389’, ‘362’, ‘335’, ‘325’, ‘313’, ‘297’, ‘300’, ‘277’, ‘253’, ‘226’, ‘193’, ‘181’, ‘177’, ‘170’, ‘163’, ‘155’, ‘151’, ‘140’, ‘121’, ’80’, ’37’, ’29’, ’25’, ’13’, ‘2’)
…… 0 rows deleted in 0.008 seconds
…… Marking changed posts as unsynched
UPDATE bghy_blc_synch AS synch JOIN bghy_posts AS posts ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) SET synched = 0 WHERE synch.last_synch < posts.post_modified
…… 0 rows updated in 0.000 seconds
…… Creating synch records for new posts
INSERT INTO bghy_blc_synch(container_id, container_type, synched) SELECT posts.id, posts.post_type, 0 FROM bghy_posts AS posts LEFT JOIN bghy_blc_synch AS synch ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) WHERE posts.post_status IN (‘publish’) AND posts.post_type IN (‘post’, ‘page’) AND synch.container_id IS NULL
…… 0 rows inserted in 0.000 seconds
… Notifying module “page”
…… Skipping “page” resyncyh since all post types were already synched.
… Notifying module “youtube-checker”
… Notifying module “youtube-iframe”
… Notifying module “dummy”
— Total: 0.056 seconds
Updating server load limit settings…
Set server load limit to 4.00. Current load average is 1.01
Optimizing the database…
— Total: 0.000 seconds
Completing installation…
Configuration saved.
Installation/update completed at 2020-06-07 07:09:25 with 24 queries executed.
Total time: 0.211 seconds

Hi, No, it is not resolved, but as I am trying slowly to activate plugins one by one I may come back to the issue once I know which plugin causes it. It may not be the broken link checker. I’ll keep you informed.

Regards, Hans

Hi Nastaia,
Unfortunately this did not work. I must say that the messages continued while I had disabled the plugin. Now I see this:

[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcontainer_field varchar(250) NOT NULL DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlink_context varchar(250) NOT NULL DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\traw_url text NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tPRIMARY KEY (instance_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY link_id (link_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY source_id (container_type, container_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY parser_type (parser_type), referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: WordPress database 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 ‘1’ at line 31 for query , referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \tCREATE TABLE IF NOT EXISTS bghy_blc_links (, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlink_id int(20) unsigned NOT NULL AUTO_INCREMENT,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\turl text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tfirst_failure datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_check datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_success datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_check_attempt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcheck_count int(4) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tfinal_url text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tredirect_count smallint(5) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlog text NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\thttp_code smallint(6) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tstatus_code varchar(100) DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tstatus_text varchar(250) DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\trequest_duration float NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\ttimeout tinyint(1) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tbroken tinyint(1) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\twarning tinyint(1) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tmay_recheck tinyint(1) NOT NULL DEFAULT ‘1’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tbeing_checked tinyint(1) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tresult_hash varchar(200) NOT NULL DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tfalse_positive tinyint(1) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tdismissed tinyint(1) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tPRIMARY KEY (link_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY url (url(150)),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY final_url (final_url(150)),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY http_code (http_code),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY broken (broken), referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: WordPress database 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 ‘1’ at line 9 for query , referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \tCREATE TABLE IF NOT EXISTS bghy_blc_synch (, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcontainer_id int(20) unsigned NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcontainer_type varchar(40) NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tsynched tinyint(2) unsigned NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_synch datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tPRIMARY KEY (container_type,container_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY synched (synched), referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: PHP Warning: Invalid argument supplied for foreach() in /var/www/clients/client13104/web75415/web/wp/wp-cron.php on line 117, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375

Hi, thanks for your reply. I did what you asked and unfortuanetly that does not help:

[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcontainer_field varchar(250) NOT NULL DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlink_context varchar(250) NOT NULL DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\traw_url text NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tPRIMARY KEY (instance_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY link_id (link_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY source_id (container_type, container_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY parser_type (parser_type), referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: WordPress database 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 ‘1’ at line 31 for query , referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \tCREATE TABLE IF NOT EXISTS bghy_blc_links (, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlink_id int(20) unsigned NOT NULL AUTO_INCREMENT,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\turl text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tfirst_failure datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_check datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_success datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_check_attempt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcheck_count int(4) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tfinal_url text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tredirect_count smallint(5) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlog text NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\thttp_code smallint(6) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tstatus_code varchar(100) DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tstatus_text varchar(250) DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\trequest_duration float NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\ttimeout tinyint(1) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tbroken tinyint(1) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\twarning tinyint(1) unsigned NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tmay_recheck tinyint(1) NOT NULL DEFAULT ‘1’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tbeing_checked tinyint(1) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tresult_hash varchar(200) NOT NULL DEFAULT ”,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tfalse_positive tinyint(1) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tdismissed tinyint(1) NOT NULL DEFAULT ‘0’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tPRIMARY KEY (link_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY url (url(150)),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY final_url (final_url(150)),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY http_code (http_code),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY broken (broken), referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: WordPress database 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 ‘1’ at line 9 for query , referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \tCREATE TABLE IF NOT EXISTS bghy_blc_synch (, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcontainer_id int(20) unsigned NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tcontainer_type varchar(40) NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tsynched tinyint(2) unsigned NOT NULL,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tlast_synch datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tPRIMARY KEY (container_type,container_id),, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t\tKEY synched (synched), referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: \t) DEFAULT CHARACTER SET utf8mb4 COLLATE 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375
[Mon May 04 21:00:02 2020] [warn] [client 2a00] mod_fcgid: stderr: PHP Warning: Invalid argument supplied for foreach() in /var/www/clients/client13104/web75415/web/wp/wp-cron.php on line 117, referer: https://meteo-wagenborgen.nl/wp/wp-cron.php?doing_wp_cron=1588618799.7603909969329833984375

`

• This reply was modified 4 years, 6 months ago by hansr00.

I did, and I could immediately see it did not have any effect. I’ll leave it off though for the moment.

In the mean time: I forgot to mention that I can’t save edits. If I edit an existing – more complex larger – post, the changes are not stored but that may have to do with the editors I use, I am not sure.

Ah yes. I see your point now.

But apparently v2 remains beside v3 so Google seems to understand the issue well.
Something for everybody’s needs? That would mean that an application on the level of CF7 requires choice for the user i.e. the webmaster.

Agreed! The combination with a v2/v3 choice as suggested earlier is useful, but you still need to be able to modify your threshold.

I read that topic, I think that is another issue.

Thanks, it’s working. I used the webroot as start of the path but it must start at the /var-path. Got it.

I seearched this forum on cumulus, that was wrong. I’ll start in the community from now on. I suppose for real support this remains the forum?

Best, HansR

Indeed, the message disappears.
A page reload does not show it again.

– Version 1.9.2
– click x removes the messages which reappears on page reload.

• This reply was modified 6 years, 6 months ago by hansr00.