Re: [lojban] lojban.org is broken

Here we get

System error

error:

DBD::Pg::db do failed: ERROR: null value in column "natlangwordid" violates not-null constraint at /srv/jbovlaste/current/dict/editdef.html line 163.

context:

...
159:	{
160:	next unless (defined $glosskeywords[$i] && $glosskeywords[$i]->[0]);
161:	my @tmp = @{ $glosskeywords[$i] };
162:	my $meaning = $tmp[1] ? $tmp[1] : undef;
163:	$dbh->do("INSERT INTO keywordmapping (definitionid, place, natlangwordid)
164:	VALUES (?, 0, (SELECT wordid FROM natlangwords
165:	WHERE langid=(SELECT langid FROM definitions
166:	WHERE definitionid=?::integer) AND word=?::text AND
167:	(meaning=?::text OR (?::text IS NULL AND meaning IS NULL)) ))",
...

code stack:

/srv/jbovlaste/current/dict/editdef.html:163
/usr/share/perl5/vendor_perl/HTML/Mason/Request.pm:948
/srv/jbovlaste/mason-data-dir/obj/2204750894/jbovlaste/dict/editdef.html.obj:17
/srv/jbovlaste/current/autohandler:4

raw error

DBD::Pg::db do failed: ERROR:  null value in column "natlangwordid" violates not-null constraint at /srv/jbovlaste/current/dict/editdef.html line 163.


Trace begun at /usr/share/perl5/vendor_perl/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('DBD::Pg::db do failed: ERROR:  null value in column "natlangwordid" violates not-null constraint at /srv/jbovlaste/current/dict/editdef.html line 163.^J') called at /srv/jbovlaste/current/dict/editdef.html line 163
HTML::Mason::Commands::__ANON__('glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 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(0x7f5c376bf3f8)', 'main', 'glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 948
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f5c372299f0)', 'main', 'glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) called at /srv/jbovlaste/mason-data-dir/obj/2204750894/jbovlaste/dict/editdef.html.obj line 17
HTML::Mason::Commands::__ANON__('glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f5c376bf3f8)', 'glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 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, undef, 'glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1355
HTML::Mason::Request::scomp('HTML::Mason::Request::ApacheHandler=HASH(0x7f5c372299f0)', 'HTML::Mason::Component::FileBased=HASH(0x7f5c376bf3f8)', 'glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) called at /srv/jbovlaste/current/autohandler line 4
HTML::Mason::Commands::__ANON__('glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f5c376dbc58)', 'glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) called at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1297
eval {...} at /usr/share/perl5/vendor_perl/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'glossmax', 1, 'definitiontxt', '$x_1$ is a papaya (fruit) of species/variety/cultivar $x_2$', 'langid', 2, 'definition', 20420, 'glossc1', 'on', 'langtag', 'en', 'placew1', '', 'valsitxt', 'pamga', 'placem1', '', 'glossw1', 'papaya', 'glossn1', '', 'valsiword', 'pamga', 'glossm1', 'fruit', 'final', 'Submit Definition', 'notes', 'Cf. {grute}', 'type', 'experimental gismu', 'valsiid', 11065, 'placemax', 1) 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(0x7f5c372299f0)') called at /usr/share/perl5/vendor_perl/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f5c372299f0)') called at /usr/share/perl5/vendor_perl/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f5c373e0c68)', 'Apache2::RequestRec=SCALAR(0x7f5c36e77450)') called at (eval 36) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x7f5c36e77450)') called at -e line 0
eval {...} at -e line 0