[Koha] Acquisitions module internal server error

[schnydszch]

Before I add this in Koha bugs, I forgot to mention that I had a plugin for
barcode which is basically barcode.pl but commenting the following line:   
($args{year}, $args{mon}, $args{day}) = split('-', output_pref({ dt =>
dt_from_string, dateformat => 'iso', dateonly => 1 }));which is to not add
date in the barcode in option 'hbyymmincr' or 'generated in the form
yymm0001.I returned the original barcode.pl file to check if I will still
get the error message, and Yes I still got the error message. A snippet on
the plack-error log:No existing hbyymmincr barcodes found.  Reverting to
initial value. at /usr/share/koha/lib/C4/Barcodes/hbyymmincr.pm line
62.DBD::mysql::st execute failed: Duplicate entry 'DLSU-D16120002' for key
'itembarcodeidx' [for Statement "INSERT INTO items SET           
biblionumber        = ?,            biblioitemnumber    = ?,           
barcode             = ?,            dateaccessioned     = ?,           
booksellerid        = ?,            homebranch          = ?,           
price               = ?,            replacementprice    = ?,           
replacementpricedate = ?,            datelastborrowed    = ?,           
datelastseen        = ?,            stack               = ?,           
notforloan          = ?,            damaged             = ?,           
itemlost            = ?,            withdrawn           = ?,           
itemcallnumber      = ?,            coded_location_qualifier = ?,           
restricted          = ?,            itemnotes           = ?,           
itemnotes_nonpublic = ?,            holdingbranch       = ?,           
paidfor             = ?,            location            = ?,           
permanent_location  = ?,            onloan              = ?,           
issues              = ?,            renewals            = ?,           
reserves            = ?,            cn_source           = ?,           
cn_sort             = ?,            ccode               = ?,           
itype               = ?,            materials           = ?,            uri                
= ?,            enumchron           = ?,            more_subfields_xml  = ?,           
copynumber          = ?,            stocknumber         = ?,           
new_status          = ?          " with ParamValues: 0="4908", 1='4908',
2="DLSU-D16120002", 3='2016-12-14', 4=undef, 5="DLSU-D", 6=undef, 7=undef,
8='2016-12-14', 9=undef, 10='2016-12-14', 11=undef, 12=0, 13=0, 14=0, 15=0,
16=undef, 17=undef, 18=undef, 19=undef, 20=undef, 21="DLSU-D", 22=undef,
23=undef, 24=undef, 25=undef, 26=undef, 27=undef, 28=undef, 29="lcc", 30='',
31=undef, 32=undef, 33=undef, 34=undef, 35=undef, 36=undef, 37=undef,
38=undef, 39=undef] at /usr/share/koha/lib/C4/Items.pm line
2119.DBD::mysql::st execute failed: Column 'itemnumber' cannot be null [for
Statement "INSERT INTO `aqorders_items` ( `itemnumber`, `ordernumber`)
VALUES ( ?, ? )" with ParamValues: 0=undef, 1='42'] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line
1832.DBIx::Class::Storage::DBI::_dbh_execute(): Column 'itemnumber' cannot
be null at /usr/share/koha/lib/Koha/Acquisition/Order.pm line 68Further
looking at the plack-error log, this particular snippet in the error log is
seen repeatedly when finding this particular barcode "DLSU-D16120002". It
seems it's not auto-incrementing and should be as stated in the interface
"The autoBarcode system preference is set to hbyymmincr and items with blank
barcodes will have barcodes generated upon save to database" I feel that the
barcode does not auto-increment in the Acquisitions module for this
particular instance. It's just so weird that another Koha instance in that
same server can not replicate this use case, also Plack-enabled with
hbyymmincr enabled. I'll just add this to the Koha bugs. Thanks and cheers!



--
View this message in context: http://koha.1045719.n5.nabble.com/Acquisitions-module-internal-server-error-tp5913371p5914017.html
Sent from the Koha-general mailing list archive at Nabble.com.