http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15207 --- Comment #18 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Could something like this here work? 4234 sub stocknumber_checker { #code reused later on 4235 my @row; 4236 #drop the obsolete itemSStocknumber idx if it exists 4237 @row = $dbh->selectrow_array("SHOW INDEXES FROM items WHERE key_name='itemsstocknumberidx'"); 4238 $dbh->do("ALTER TABLE `items` DROP INDEX `itemsstocknumberidx`;") if @row; 4239 4240 #check itemstocknumber idx; remove it if it is unique 4241 @row = $dbh->selectrow_array("SHOW INDEXES FROM items WHERE key_name='itemstocknumberidx' AND non_unique=0"); 4242 $dbh->do("ALTER TABLE `items` DROP INDEX `itemstocknumberidx`;") if @row; 4243 4244 #add itemstocknumber index non-unique IF it still not exists 4245 @row = $dbh->selectrow_array("SHOW INDEXES FROM items WHERE key_name='itemstocknumberidx'"); 4246 $dbh->do("ALTER TABLE items ADD INDEX itemstocknumberidx (stocknumber);") unless @row; 4247 } -- You are receiving this mail because: You are watching all bug changes.