ryharri

Hi Kevin,

I’m honestly totally unsure how this happened. I’ve tried replicating the issue by exporting and importing the old (clean) database a number of times with different configurations, just for my own sanity, but I can’t reproduce the issue. It’s a shame I didn’t realise the problem straight away otherwise I could have just done the import again weeks ago and I’m sure it would have been successful. Nevertheless, up and running now with your help.

Thanks again!

Hi Kevin, just to let you know I’ve sorted it!

I replaced the funky characters like you said around the numbers, then I removed ? characters which had appeared for some reason, then I realised you were right about the ‘fancy’ quotes instead of normal ones, but I realised they should have actually been there. For some reason, fancy quotes were in the original database so I added them back using find and replace for all 200+ products and it’s worked!

Thanks very much for all the help!

Best wishes,
Ryan

Hi Kevin, thanks for the help that’s all really useful.

Just changing the bit we talked about isn’t enough to fix the problem, but I found out that if I copy the whole line from the old database and paste it over the top of the corrupted one, that single products tabs start to work again. I then found out that there are a couple more dodgy characters in each entry.

Is it the case that the new db has to exactly match the old one for the tabs to show up?

Here’s a picture of what I mean https://pasteboard.co/HsIdn3L.png

You also asked if I’ve noticed if there’s any other areas of the site breaking.. Not that I’ve noticed, everything seems fine. Though I’m a little nervous now ??

EDIT: I’ve combed through the database and for some bizarre reason the auto increment is still there.. it’s just moved to the bottom of the file. After some testing I’ve found the primary key is still auto incrementing and everything’s fine on that front.

Just those wacky numbers to sort out now. If you have any ideas I’d be really really grateful.

Thanks!

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

Thanks Kevin,
The data I posted with the funky numbers actually also looks like that in the new database! So I guess that’s the problem? Not sure about the quotes though – they both look exactly the same on my end?
Do you have any ideas on how I’d go about fixing this?

Thanks again!
Ryan

Hi Kevin,

Curiosity got the better of me and I travelled in to take a look at the older database. They both appear to be encoded exactly the same, but those weird characters you spotted are replaced with the proper numbers.

One difference is something to do with auto increment, which I don’t really understand. Maybe this means something to you?

Here’s the original:
CREATE TABLE wp_flqz_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
meta_key varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
meta_value longtext COLLATE utf8mb4_unicode_520_ci,
PRIMARY KEY (meta_id),
KEY post_id (post_id),
KEY meta_key (meta_key(191))
) ENGINE=InnoDB AUTO_INCREMENT=21651 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=21651 ;

And here’s the new one with the messed up numbers:
CREATE TABLE wp_flqz_postmeta (
meta_id bigint(20) UNSIGNED NOT NULL,
post_id bigint(20) UNSIGNED NOT NULL DEFAULT ‘0’,
meta_key varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
meta_value longtext COLLATE utf8mb4_unicode_520_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

Unfortunately I don’t have access to the original database at the minute – it’s saved on another computer somewhere else that I’ll check tomorrow.

Assuming that it is a different encoding and those weird characters that you found aren’t there in the old backup, what’s my best bet? Can I replace the yikes_woo_products_tabs stuff and leave everything else the same?

Thanks again!

Hmm good question.

I’m not too sure what you mean by the encoding or how to find out… or is that the same as the charset? (such as UTF-8 Unicode (utf8)) which is what the new database says?

Thanks for the help.

Hi,

the website is accessible yeah – here’s one of the products: https://www.ruggeddisplays.co/product/broadcast-pro-19led/

Is this the code you’re after?

INSERT INTO wp_flqz_postmeta VALUES (6387, 4888, ‘yikes_woo_products_tabs’, ‘a:3:{i:0;a:3:{s:5:”title”;s:10:”Tech Specs”;s:2:”id”;s:10:”tech-specs”;s:7:”content”;s:939:”<table id=”products”><tbody><tr><th>Specification</th><th>Value</th></tr><tr><td>Screen Size:</td><td>19.5</td></tr><tr><td>Resolution:</td><td>1920 x 1080</td></tr><tr><td>Brightness:</td><td>250cd/m2</td></tr><tr><td>Contrast Ratio:</td><td>3000:1</td></tr><tr><td>Response Time:</td><td>5ms</td></tr><tr><td>Inputs:</td><td>VGA</td></tr><tr><td>Power Supply:</td><td>External</td></tr><tr><td>Power Input:</td><td>12vDC</td></tr><tr><td>Operating Temp Range:</td><td>0 – 50?°C</td></tr><tr><td>Case Construction:</td><td>Plastic Cased</td></tr><tr><td>Case Colour:</td><td>Black</td></tr><tr><td>VESA Mount:</td><td>Yes</td></tr><tr><td>Dimensions</td><td>475.70×298.96×38.90mm</td></tr><tr><td>Weight(net):</td><td>3.30 kg</td></tr><tr><td>Glass Protection:</td><td>No</td></tr><tr><td>Integrated Media Player:</td><td>No</td></tr><tr><td>Sunlight Viewable:</td><td>No</td></tr><tr><td>Touch Screen</td><td>No</td></tr></tbody></table>”;}i:1;a:3:{s:5:”title”;s:9:”Downloads”;s:2:”id”;s:9:”downloads”;s:7:”content”;s:91:”<p>[download1]</p><p>[email-download download_id=a€?5325a€? contact_form_id=a€?5129a€?]</p>”;}i:2;a:3:{s:5:”title”;s:5:”Video”;s:2:”id”;s:5:”video”;s:7:”content”;s:0:””;}}’);

Hi, yes, there are 211 results when I search for yikes_woo_products_tabs inside wp_flqz_postmeta.

Ryan

It’s not in exactly the same state unfortunately no. Quite a few extra pages have been added since and some changes to existing pages have been made. Having said that the products and the product tabs haven’t been touched.

Thanks for the help!
Ryan

Hi Tracy, I’ve uploaded all the files and database from the new domain to the old one, but the product tabs are still not appearing ?? What should I try now?

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

Hi Tracy, thanks very much for the help! I’m actually just on holiday at the minute so I’ll get back to you in a week. Thanks again!

I did not unfortunately. If you find one let me know!