{nickname}'s Gets a backslash added

It looks like all of my {nickname}'s are getting a backslash added.

So when you go to a photo album, it will say Album: bob\'s photos. Same for videos too.

Anyone run into this? Any ideas for me to try?

Go into admin->Tools then phpinfo

Verify your server has the proper magic quotes settings.

Backslashes in front of single quotes when it is not expected usually means one of those settings is wrong.

Yes, somehow the \ was added to your admin settings.  Check Admin>Modules>Photos>Settings and make sure the Default profile name says: {nickname}'s photos  and not {nickname}\'s photos.

So I enabled magic_quotes_gpc in php.ini but the slash is still there.

The settings have the proper text - {nickname}'s photos

hmmmm

So are you saying magic quotes gpc was off and you turned it on?

If so, now create a new test account and see if it happens with new accounts. It might be that the slashes just need to be removed. But you first need to verify the problem that caused it has been corrected.

Yes, i have magic_quotes_gpc off and then turned it on.

A new user account does not have the /'s problem.

How can I update the existing accounts?

Do you like databases?

I am not MR. mySQL but I know my way around them. I have tried to find the table that has the /'s (if there is one) but I havent found it yet.

You should find most of them in the table sys_albums

Yea, it looks like they are in there.

Now if only I knew how to do queries... something like "Alter" \'s "From" Caption In sys_albums...

Yea, but because the \ is an escape character for mysql, it will complicate the query. I'll see if i can come up with something.

Ok. This should work.

update `sys_albums` set `Caption` = replace(`Caption`, "\\'s", "'s")

Thank you Deano, that seems to have worked and I just adapted it to alter the Description field too.