Entering umlauts into gloss keywords makes Jbovlaste crash

[Wuzzy2]

If I enter a keyword containing an umlaut into the gloss keywords, Jbovlaste crashes.

Here is the full raw error (I have entered “Lojban-ähnlich” into the German definition, note this gloss already existed; but as far I know the crash also happens when the gloss word did not exist previously):

DBD::Pg::db do failed: ERROR:  duplicate key value violates unique constraint "natlangwords_unique_langid_word_null"
DETAIL:  Key (langid, word)=(9, Lojban-ähnlich) already exists. at /srv/jbovlaste/current/natlang/add.html line 267.


Trace begun at /usr/share/perl5/vendor_perl/HTML/Mason/Exceptions.pm line 125
HTML::Mason::Exceptions::rethrow_exception('DBD::Pg::db do failed: ERROR:  duplicate key value violates unique constraint "natlangwords_unique_langid_word_null"^JDETAIL:  Key (langid, word)=(9, Lojban-M-CM-$hnlich) already exists. at /srv/jbovlaste/current/natlang/add.html line 267.^J') called at /srv/jbovlaste/current/natlang/add.html line 267
HTML::Mason::Commands::__ANON__('lang', 'de', 'word', 'Lojban-M-CM-$hnlich', 'meaning', '', 'notes', undef, 'valid', 1, 'stfu', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 157
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f7a80049fd0)', 'main', 'lang', 'de', 'word', 'Lojban-M-CM-$hnlich', 'meaning', '', 'notes', undef, 'valid', 1, 'stfu', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 948
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f7ac8067988)', 'main', 'lang', 'de', 'word', 'Lojban-M-CM-$hnlich', 'meaning', '', 'notes', undef, 'valid', 1, 'stfu', 1) called at /srv/jbovlaste/mason-data-dir/obj/3214073370/jbovlaste/natlang/add.html.obj line 17
HTML::Mason::Commands::__ANON__('lang', 'de', 'word', 'Lojban-M-CM-$hnlich', 'meaning', '', 'notes', undef, 'valid', 1, 'stfu', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f7a80049fd0)', 'lang', 'de', 'word', 'Lojban-M-CM-$hnlich', 'meaning', '', 'notes', undef, 'valid', 1, 'stfu', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1302
eval {...} at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 'lang', 'de', 'word', 'Lojban-M-CM-$hnlich', 'meaning', '', 'notes', undef, 'valid', 1, 'stfu', 1) called at /srv/jbovlaste/current/dict/nlwbits line 90
HTML::Mason::Commands::__ANON__('valsiid', 29383, 'jargon', '', 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'placemax', 1, 'langid', 9, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'placem1', '', 'valsitxt', 'jbobausmi', 'valsiword', 'jbobausmi', 'type', 'lujvo') called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f7ac8096a80)', 'valsiid', 29383, 'jargon', '', 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'placemax', 1, 'langid', 9, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'placem1', '', 'valsitxt', 'jbobausmi', 'valsiword', 'jbobausmi', 'type', 'lujvo') called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1298
eval {...} at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 'valsiid', 29383, 'jargon', '', 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'placemax', 1, 'langid', 9, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'placem1', '', 'valsitxt', 'jbobausmi', 'valsiword', 'jbobausmi', 'type', 'lujvo') called at /srv/jbovlaste/current/dict/editdef.html line 137
HTML::Mason::Commands::__ANON__('jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 157
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f7ad006eee8)', 'main', 'jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 948
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f7ac8067988)', 'main', 'jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /srv/jbovlaste/mason-data-dir/obj/3214073370/jbovlaste/dict/editdef.html.obj line 17
HTML::Mason::Commands::__ANON__('jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f7ad006eee8)', 'jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1302
eval {...} at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1355
HTML::Mason::Request::scomp('HTML::Mason::Request::ApacheHandler=HASH(0x7f7ac8067988)', 'HTML::Mason::Component::FileBased=HASH(0x7f7ad006eee8)', 'jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /srv/jbovlaste/current/autohandler line 4
HTML::Mason::Commands::__ANON__('jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f7aa0039988)', 'jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1300
eval {...} at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'jargon', '', 'valsiid', 29383, 'glossw1', 'Lojban-M-CM-$hnlich', 'glossmax', 1, 'notes', 'Syn. {lojban zei simsa}. Vgl. {jbobau}, {lojban}, {simsa}.', 'glossm1', '', 'final', 'Submit Definition', 'langid', 9, 'placemax', 1, 'definitiontxt', '$s_1$ ist M-CM-$hnlich/parallel zu Lojban in Hinsicht/Eigenschaft $s_3$ (ka).', 'placew1', '', 'definition', 67122, 'langtag', 'de', 'valsitxt', 'jbobausmi', 'placem1', '', 'type', 'lujvo', 'valsiword', 'jbobausmi') called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f7ac8067988)') called at /usr/share/perl5/vendor_perl/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f7ac8067988)') called at /usr/share/perl5/vendor_perl/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f7aa000c470)', 'Apache2::RequestRec=SCALAR(0x7f7ad009c4d8)') called at (eval 30) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x7f7ad009c4d8)') called at -e line 0
eval {...} at -e line 0

[lagleki]

most likely a duplicate of #165

[Pendrokar]

Seems fixed. Tested by adding a needless German definition for a longer lujvo.
http://jbovlaste.lojban.org/dict/vormygreku