PDA

View Full Version : No slashes added on merge user query?


Crazy Squirrel
Thu 19th Jun '03, 3:37pm
The single quote in the nick Ya'an was sent to sql without adding slashes when i went to merge him into another user :o I've renamed the account to get round it but it could do with fixing imo
Database error in vBulletin 3.0.0 Beta 3:

Invalid SQL: UPDATE pmtext
SET touserarray = REPLACE(touserarray, 'i:348;s:5:"Ya'an";','i:1048;s:7:"Me.$uck";')

mysql error: You have an error in your SQL syntax near 'an";','i:1048;s:7:"Me.$uck";')
' at line 2

mysql error number: 1064

Date: Thursday 19th of June 2003 08:32:52 PM
Script: http://forums.utassault.net/admincp/user.php
Referer: http://forums.utassault.net/admincp/user.php