SQL update table post_meta

slecouster · March 2019

Hello,

Of course, you don't support the sql report.

But my issue is linked to the theme

I have made this request :

UPDATE `pre_postmeta` SET `meta_value`=REPLACE(`meta_value`, "texte1", "texte2") WHERE `meta_value` LIKE "%texte1%"

Now my page is blank in the front and the bo

I use the betheme muffin builder

In the database, I already have my content.

I made a backup before, and when I copy/past the last content (of this record), it doesn't change anything.

I have 22 pages to re-create !!

Do you have an idea what could happen ?

For information:

theses pages are translation for wpml, but I am not sure it came from this

If you can help , it could be great.

Thanks

Pablo · March 2019

Hi,
If you made some changes in the database, then our hands are tied.
We always tell, not to touch anything inside the database.

All we can suggest is to contact the hosting provider and asking him about backup before making that SQL Query.
Thanks

slecouster · March 2019

OK. It's good.

I found the issue.

you count the number of characters before the text

s:10:textetexte

s:11:textetexte2

And it works manually (via phpmysql)

But when we have to make batch modification, it's too long to do it in the back-office.

Pablo · March 2019

I'm glad that you solved it out.

But, as I said, we suggest not to edit anything in the database.

Thanks

slecouster · March 2019

Promise.

I'll take care next time

Thanks.

SQL update table post_meta

Comments

This website uses cookies