simon1970

If this helps anyone, here is the query I used to replace a substring with another string in phpMyAdmin. The meta_key is the name I gave to the custom field (dimensions):

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, ’60 x ‘, ‘60.0 x ‘) WHERE meta_key = ‘dimensions’;

The mistake I had made was in the format of the numbers, with the default format having 1 decimal place. The decimal was missing from every instance with the number 60, so the query adds the ‘.0′ to every instance of ’60’ within the table.

I have now found the data I was looking for by searching the entire database for a specific string. The data was stored in the wp_postmeta table with a meta_key of ‘dimensions’, which is the name I gave to the custom field when I created it.

Thank you, I have now found the data I was looking for by searching the entire database for a specific string. The data was stored in the wp_postmeta table with a meta_key of ‘dimensions’.

@serafinnyc Hi Stef, thank you for your reply. I just realised that the Product Additional Information on my website is a field that I added using a plugin called Advanced Custom Fields. This must be why I can’t find the data in the database. Would you happen to know where I could find the data for that plugin in the database?

Thanks.

@threadi Thank you, I have just asked the question in the plugin/woocommerce section.

I believe I have resolved the issue. The Blocksy theme has its own built-in customization settings exporter that can be found under Customize > General > Manage Options >

Using this export method instead of the plugin resolved the issue.

My apologies, I think it might be something to do with a caching plugin…

Hello,

I am the user who first posted this question. I just tested for the problem again and notice that it has now been resolved, however I have discovered a new problem. When a user edits the title or description of a photo, the new changes do not save when the Malicious File Upload is checked in the Wordfence Firewall. I unchecked the setting and the photo title and description changes would then save as normal.

Any ideas why this is happening? I would like my users to be able to edit the titles of their photos.

Thanks,

Simon

OK, thank you ??