Print Page | Close Window

Error when adding album with Greek track titles

Printed From: Progarchives.com
Category: Site News, Newbies, Help and Improvements
Forum Name: Report bugs here
Forum Description: Help us improve the site from a tech standpoint
URL: http://www.progarchives.com/forum/forum_posts.asp?TID=121064
Printed Date: April 19 2024 at 08:56
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com


Topic: Error when adding album with Greek track titles
Posted By: CassandraLeo
Subject: Error when adding album with Greek track titles
Date Posted: September 28 2019 at 14:07
I’m trying to add data for the Blut aus Nord album Deus salutis meæ, which features three song titles written in the ancient Greek alphabet. When I attempt to submit the album, I get the following error:

Quote Microsoft SQL Server Native Client 11.0 error ’80040e57’

String or binary data would be truncated.

/Post_submittitle.asp, line 135

I suspect the database software can’t deal with the unusual character encoding (some of the characters in here are only even used in ancient Greek – the modern Greek alphabet doesn’t use them). This is the correct track listing:

Quote 1. δημιουργός (1:20)
2. Chorea Macchabeorum (4:12)
3. Impius (4:07)
4. γνῶσις (1:27)
5. Apostasis (5:28)
6. Abisme (2:44)
7. Revelatio (4:19)
8. ἡσυχασμός (1:05)
9. Ex tenebrae lucis (5:09)
10. Métanoïa (3:52)

Total Time 33:43

And I’ve written the following release information:

Quote Released October 28, 2017, on Debemur Morti Productions.

Every song title on this album is derived from a foreign language, though many have direct English-language descendants. Five titles are ancient Greek (of which three, the tracks that serve as interludes on the album, are actually written in the Greek alphabet, while the other two are written in the Latin alphabet), four are Latin, and one is Old/Middle French. Tentative translations and explanations (which may benefit from the attentions of people with deeper knowledge of these languages):

1. δημιουργός (dimiourgós) - Ancient Greek for “creator”. The English word “demiurge” is a direct linguistic descendant of this word.
2. Chorea Macchabeorum - Appears to be Latin meaning either “Macabre Dance” (i.e., the Danse Macabre, the Dance of Death) or “Dance of the Maccabees”.
3. Impius - Latin term meaning “wicked”, “accursed”, “disloyal”, “unpatriotic”, or “impious”, the last of which is a direct linguistic descendant of this word.
4. γνῶσις (gnósis) - ancient Greek for “knowledge”. Again, the English word “gnosis” is a direct linguistic descendant of this word.
5. Apostasis - Greek word (ἀπόστασις) that could have several meanings, including “distance”, “length”, “duration”, “departure”, “revolt”, or “apostasy” (again, the latter of these is its direct linguistic descendant). Given the other titles on the album, “apostasy” is likely the band’s intended meaning.
6. Abisme - Old French for “hell"; Middle French for “abyss”. (There are also Catalan, Portuguese, and Spanish words with this spelling that are linguistically related to “abyss”, but as the band is French, it’s likeliest they intended it to be Old/Middle French.)
7. Revelatio - Latin term meaning “revelation” (again, its linguistic descendant).
8. ἡσυχασμός (hesychasmós) - Ancient Greek for “quietism”. In addition, the religious term “hesychasm”, used for a form of meditation in Eastern Orthodox Christianity, is directly descended from this word.
9. Ex tenebrae lucis - Latin for “From the Darkness, Light”, or “Out of Darkness, Light”, though the grammar is apparently not wholly correct.
10. Métanoïa - ancient Greek word (μετᾰ́νοιᾰ) meaning “repentance” or “afterthought”. The English word “metanoia”, meaning a fundamental change of mind or a spiritual conversion, is derived from this word.

The album is tagged as Deus salutis meae on the band’s official Bandcamp site, but the description and album cover both spell the title as Deus salutis meæ (though it is written in all caps on the cover, as DEUS SALUTIS MEÆ). The ligature æ was not used in classical Latin nor is it currently in common usage, but it was used in medieval and early modern Latin writings. Also notable is that “meae” is a feminine pronoun (it could be either the genitive or dative singular, or the nominative or vocative plural).

The credits for this album are not clear; Metal Archives and Discogs list different performers apart from Vindsval, who is listed on both websites.
(This is very similar to the Last.fm wiki information for the album… but I wrote that, too, so that’s hopefully not a problem. I’ve added italics to the album title in the quote above, but I didn’t actually attempt to include those when submitting the album – I have no idea if the database software will accept that, either.)

Due to the ambiguous credit information, I just listed “- Unknown / unknown” as the credits (this is one of maybe two or three Blut aus Nord albums that I don’t own at least one physical copy of, but they seldom, if ever, list musicians in the packaging anyway). If the issue with Unicode input isn’t likely to be fixed anytime soon, perhaps someone on the administrative staff here with direct access to the database can add it. I’d prefer not to just convert the Greek characters to the Roman alphabet, since there’s an actual artistic purpose for their usage (differentiating the ambient interlude tracks from the metal tracks). A high-quality version of the album art is available at https://lastfm-img2.akamaized.net/i/u/_/fa7f4e7f80f027bd2fbe7d23a48ce024.png" rel="nofollow - https://lastfm-img2.akamaized.net/i/u/_/fa7f4e7f80f027bd2fbe7d23a48ce024.png .

Thanks in advance for any help you can provide.

ETA: The issue may actually be with Unicode track titles in general; I can't add their latest album, either, which has a song titled "Haallucinählia". Or is it a problem with my account?
< x="0" y="0" width="99999" height="99999" id="hc_extension_off">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black_back">
< x="0" y="0" width="99999" height="99999" id="hc_extension_off">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black_back"> < x="0" y="0" width="99999" height="99999" id="hc_extension_off">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black_back">

-------------
http://www.last.fm/user/Cassandra-Leo" rel="nofollow - last.fm · http://www.soundcloud.com/CassandraLeo" rel="nofollow - soundcloud



Replies:
Posted By: Quinino
Date Posted: September 28 2019 at 15:07
Just tried updating the exact track-list you provided in another album page and found absolutely no error.
Thus the problem seems not to be in the DB software but somewhere on your side ... which I'm afraid you'll have to diagnose by yourself  - try searching online for the SQL error code you receive and follow from there.

(Just a thought: Aaron, are you already logged-in when you try to do the album addition? - sometimes the simplest explanation is most easily overlooked)


Posted By: CassandraLeo
Date Posted: September 28 2019 at 16:28
Thanks for the response. That’s so strange that it worked for you. I’m showing as logged in; it shows my username and gives me the prompt to edit my old ratings and reviews. I suppose I should try editing one of those and see if that works.

I don’t know what problem would exist on my end, though. Running a search for this specific error code ("Microsoft SQL Server Native Client 11.0 error ’80040e57’") doesn’t return too many results; this thread is actually the third result that came up on a Google search. None of the ones I’ve perused actually seem relevant to this exact problem; most seem to be solutions for developers rather than end users. The same goes for "String or binary data would be truncated": most of the results are for programmers.

Judging from those results, it sounds like the content I’m submitting exceeds the size of whatever column would store the data, but without knowledge of which column that is, I don’t know which part of the submission to edit. It also seems unlikely that the content I submitted for Hallucinogen would be too long; I’ve certainly seen longer track listings and album descriptions. Unless the problem is with the images? I tried submitting a 300x300 .jpg and it still didn’t work. Does it specifically want the suffix .jpeg? I can’t remember that being a requirement before. And the error code I’m getting wouldn’t show up if I used the wrong suffix for an image, would it?

This also isn’t the first time I’ve had problems submitting content here, and it’s happened on multiple computers across several years. At times I’ve actually been unable to post on the forums at all. Is it possible that something about my account has become corrupted?

If this is relevant, here’s my Chrome version info:

Quote Google Chrome 77.0.3865.90 (Official Build) (64-bit) (cohort: 77_90_Win)
Revision: 58c425ba843df2918d9d4b409331972646c393dd-refs/branch-heads/3865@{#830}
OS: Windows 10 OS Version 1809 (Build 17763.737)
JavaScript: V8 7.7.299.11
Flash: 32.0.0.255 C:\Users\[username]\AppData\Local\Google\Chrome\User Data\PepperFlash\32.0.0.255\pepflashplayer.dll
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36
Or possibly one of my extensions is breaking the website. If that’s the case, I’d have to try disabling them selectively until I can get the content to submit. Maybe I should also try submitting albums from another system. I’ll go through some of these steps later; I don’t have time at the moment.

Thanks in advance for any further clarification you may be able to provide.
< x="0" y="0" width="99999" height="99999" id="hc_extension_off">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black_back">

-------------
http://www.last.fm/user/Cassandra-Leo" rel="nofollow - last.fm · http://www.soundcloud.com/CassandraLeo" rel="nofollow - soundcloud


Posted By: Quinino
Date Posted: September 28 2019 at 16:47
Have you ever accomplished a successful addition or you always receive an error ?

(try also changing the browser or at least clean the cache of the current)


Posted By: CassandraLeo
Date Posted: September 28 2019 at 17:08
I’ve had several successful additions, but not lately.  http://www.progarchives.com/album.asp?id=53227" rel="nofollow - Here’s an example . I don’t know how I’d find my most recent successful addition.

I’ll try a different browser later as well, and yeah, clearing the cache might help, too. Thanks for the suggestions; I’ll report back at some point.< x="0" y="0" width="99999" height="99999" id="hc_extension_off">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast">< x="0" y="0" width="99999" height="99999" id="hc_extension_highcontrast_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_grayscale_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_back">< x="0" y="0" width="99999" height="99999" id="hc_extension_invert_grayscale">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black">< x="0" y="0" width="99999" height="99999" id="hc_extension_yellow_on_black_back">


-------------
http://www.last.fm/user/Cassandra-Leo" rel="nofollow - last.fm · http://www.soundcloud.com/CassandraLeo" rel="nofollow - soundcloud



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.01 - http://www.webwizforums.com
Copyright ©2001-2014 Web Wiz Ltd. - http://www.webwiz.co.uk