[Koha-bugs] [Bug 21617] New: statistics.ccode is not long enough (see also dbrev 18.06.00.032)
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Oct 19 10:48:06 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21617
Bug ID: 21617
Summary: statistics.ccode is not long enough (see also dbrev
18.06.00.032)
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Database
Assignee: koha-bugs at lists.koha-community.org
Reporter: m.de.rooy at rijksmuseum.nl
QA Contact: testopia at bugs.koha-community.org
Warn from a test:
DBD::mysql::st execute failed: Data too long for column 'ccode' at row 1 [for
Statement "INSERT INTO statistics
(datetime,
branch, type, value,
other, itemnumber, itemtype, location,
borrowernumber, proccode, ccode)
VALUES (now(),?,?,?,?,?,?,?,?,?,?)" with ParamValues: 0="z8LIyIV",
1='issue', 2=undef, 3='', 4='2584', 5='E_QkzaV5Ay',
6='oDnFRZyog2CS2_XoUB_MB2sBxyI3elbFPC_AekxLPrduGTXKnlNoLKEdQrXzpAw5zD1pGbZshV9ydZup',
7='2000005168', 8='',
9='j9ZDn74omZAoZrTOdC4a05SpWRSHPR2apfss7y5V6QJuQnBEk32XWXCfMp7'] at C4/Stats.pm
line 138.
The dbrev 18.06.00.032 did not change it from 10 to 80 as in other tables.
We should either truncate to 10 chars in Stats.pm or increase to varchar(80).
Since it is varchar and not char, we should not be afraid about size. I choose
for the latter here.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list