MyBB Community Forums

Hi folks,

I am trying to make a member an admin at http://www.waterfordonline.net/index.php but when I try, I get the following:

Quote:mySQL error: 1064
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 'll keep a welcome [img]http://waterfordcity.mysite.wanadoo-mem
Query: UPDATE mybb_users SET username='Shaun', email='[email protected]', usergroup='4', additionalgroups='4', usertitle='', avatar='http://www.upthedeise.org/images/avatars/shaun.gif', website='http://www.brendan-sean-mcguire.freeservers.com', icq='0', aim='', yahoo='', msn='', birthday='21-5-', allownotices='yes', hideemail='no', emailnotify='no', invisible='no', style='2', timezone='0', receivepms='yes', pmpopup='no', pmnotify='no', signature='We'll keep a welcome ', postnum='158' WHERE uid='10'

Can anyone tell me what I need to do in order to fix this?

Thanks.

in admin/users.php, find all instances of:

		"signature" => $mybb->input['signature'],

and replace with:

		"signature" => addslashes($mybb->input['signature']),

(There should be at least 2)

Thanks mate.

No problem.