Apostrophe in abstract causes a MySQL error

Project:RUcore Workflow Management System (WMS)
Version:6.2
Component:Faculty Deposit
Category:bug report
Priority:critical
Assigned:rmarker
Status:closed
Description

Enter the following abstract and the deposit fails. Remove the apostrophe and the item is deposited successfully.

SEBS - Animal Science, Rutgers University author articles Peer reviewed 2012 Taylor & Francis Institutional repositories manage and disseminate a University's scholarly output

Comments

#1

Priority:normal» critical

#2

Status:active» test

fixed, please test

#3

Assigned to:jgeng» ananthan
Status:test» fixed

Tested in rep-devel and able to successfully ingest a record with an apostrophe in both the abstract and title elements.

#4

Assigned to:ananthan» jgeng
Status:fixed» active

correction: it worked from the WMS to Fedora. It did NOT work from Faculty Deposit to the WMS.
Although the screen message said it was successfully submitted, the record did not show up in the WMS.
There is an apostrophe in the title, which you can see in the error message was not a problem. However, there is a statement at the end of the error message "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" and then it shows the "apostrophe-s" in the ABSTRACT that caused the problem.

Error message:
Error executing query: insert into MD_XmlDoc values (4483, 4602, ' Text Marker Rhonda Technical and Automated Services, Rutgers University author Other Publication 2011 This is a test to see if it's possible to send a record all the way through to Fedora, or if it doesn't succeed and kicks out as an error. English application/pdf <a href="http://hdl.rutgers.edu/1782.1/rep-devel.rucore30001900001.Manuscript.000004602" title="http://hdl.rutgers.edu/1782.1/rep-devel.rucore30001900001.Manuscript.000004602">http://hdl.rutgers.edu/1782.1/rep-devel.rucore30001900001.Manuscript.000...</a> Manuscript Marker Rhonda Copyright holder Copyright for scholarly resources published in RUcore is retained by the copyright holder. By virtue of its appearance in this open access medium, you are free to use this resource, with proper attribution, in educational and other non-commercial settings. Other uses, such as reproduction or republication, may require the permission of the copyright holder. Copyright protected Open Permission or license Permission or license License Sole author license v. 1 I hereby grant to Rutgers, The State University of New Jersey (Rutgers) the non-exclusive right to retain, reproduce, and distribute the deposited work (Work) in whole or in part, in and from its electronic format, without fee. This agreement does not represent a transfer of copyright to Rutgers.Rutgers may make and keep more than one copy of the Work for purposes of security, backup, preservation, and access and may migrate the Work to any medium or format for the purpose of preservation and access in the future. Rutgers will not make any alteration, other than as allowed by this agreement, to the Work.I represent and warrant to Rutgers that the Work is my original work. I also represent that the Work does not, to the best of my knowledge, infringe or violate any rights of others.I further represent and warrant that I have obtained all necessary rights to permit Rutgers to reproduce and distribute the Work and that any third-party owned content is clearly identified and acknowledged within the Work.By granting this license, I acknowledge that I have read and agreed to the terms of this agreement and all related RUcore and Rutgers policies. ').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 's possible to send a record all the way through to Fedora, or if it doesn't succ' at line 1

#5

Status:active» test

fixed and please test.

#6

Assigned to:jgeng» rmarker
Status:test» fixed

Able to create record in Faculty Deposit, upload to WMS, and ingest to Fedora. Record had two apostrophes in the abstract (and one in the title, just to be difficult). All successfully completed.

#7

Status:fixed» closed

Back to top