Bug #18322: Can't add words with "'" in my PEAR account userinfo

From: floripa@php.net Operating system: FreeBSD 4.6-STABLE PHP version: 4.2.1 PHP Bug Type: PEAR related Bug description: Can't add words with "'" in my PEAR account userinfo I tried to edit my PEAR account and got this error. Nothing that an "addslashes()" don't fix. ;) Error: DB Error: syntax error: UPDATE users SET name = 'Antônio Carlos Venâncio Júnior', email = 'floripa@organiKa.com.br', homepage = '', userinfo = '"Can't buy what I want because its FREE!" Pearl Jam', wishlist = '', showemail = '1', admin = '0' WHERE handle = 'antonio' [nativecode=1064 ** You have an error in your SQL syntax near 't buy what I want because its FREE!" Pearl Jam', wishlist = '', showemail = '1'' at line 1] -- Edit bug report at http://bugs.php.net/?id=18322&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18322&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18322&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18322&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18322&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18322&r=support Expected behavior: http://bugs.php.net/fix.php?id=18322&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18322&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18322&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18322&r=globals