Apostrophe in Middle Name in Advisory Comm. gives error

Project:RUetd
Version:2.2.0
Component:Code
Category:bug report
Priority:normal
Assigned:chadmills
Status:closed
Description

When entering info in the ETD Info screen before submitting an ETD, I entered an apostrophe in the Middle Name field in the Chair field in the Advisory Committee section of the screen. I received the following error: "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 'Guy'' at line 3. I had entered Good in the First Name, Ol' in the Middle Name, and Guy in the Surname. Removing the apostrophe allowed the entry to work.

Comments

#1

Status:active» test

Fixed in 'process_steps.php'

#2

Status:test» active

Still gets an error: "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 'd' AND chAdvisorMN='Ol'd' AND chAdvisorLN='Gu'y'' at line 3".
I entered for chair: FirstName=Goo'd, Middle=Ol'd, Surname=Gu'y

If I enter Good Ol' Guy as in the entry when I got the first error, I get the same error as the first time.

#3

Status:active» test

Try again, needed to push changes to 'library/functions.php' as well.

#4

Status:test» fixed

The problem is fixed. I tried the original name with the apostrophe in Middle field. I also tried an apostrophe in the First, and Surname. Also tested all 3 names, with period in the beginning, middle and end of the names and with space and dash in the name. All worked.

#5

Status:fixed» closed

Back to top