VocaDB / vocadb

VocaDB is a Vocaloid Database with translated artists, albums, music videos and more.
https://vocadb.net
Other
344 stars 39 forks source link

Tag entries don't support kanji or other different characters #1318

Closed Untitled39 closed 1 year ago

Untitled39 commented 2 years ago

Website

VocaDB

Describe the bug

Tag entries can not be created or properly saved if they contain characters other than latin.

I was creating a tag with this name "#コンパス ライブアリーナ", hitting the create button did not work, i wrote the english name instead "#COMPAS LIVE ARENA" still didn't work so i removed the "#" and it worked.

Going back to edit the tag, i tried to add the names i originally wanted, when hitting "save" i got a red screen saying "Internal Server Error", i assume the problem is that tag entries are only supporting latin characters right now.

EDIT: The changes were properly saved at the second revision (https://vocadb.net/Tag/ViewVersion/35604) so maybe the problem is on creating them, or it was a temporal bug?.

ycanardeau commented 2 years ago
NHibernate.Exceptions.GenericADOException could not insert: [VocaDb.Model.Domain.Tags.ArchivedTagVersion][SQL: INSERT INTO dbo.ArchivedTagVersions ([CommonEditEvent], [Created], [Data], [Hidden], [Notes], [Status], [Version], [Author], [Tag], ChangedFields) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
String or binary data would be truncated.

It looks like the ChangedFields field exceeded the maximum length of 100, because you changed too many fields at once: (CategoryName,Description,HideFromSuggestions,Names,OriginalName,Parent,Picture,RelatedTags,Status,Targets,WebLinks)

Additionally, please fill out the checklist next time you open a bug report.