-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Mike,

Thanks for the bug report.  I'll create a Jira issue for it and try to get it 
fixed soon.

Josh

On Wednesday June 10, 2009, Mike Waldron wrote:
> 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.
- -- 
- -------------------------------
Josh Thompson
Systems Programmer
Virtual Computing Lab (VCL)
North Carolina State University

josh_thomp...@ncsu.edu
919-515-5323

my GPG/PGP key can be found at pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFKL7bEV/LQcNdtPQMRAiseAJ4wtnjIfa4Adm1l8uXOOaq+85MtfwCfTIbh
sCS9W2UXzT0OwlUBwwYgBys=
=NfLz
-----END PGP SIGNATURE-----

Reply via email to