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