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', '[email protected]', 0, NOW())' at line 1 INSERT INTO user (unityid, affiliationid, firstname, lastname, email, emailnotices, lastupdated) VALUES ('XXXXXXX', 2, 'XXXXXXXX', 'O'Problem', '[email protected]', 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
