I get this error(FIXED)

[cpmike]

Hi I use vBulletin and Photopost. Now i have a user that uses a ' in his name and i get a error message. What can i do about that? I edit the user name in the vBulletin AdminCP and took out he ‘ but the errors are still there, t think the name is now stored in de DB?

An error was encountered during execution of the query:

SELECT userid,username,email,password,usergroupid,timezoneoffset,salt,membergroupids FROM user WHERE username='Charly's Extreme Diving'

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Extreme Diving'' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[cpmike]

Which script is causing this error? I now have 10.000 mails every hour.

Have set $debug=0 in my config-inc.php file but the mails keep coming ???

HELP !!

[WB]

Check to see what the debug setting is set to in the Global Options in the admin interface.

If it is still showing 'email errors' try changing the setting there to see if that helps.

[Michael P]

In forums/vb3.php; you could add:

Content visible to verified customers only.

above line 21, although it is not clear to me why the tick isn't taken care of already. I'll have to do some checking.

[cpmike]

Before I have seen your suggestion I have done the following and the errors are gone.

First I have chanced the user name of the member and take out the ' (Charly s Extreme Diving)

then

On the PhotoPost Database Administration page > Check here to resync photo/comments usernames/update comments counts.