25 Jul
2013
25 Jul
'13
1:05 p.m.
Op 24/07/13 09:12, malikaamir schreef:
i have tried this command but this is giving this kind of error
ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (`koha_libnamal`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_libnamal`.`biblioitems` (`biblioitemnumber`))
so please help me
Oh yeah, I forgot that, that is a slightly annoying change in newer mysql. Run: SET FOREIGN_KEY_CHECKS=0; before the commands, and: SET FOREIGN_KEY_CHECKS=1; after it. If you want more information, putting that error into google results in some good explanations. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D