jdaliani

OK on the Home Page:
https://www.calipowerwashing.com/

Meta Title = “Cali Power Washing ? Professional Pressure Washing Service”
Meta Description = “We’re one of Delaware’s top-rated exterior cleaning services for homes and businesses. Houses, driveways, sidewalks, decks, pavers & more.”

Facebook Title = “Cali Power Washing ? Professional Pressure Washing Service”
Facebook Description = “One of Delaware’s top-rated exterior cleaning services”

Twitter Title and Description are the Same As the Facebook Title and Description

Again, these (The Facebook and Twitter Descriptions, as defined in WP Meta SEO for that home page) are not displaying. Instead, the Meta description is displaying where the Facebook Description and the Twitter Description should be displaying. This only appears to be a problem on the home page. All other site pages are displaying the proper Facebook and Twitter Description values that are assigned to those pages. I’m having the same problem with other sites.

Thanks

… and now attempting to import a table from this file appears to have corrupted my entire database. This is quite upsetting.

OK here’s my problem though. In that format, I can’t re-import the database – or any individual data table thereof – through PHPMyAdmin, and attempting to do so CRASHES PHPMyAdmin – after creating a corrupted table that CAN’T be deleted! Is there any way to get it to export the database in a normal format – which is to say, like PHPMyAdmin exports databases/data tables. Because if not, it’s pretty much useless to me personally …

• This reply was modified 4 years, 8 months ago by jdaliani.

Thank you. Much appreciated.

So in laymen’s terms, what you’re saying is that it’s not incorrect, but simply in a different format, and a format that can be reimported, yes?

It seems to export fine from PHPMyAdmin, but the Updraft backup to Google drive had that weird character conversion …

OK so you mean this, right? Thanks …

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,
SHAC binary(32) NOT NULL DEFAULT ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’,
stoppedOnSignature varchar(255) NOT NULL DEFAULT ”,
stoppedOnPosition int(10) UNSIGNED NOT NULL DEFAULT ‘0’,
isSafeFile varchar(1) NOT NULL DEFAULT ‘?’
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

OK here’s a screen shot:

https://www.growing-bones.com/zdr23xSt4q/MySQLSample.png

Hello: Here are some samples of the problem:

1. This is taken from a PHPMyAdmin export of the database, and is CORRECT:

INSERT INTO wp_wffilemods (filenameMD5, filename, knownFile, oldMD5, newMD5, SHAC, stoppedOnSignature, stoppedOnPosition, isSafeFile) VALUES
(0x153bf0017bcfd7e16bfcafe10773b78e, ‘wp-content/themes/twentytwenty/404.php’, 1, 0x00000000000000000000000000000000, 0x6ae36b4bd66078c9781a642c6d014169, 0x99613ef89062475f1164f245682970884671100237f566332152a8dd2859704f, ”, 0, ‘?’),

2. This is the same line from that same MySQL datatable and is taken from the UpDraft backup to Google Drive:

INSERT INTO wp_wffilemods VALUES
(‘;?{??·k??·s∑é’, ‘wp-content/themes/twentytwenty/404.php’, 1, ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’, ‘j?kK÷`x…x\Zd,mAi’, ‘?a>ˉêbG_dúEh)pàFq7?f3!R??(YpO’, ”, 0, ‘?’),

Thank You for your assistance