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