Code showing up on site

What codes showed up on your site?

?
a€?
a€?
a€?

Those are a few I’m getting

I found a query I can run in mysql database that will find and replace the code but when I ran it I got the following:

SQL query:

UPDATE wp_posts SET post_content = REPLACE( post_content, ‘a€?’, ‘“’ ) ;

MySQL said: Documentation
#1146 – Table ‘example.com.wp_posts’ doesn’t exist

The query came from this site:
https://www.wprecipes.com/easily-remove-weird-characters-from-your-wordpress-database

@scatmanat,

The SQL code looks legit. Though backup the website before running the query, just to be on the safe side.

John,

My site is newly backed up and I ran the query and as you can see above it didn’t work. Suggestions as to why it’s saying my site doesn’t exist?

@scatmanat,

P.s. I’ve seen such issue before. In this case you should also check the comments and all the content you’ve or the public generated.

Most probably this issue happened because of the encoding used by the backup or restore tool you used.

John Bonello

John,

I have almost no knowledge of what I’m doing here so I’m lost when you suggest looking at my comments. What do they have to do with the query not running because it can’t find my database?

The error you are getting says that the table wp_posts in the database adventuresofscatman_com_3 does not exist.

Is this the correct database name?

P.s. for security reasons I wouldn’t mention any database names here. Drop me an email on [email address removed] and we will try to sort it out. Let me know what you are using to connect to MySQL, if phpMyAdmin or so.

John

john,

thanks. I edited my post with the database name, can you do the same so it’s not on here.

I’ll be in touch if my next attempt fails.

grrrr… unfortunately cannot edit forum posts after some time…