[Koha] Koha 3.20.03 - Some reserve informations are inserting as NULL

[Chris Cormack]

* Ozkan OZMEN (ozkanozmen at balikesir.edu.tr) wrote:
> 
> Hi all,
> 
> I saw some columns as NULL in old_reserves table on database. These: espacially itemnumber and biblionumber. 
> Do you know why these field are recording as NULL?
> I want to learn this because our circulation report involved some NULL items.
> 
> 
> I am looking forward to your helps.
> Thank you.

Hi Ozkan

They aren't recording as null, but what happens is when the item or
biblio is deleted, there is an ON DELETE CASCADE rule,

For example

CONSTRAINT old_reserves_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES
biblio (biblionumber)
    ON DELETE SET NULL ON UPDATE SET NULL,

This is for referential integrity, otherwise we have biblonumbers or
items that have been deleted stored in those tables.  

So those will be for items and biblio records that have been deleted.

Hope this helps

Chris

> 
> 
> Regards,
> Özkan ÖZMEN
> CENTER OF LIBRARY
> BALIKESIR UNIVERSITY - TURKEY
> YASAL UYARI:
> Bu elektronik posta ve onunla iletilen butun dosyalar kisiye ozeldir ve sadece gondericisi tarafindan almasi amaclanan yetkili gercek ya da tuzel kisinin kullanimi icindir. Eger soz konusu yetkili alici siz degilseniz bu elektronik postanin icerigini aciklamaniz, kopyalamaniz, yonlendirmeniz ve kullanmaniz kesinlikle yasaktir. Bu mesajin gonderilmek istendigi kisi degilseniz (ya da bu e-posta'yi yanlislikla aldiysaniz), lutfen yollayan kisiyi haberdar ediniz ve mesaji sisteminizden derhal siliniz. Kurumumuz, bu mesajin icerdigi bilgilerin dogrulugu veya eksiksiz oldugu konusunda herhangi bir garanti vermemektedir. Bu nedenle bu epostanin ne sekilde olursa olsun iceriginden, iletilmesinden, alinmasindan ve saklanmasindan kurumumuz sorumlu degildir. Bu mesajdaki gorusler yalnizca gonderen kisiye ait olup, her zaman kurumumuzun goruslerini yansitmayabilir. 
> Bu e-posta, bilinen butun bilgisayar viruslerine karsi anti-virus sistemimiz tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hukuki ve mali hic bir sorumlulugu kabul etmez.
> 
> DISCLAIMER:
> This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, forwarding, copying or use of any of the information is strictly prohibited. If you are not the intended recipient (or have received this e-mail by mistake), please notify the sender and delete it from your system immediately. Our university makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. The opinions expressed in this message may belong to sender alone and may not necessarily reflect the opinions of our university. 
> This e-mail has been scanned by our anti-virus system for all known computer viruses. In doing so, however, sender cannot guarantee that virus or other forms of data corruption may not be present and do not take any legal or financial responsibility in any occurrance.
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20151214/3d0463ba/attachment.sig>