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.
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
