Unknown column 'name' in 'field list' Grrrr

You are here

Haruo's picture

I got the minimal (hymn number and first line) spreadsheet ready to upload to ESPINTND, but it only shows hymn number 1, and this error message:

File successfully uploaded to /tmp/ESPINTND all first lines.xml
Hymnal contents successfully cleared.
The script returns:

Error inserting into hymnary.hymnTune on row 2: Unknown column 'name' in 'field list'
Table 'hymnary.group' doesn't exist at /srv/hymnary.org/scripts/import/backup2db.pl line 1243.
Connecting to database...
Parsing XML file...
Inserting page data for hymn number 1

I downloaded the XML spreadsheet that was already in place for the first forty or so hymns, and I didn't add anything until somewhere around line 40, and there is no occurrence of "name" in the second row, so I have no idea what this message is talking about.

It looks like you are using an ad-blocker. Ad revenue helps keep us running. Please consider white-listing Hymnary.org or subscribing to eliminate ads entirely and help support Hymnary.org.