valedelsol

I found out that the problem is the WP plug-in Contact Form 7 where Google fonts is not an option but a must. When i deactivate this plug-in Google fonts are not loaded any more. The other question is what WP plug-in can be used instead without SPAM.

Thanks. I have clarified my problem above (edit).

• This reply was modified 7 years, 11 months ago by valedelsol.

Thanks for your investigation.

With a newer BackWPup of database the SQL file can be loaded without stream error (means load with UTF8). This is a first step forward, but:

HeidiSQL import stops at table ‘wp_wfblockediplog’ with binary data with error ‘/* SQL Fehler (1062): Duplicate entry ” for key ‘PRIMARY’ */’. If I use instead MySQL Workbench I get the same error. Here is the detail view from HeidiSQL:

CREATE TABLE wp_wfblockediplog (
IP binary(16) NOT NULL DEFAULT ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’,
countryCode varchar(2) NOT NULL,
blockCount int(10) unsigned NOT NULL DEFAULT ‘0’,
unixday int(10) unsigned NOT NULL,
PRIMARY KEY (IP,unixday)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Backup data for table wp_wfblockediplog
—

LOCK TABLES wp_wfblockediplog WRITE;
/*!40000 ALTER TABLE wp_wfblockediplog DISABLE KEYS */;
INSERT INTO wp_wfblockediplog (IP, countryCode, blockCount, unixday) VALUES
(‘\0\0\0\0\0\0\0\0\0\0??e’, ‘IN’, 1, 17222),
(‘\0\0\0\0\0\0\0\0\0\0??4%¨’, ‘VN’, 1, 17246),
(‘\0\0\0\0\0\0\0\0\0\0???Z’, ‘GB’, 1, 17222),
(‘\0\0\0\0\0\0\0\0\0\0??31\”‘, ‘AE’, 1, 17242),
(‘\0\0\0\0\0\0\0\0\0\0??>á?’, ‘RU’, 1, 17228),
(‘\0\0\0\0\0\0\0\0\0\0??>ì?’, ‘RU’, 2, 17237),
(‘\0\0\0\0\0\0\0\0\0\0??>?N’, ‘RU’, 1, 17236),
(‘\0\0\0\0\0\0\0\0\0\0???_)’, ‘RU’, 1, 17219),
(‘\0\0\0\0\0\0\0\0\0\0??\\Q?’, ‘RU’, 1, 17220),
(‘\0\0\0\0\0\0\0\0\0\0??]?’, ‘RU’, 1, 17231),
(‘\0\0\0\0\0\0\0\0\0\0??]\’#’, ‘RU’, 1, 17220),
(‘\0\0\0\0\0\0\0\0\0\0??]nd’, ‘RU’, 1, 17234),
(‘\0\0\0\0\0\0\0\0\0\0??]?4’, ‘RU’, 1, 17226),
(‘\0\0\0\0\0\0\0\0\0\0??^=?’, ‘RU’, 1, 17235),
(‘\0\0\0\0\0\0\0\0\0\0??^J’, ‘RU’, 1, 17221),
(‘\0\0\0\0\0\0\0\0\0\0??^¨A’, ‘RU’, 1, 17223),
(‘\0\0\0\0\0\0\0\0\0\0??ah?’, ‘GB’, 1, 17228),
(‘\0\0\0\0\0\0\0\0\0\0???G?’, ‘IT’, 1, 17220),
(‘\0\0\0\0\0\0\0\0\0\0??^’, ‘UA’, 1, 17223),
(‘\0\0\0\0\0\0\0\0\0\0??2ò’, ‘RU’, 1, 17238),
(‘\0\0\0\0\0\0\0\0\0\0???’, ‘RU’, 1, 17235),
(‘\0\0\0\0\0\0\0\0\0\0??Uè’, ‘RU’, 1, 17238),
(‘\0\0\0\0\0\0\0\0\0\0??Uè’, ‘RU’, 1, 17239),
(‘\0\0\0\0\0\0\0\0\0\0???X’, ‘RU’, 1, 17226),
(‘\0\0\0\0\0\0\0\0\0\0???X’, ‘RU’, 2, 17230),
(‘\0\0\0\0\0\0\0\0\0\0???X’, ‘RU’, 2, 17234),
(‘\0\0\0\0\0\0\0\0\0\0???X’, ‘RU’, 1, 17240),
(‘\0\0\0\0\0\0\0\0\0\0???á’, ‘RU’, 1, 17234),
(‘\0\0\0\0\0\0\0\0\0\0????’, ‘RU’, 1, 17224),
(‘\0\0\0\0\0\0\0\0\0\0????’, ‘RU’, 1, 17225),
(‘\0\0\0\0\0\0\0\0\0\0??2’, ‘LT’, 1, 17220),
(‘\0\0\0\0\0\0\0\0\0\0??*.e’, ‘RU’, 1, 17241),
(‘\0\0\0\0\0\0\0\0\0\0??6!?‘, ‘GR’, 1, 17239),
(‘\0\0\0\0\0\0\0\0\0\0??9’, ‘LB’, 1, 17229),
(‘\0\0\0\0\0\0\0\0\0\0??Lá?’, ‘KZ’, 1, 17233),
(‘\0\0\0\0\0\0\0\0\0\0??L??’, ‘KZ’, 1, 17236),
(‘\0\0\0\0\0\0\0\0\0\0??RìE’, ‘SA’, 1, 17220),
(‘\0\0\0\0\0\0\0\0\0\0??S|?’, ‘IT’, 1, 17219),
(‘\0\0\0\0\0\0\0\0\0\0??féá’, ‘IL’, 1, 17238),/* lange Abfrage (49,9 KiB), abgeschnitten bei 2.000 Zeichen */
/* SQL Fehler (1062): Duplicate entry ” for key ‘PRIMARY’ */

I think the developer of BackupWPup can test it himself with Wordfence Security. For me it does not work.

I have imported the database BackupWPup in a test database. Import stops at Wordfence Security data tables with follwing error:

/* SQL Fehler (1062): Duplicate entry ” for key ‘PRIMARY’ */

I have the same statements in my SQL backup file.

Here you see that binary data are not displayed correctly in the BackupWPup SQL file (with MySQL Workbench you can only import it as latin1):

DROP TABLE IF EXISTS wp_wffilemods;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = ‘utf8’ */;
CREATE TABLE wp_wffilemods (
filenameMD5 binary(16) NOT NULL,
filename varchar(1000) NOT NULL,
knownFile tinyint(3) unsigned NOT NULL,
oldMD5 binary(16) NOT NULL,
newMD5 binary(16) NOT NULL,
PRIMARY KEY (filenameMD5)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

—
— Backup data for table wp_wffilemods
—

LOCK TABLES wp_wffilemods WRITE;
/*!40000 ALTER TABLE wp_wffilemods DISABLE KEYS */;
INSERT INTO wp_wffilemods (filenameMD5, filename, knownFile, oldMD5, newMD5) VALUES
(‘\0&7a?%a(t?s\”‘, ‘wp-content/plugins/ultimate-faqs/Functions/Register_EWD_UFAQ_Posts_Taxonomies.php’, 1, ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’, ‘\Z?x?gìaT\”?0G)5òE’),
(‘\0?@u?￥?2??X??’, ‘wp-content/plugins/contact-form-7/modules/date.php’, 1, ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’, ‘V?-C?C0?`à?2g’), …

If I do not backup with BackupWPup but with HeidiSQL I get the same, correctly readable as UTF8:

— Exportiere Struktur von Tabelle xyz.wp_wffilemods
DROP TABLE IF EXISTS wp_wffilemods;
CREATE TABLE IF NOT EXISTS wp_wffilemods (
filenameMD5 binary(16) NOT NULL,
filename varchar(1000) NOT NULL,
knownFile tinyint(3) unsigned NOT NULL,
oldMD5 binary(16) NOT NULL,
newMD5 binary(16) NOT NULL,
stoppedOnSignature varchar(255) NOT NULL DEFAULT ”,
stoppedOnPosition int(10) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (filenameMD5)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

— Exportiere Daten aus Tabelle xyz.wp_wffilemods: ~7.523 rows (ungef?hr)
/*!40000 ALTER TABLE wp_wffilemods DISABLE KEYS */;
INSERT INTO wp_wffilemods (filenameMD5, filename, knownFile, oldMD5, newMD5, stoppedOnSignature, stoppedOnPosition) VALUES
(_binary 0x00052637AA911325611628FE89731222, ‘wp-content/plugins/ultimate-faqs/Functions/Register_EWD_UFAQ_Posts_Taxonomies.php’, 0, _binary 0x1ABD78AC67ECAA54229E30472935D245, _binary 0x1ABD78AC67ECAA54229E30472935D245, ”, 0),
(_binary 0x0013DF4075189CA59C3205B6EE58E7B6, ‘wp-content/plugins/contact-form-7/modules/date.php’, 1, _binary 0x00000000000000000000000000000000, _binary 0x5684AD43D143309760C0EE321B08671F, ”, 0), …

• This reply was modified 7 years, 11 months ago by valedelsol.

I have:
/** Database Charset to use in creating database tables. */
define(‘DB_CHARSET’, ‘utf8’);

/** The Database Collate type. Don’t change this if in doubt. */
define(‘DB_COLLATE’, ”);

No answer? That means BackupWPup cannot back up binary data as of WordFence Security.

This means that BackWPup cannot backup binary data of Wordfence Security.

When I enable reporting of faults I get:
Warning: An unexpected error occurred. … in C:\HostingSpaces\web12345\xyz\wwwroot\wp-admin\includes\plugin-install.php on line 165.

I have the same 11 notices / errors with PHP 5.6 if i enable error reporting. Notices / errors are also shown then on the setting page.

Now I found the solution for me:

I removed all referrers at Google Maps API. Then I removed the API key at WP Google Maps, settings, advanced, too. At clicking on maps I was asked to enter it (again). At settings, advanced, the API key was then allready there automatically.

After entering my referrer at Google Maps API it works now.

Maybe the problem is at upgrading to Pro if the API key was alleady in the basic configuration.

For me the current WP Google Maps and Pro works only if I leave at the Google API manager the field to input the URL referrers empty. So please remove in the Google API manager all URL referrers and try it again.

This is for me a quick fix but not the solution in regard of security.

Thanks, this works for me.

I have the same error “MissingKeyMapError” (I see it by Firefox website inspector), even I have entered the Google map API key for the map. The key is enabled and I see at Google console that the key works.

I have the latest WP version 4.5.3, the latest WP Google Maps basic, and latest WP Google Maps Pro version running. Before I upgraded to the Pro version it worked, now with Pro not any more.

A bug in the Pro version?