[Koha] [KOHA] BATCH ITEM MODIFICATION BARCODES NOT FOUND

[muirunyeri]

Dear colleagues,
I updated the barcodes field directly from the koha_library items table in mysql successfully. From the browser, searching the barcodes from the catalogue is successful but the batch item modification gives the barcodes not found result. Barcodes edited through the browser are however found using the batch modification.
How do I resolve this?
This is the query I used:
CREATE TEMPORARY TABLE temp_koha_imports(call_number VARCHAR(40) NOT NULL, barcode VARCHAR(40) NOT NULL UNIQUE,
new_barcode VARCHAR(40) NOT NULL PRIMARY KEY;

LOAD DATA LOCAL INFILE '/tmp/koha_update_weeded.csv' INTO TABLE temp_koha_imports FIELDS TERMINATED BY ',';


UPDATE items i INNER JOIN temp_koha_imports t ON t.barcode=i.barcode SET i.barcode=new_barcode;

Someone please help