Unable to update table

[oscosc]

Hi all,

I was trying to add new addition information. After I filled out the Add Work/Edition form for "Don't cry, little girl, don't cry" and tried to add it, I received an error message saying "unable to update table". Can you please help? Thanks.

Cheers,

Ken Sambuchi

[MandyShaw]

You might need to double up the quotes - don''t cry - I'm pretty sure I have fixed the same problem that way. They don't come out doubled in the end result.

[bobnotts]

Hi Ken

Thanks very much for wanting to contribute. Unfortunately, this is a bug in our form. The techies Max and Carlos will be able to tell you more if you desperately want to know The note at the top of the form gives the instructions for overcoming this issue:

(Technical note: If you use an apostrophe, you must use a backslash before it, or you will receive an error message and your score will not have been submitted successfully.)

Hope this helps. If you're still having problems, pop a reply on here.

Robert

[MandyShaw]

That's it, sorry Robert, I misremembered.

[bobnotts]

No problem Mandy

[oscosc]

Thaanks for your reply, Robert.

I tried the backslash without success. Is there just one backslash? Do I use a backslash in place of the apostrophe? Or, are there spaces between the backslash and apostrophe? I even tried entering the title without any punctuation at all and it didn't work. Are the apostrophes in the PDF and MIDI files causing a problem?

Cheers,
Ken

[bobnotts]

Are the apostrophes in the PDF and MIDI files causing a problem?

Most likely, yes. Please add the details of the work and edition here and I will do the necessary work for you. Do not submit the add score form again.

[oscosc]

Please add the details of the work and edition here and I will do the necessary work for you:

Title: Don't cry, little girl, don't cry
Composer: Maceo Pinkard
Editor: Ken Sambuchi
Email: kensambuchi@yahoo.com
Genre: Secular
Subgenre: Barbershops
Number of voices: 3
Voicing: TBB
Year: 1918
Language: English
Composer's time period: Early 20th century
Orchestration: a cappella
Sheet music format: PDF
Sheet music location: http://www.cpdl.org/wiki/images/c/c8/Pi ... t.mscz.pdf
Page size: Letter
Number of pages: 1
Size of file: 29 KB
Midi file: http://www.cpdl.org/wiki/images/5/52/Pi ... t.mscz.mid
Notes about edition: Arranged by Ken Sambuchi and C. J. Spatafora from "The Old Songs Chorus" Copyright assigned to CPDL
External web link: http://webapp1.dlib.indiana.edu/inharmo ... ryNumber=1
Email address: kensambuchi@yahoo.com

Thanks, Robert for your help. Will I need to add the Wiki code and Works entry code afterwards? Let me know what else I need to do.

Cheers,
Ken

[choralia]

The problem was related to apostrophes in the filename, which were replaced by the browser with undesired "%xx" sequences: Pink-don%27t.mscz.pdf had to be corrected as Pink-don't.mscz.pdf, and Pink-don%27t.mscz.mid had to be corrected as Pink-don%27t.mscz.mid.

I wrote a specific script to normalize filenames and replace any "%xx" sequences, however it seems that the "%27" sequence is not normalized automatically (wonder why). I'll probably have to add this sequence as an exception to be treated as a specific case.

Max

[choralia]

it seems that the "%27" sequence is not normalized automatically

I found this case described in literature. The filename normalization script should be able to correctly normalize filenames that include apostrophes, from now on.

Max

[Ross Jallo]

Hello!

Whilst trying to upload two selections today, I was met with the same "unable to update table" message. Neither filename has an apostrophe (though one has a comma -- the other doesn't). Is this a related bug, or something else? I didn't click "submit" again for fear of an unwanted duplicate.

Thanks,
Ross

[choralia]

Could you please provide details about the information you're trying to enter? Please note that only apostrophes in the filename are automatically corrected; apostrophes in other fields (e.g., edition information) still need a backslash for being treated correctly.

Max

[Ross Jallo]

Could you please provide details about the information you're trying to enter? Please note that only apostrophes in the filename are automatically corrected; apostrophes in other fields (e.g., edition information) still need a backslash for being treated correctly.

Max

Here's the information I tried to enter (except my email address, which has no apostrophes):
Title of work: Haec est voluntas patris
Name of composer: Philipp Dulichius
Name of editor/contributor: Ross Jallo
Email of editor/contributor: [redacted]
Publish? No
Genre: Sacred
Subgenre: Motets
Voices 7
Voicing: SSAATTB
Year of first publ.: 1607
Language: Latin, German
Time period: Renaissance
Orchestration: A cappella
Notes: No. 24 from the composer's collection ''Centuriae'', Part I, published at Stettin in 1607.
Sheet Music Format: PDF
Sheet Music Location: http://www.cpdl.org/wiki/images/4/4c/Du ... patris.pdf
Page Size: Letter
# Pages: 6
Size of PDF: 82kb
MIDI Location: http://www.cpdl.org/wiki/images/5/55/Du ... patris.mid
Edition Notes: Original pitch; note values halved.
Copyright: Public Domain
Email: [redacted]

====================================
Title of work: Tibi laus, tibi gloria
Name of composer: Hans Leo Hassler
Name of editor/contributor: Ross Jallo
Email of editor/contributor: [redacted]
Publish? No
Genre: Sacred
Subgenre: Motets
Voices 8
Voicing: SSAT.ATBB
Year of first publ.: 1601
Language: Latin
Time period: Renaissance
Orchestration: A cappella
Notes: This motet for Trinity Sunday comes from Hassler's ''Cantiones sacrae'' (Nuremberg, 1601/1612); it is No. 43 in the 1601 edition and No. 50 in the 1612 edition.
Sheet Music Format: PDF
Sheet Music Location: http://www.cpdl.org/wiki/images/6/6a/Ha ... gloria.pdf
Page Size: Letter
# Pages: 11
Size of PDF: 90kb
MIDI Location: http://www.cpdl.org/wiki/images/f/f3/Ha ... gloria.mid
Music Notation Format: Finale 2011
Edition Notes: Original pitch; note values halved.
Copyright: Public Domain
Email: [redacted]

[choralia]

composer's collection ''Centuriae''

Hassler's ''Cantiones sacrae''

There are six apostrophes in the above fragments of text (one in each saxon genitive, plus all double quotes that are actually pairs of apostrophes). Are you sure that you applied a backslash before all of them?

Max

[Ross Jallo]

Ah, that fixed it. But it's odd -- I've had apostrophes in edition information before, and never needed backslashes then. Oh well. Thank you!