Koha 3.20.03 - Some reserve informations are inserting as NULL
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. 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.
* Ozkan OZMEN (ozkanozmen@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@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
Thanks for your interest. I understood. Regards, Özkan ÖZMEN CENTER OF LIBRARY BALIKESIR UNIVERSITY - TURKEY ----- Orijinal Mesaj ----- Kimden: "Chris Cormack" <chrisc@catalyst.net.nz> Kime: "Ozkan OZMEN" <ozkanozmen@balikesir.edu.tr> Kk: "koha" <koha@lists.katipo.co.nz> Gönderilenler: 13 Aralık Pazar 2015 23:26:50 Konu: Re: [Koha] Koha 3.20.03 - Some reserve informations are inserting asNULL * Ozkan OZMEN (ozkanozmen@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@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 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.
participants (2)
-
Chris Cormack -
Ozkan OZMEN