[Koha-bugs] [Bug 2416] Defining overdue actions doesn't display recorded rules

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2416





------- Comment #3 from frederic at tamil.fr  2008-07-29 07:20 -------
I found it. There is an incompatibility between
categorycode as defined in categories table and
in overduerules table. In 'overduerules' categorycode
is varchar(2). In 'categories' table it is varchar(10).

So, when a set of rules is saved for a categorycode
which length is >2, its code is truncated and the
record can't be found anymore.

Solution: overduerules definition must modified:

  1. in /installer/data/mysql/kohastructure.sql
  2. in /installer/data/mysql/updatedatabase.sql:
     ALTER TABLE `items` 
     MODIFY COLUMN `copynumber` VARCHAR(32) DEFAULT NULL

Table 'overduerules':

+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| branchcode   | varchar(10) | NO   | PRI |         |       |
| categorycode | varchar(2)  | NO   | PRI |         |       |
| delay1       | int(4)      | YES  |     | 0       |       |
| letter1      | varchar(20) | YES  |     | NULL    |       |
| debarred1    | varchar(1)  | YES  |     | 0       |       |
| delay2       | int(4)      | YES  |     | 0       |       |
| debarred2    | varchar(1)  | YES  |     | 0       |       |
| letter2      | varchar(20) | YES  |     | NULL    |       |
| delay3       | int(4)      | YES  |     | 0       |       |
| letter3      | varchar(20) | YES  |     | NULL    |       |
| debarred3    | int(1)      | YES  |     | 0       |       |
+--------------+-------------+------+-----+---------+-------+

Table 'categories':

+-----------------------+---------------+------+-----+---------+-------+
| Field                 | Type          | Null | Key | Default | Extra |
+-----------------------+---------------+------+-----+---------+-------+
| categorycode          | varchar(10)   | NO   | PRI |         |       | 
| description           | mediumtext    | YES  |     | NULL    |       | 
| enrolmentperiod       | smallint(6)   | YES  |     | NULL    |       | 
| upperagelimit         | smallint(6)   | YES  |     | NULL    |       | 
| dateofbirthrequired   | tinyint(1)    | YES  |     | NULL    |       | 
| finetype              | varchar(30)   | YES  |     | NULL    |       | 
| bulk                  | tinyint(1)    | YES  |     | NULL    |       | 
| enrolmentfee          | decimal(28,6) | YES  |     | NULL    |       | 
| overduenoticerequired | tinyint(1)    | YES  |     | NULL    |       | 
| issuelimit            | smallint(6)   | YES  |     | NULL    |       | 
| reservefee            | decimal(28,6) | YES  |     | NULL    |       | 
| category_type         | varchar(1)    | NO   |     | A       |       | 
+-----------------------+---------------+------+-----+---------+-------+

I can do it if someone allow me to bump kohaversion.pl.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.