Errors when exporting to ProQuest

Project:RUetd
Version:2.2.3
Component:Code
Category:bug report
Priority:normal
Assigned:martyb
Status:closed
Description

When I exported October 2015 ETDs to ProQuest, I got the following errors. Neither ETD was sent to ProQuest.

On the ETD by author Natalia A Kouraeva:
An error has occured while trying to tally page count for the file ETD-2015-6655.pdf.
Please contact technical support.

On the ETD by author Xiang Yu:
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 Republic of China' ORDER BY printable_name' at line 3

Comments

#1

The issue for author Xiang Yu the user supplied there county of origin as "People's Republic of China." The single apostrophe broke the export query on the database. I escaped the query and added an entry for the "People's Republic of China" into the database.

I will work on the PDF issue now.

#2

Assigned to:chadmills» martyb
Status:active» test

For the ETD by Natalia A Kouraeva I manually added the page count to the "papers" table. This should bypass the page counting on export. The PDF for this submission is causing a problem and should be reviewed when time allows.

#3

Status:test» fixed

I was able to export both problem ETDs to ProQuest.

#4

Status:fixed» closed

Back to top