Support Center Visit Demo License manager Buy @ envato

SQL update table post_meta

slecousterslecouster
in Other
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

Comments

  • PabloPablo
    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
    Learn more: Video Tutorials | How To | FAQ Vote on what comes next
  • slecousterslecouster
    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.
  • PabloPablo
    I'm glad that you solved it out.
    But, as I said, we suggest not to edit anything in the database.
    Thanks
    Learn more: Video Tutorials | How To | FAQ Vote on what comes next
  • slecousterslecouster
    Promise.
    I'll take care next time
    Thanks.
Sign In or Register to comment.