http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2416 ------- Comment #3 from frederic@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.