Tabs not showing after migration from another URL

Hi @ryharri,

In that other thread, did you see Kevin’s instructions on searching and replacing the URLs with a plugin? That is how you would resolve the issue.

Thank you,
-Tracy

Hi @ryharri,

Just checking in.

Please let us know if you still need help with this issue.

Thank you,
-Tracy

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!

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 @ryharri,

Your database is in the same state it was before the migration and you’re still not able to see the tabs?

Let me know.

Thank you,
Kevin.

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

Ryan,

I don’t know what’s going on. Do you have access to your database? Are you able to check if you have entries in your postmeta table for the meta key yikes_woo_products_tabs?

The query would look something like this:
SELECT COUNT(*) FROM wp_postmeta WHERE meta_key = 'yikes_woo_products_tabs';

Let me know,
Kevin.

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

Ryan

Okay good! Can you send me one example of a full row?

e.g. SELECT * FROM wp_flqz_postmeta WHERE meta_key = 'yikes_woo_products_tabs' LIMIT 1;

Also, is your current website accessible? Would I be able to access one of your products?

Thank you,
Kevin.

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

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:””;}}’);

Hey Ryan,

I’m wondering if there’s an encoding issue because I’m seeing characters like a€?5129a€?.

Do you know if your two databases (the original one and the one you switched to) are using the same encoding? What’s the encoding for both?

Let me know.

Thank you,
Kevin.

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.

Yeah, charset – were they both UTF-8 Unicode?

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!

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;