I received the error message attached below from our VCL when it tried
to add a new user to the database. It appears that it tripped over an
apostrophe (') character in the last name, which caused a syntax error
in the SQL command. When I manually entered the SQL command using a
backslash in front of the extra apostrophe, it succeeded.


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 'Problem', 
'xx...@email.unc.edu', 0, NOW())' at line 1
INSERT INTO user (unityid, affiliationid, firstname, lastname, email, 
emailnotices, lastupdated) VALUES ('XXXXXXX', 2, 'XXXXXXXX', 'O'Problem', 
'xxx...@email.unc.edu', 0, NOW())
ERROR(101): General MySQL error


I put XXXX's to replace the real person's name and email, and
substituted the real last name with O'Problem, which shows the issue
with the (') character in the last name.

-- 
Mike Waldron
Systems Specialist
ITS Research Computing
University of North Carolina at Chapel Hill
CB #3420, ITS Manning, Rm 2509
Office: 919-962-9778

Reply via email to