[Koha] Search Results without items
Greetings Koha Guru's We are currently in the progress of migrating from Follett Destiny to Koha. One of the issues that we are having is that a bunch of biblio items are being imported that do not have an item (and some that are). I have run the SQL query to remove biblio without items; however the biblio records are still showing up when I search in OPAC. When you click on one of these items, a page with error 404 appears Here is the script I ran to remove the biblio items INSERT into deletedbiblio (SELECT * FROM biblio where biblionumber NOT IN (SELECT biblionumber from items)); INSERT into deletedbiblioitems (SELECT * FROM biblioitems where biblionumber NOT IN (SELECT biblionumber from items)); DELETE FROM biblio where biblionumber NOT IN (SELECT biblionumber from items); -- View this message in context: http://koha.1045719.n5.nabble.com/Search-Results-without-items-tp5718603.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problems with Koha mail notifications
Greetings, I really need help with some issues I am having with sending out email notifications The check in and check out email notifications are not sent out at all. The due reminder, overdue, and adcanced notice notifications are sent; but the fields are blank Example Dear Esther HOLLOWAY, The following item(s) will be due soon: , () Dear BillMARSHALL, According to our current records, you have items that are overdue. Please return or renew them as soon as possible. Flexon Library The following items are overdue: by - Dear Abel AKANBI, The following item is now due: , () --- Also; when I run the script overdue_notices.pl, i get the following errors Use of uninitialized value in pattern match (m//) at /usr/share/koha/bin/cronjobs/overdue_notices.pl line 659. Use of uninitialized value in pattern match (m//) at /usr/share/koha/bin/cronjobs/overdue_notices.pl line 670. -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-with-Koha-mail-notifications-tp5728717.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with Koha mail notifications
Thank you for the response, this was very helpful. Almost all of the borrowers were inputted through a CSV file so none of them have email preferences. Is there a script I can run that will automatically set the borrowers email preferences? I think we want them to be on by default. >From the behavior of the emails I have been receiving notifications from borrowers whom do not have email preferences set are receiving overdue and about to be due messages. - George W. Gardei (ggar...@gbs.edu) IT CAMS Manager God's Bible School & College 513-763-6516 1810 Young Street, Cincinnati OH 45202 -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-with-Koha-mail-notifications-tp5728717p5728874.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with Koha mail notifications
Galen, Thank you for your quick response, that sounds like what I need. - George W. Gardei (ggar...@gbs.edu) IT CAMS Manager God's Bible School & College 513-763-6516 1810 Young Street, Cincinnati OH 45202 -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-with-Koha-mail-notifications-tp5728717p5728879.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with Koha mail notifications
i ran the script force-borrower-messaging-defaults however it did not appear to do anything. I looked at the borrower messaging preferences tables and they had not been populated . when I ran the script it outputted a number count, and a patron type -00-001: S 2: S 3: S 4: S 6: U 7: U 8: U 9: U 10: U 11: U 12: U 13: U 14: U 15: U 16: U 17: U ... yadda yadda all the way down to 530 - George W. Gardei (ggar...@gbs.edu) IT CAMS Manager God's Bible School & College 513-763-6516 1810 Young Street, Cincinnati OH 45202 -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-with-Koha-mail-notifications-tp5728717p5728882.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with Koha mail notifications
Thanks for all the help but I still having the errrors with the overdue_notices script Use of uninitialized value in pattern match (m//) at /usr/share/koha/bin/cronjobs/overdue_notices.pl line 659. Use of uninitialized value in pattern match (m//) at /usr/share/koha/bin/cronjobs/overdue_notices.pl line 670. (repeats dozens of times) I am getting second overdue notices, but sofar no first time overdue notices. Also, the fine isn't being displayed, Examples --- Overdue Items (Second Notice) Dear Kate ODERO, According to our current records, you have items that are overdue. Please return or renew them as soon as possible. The following items are overdue: The lost art of disciple making by Eims, LeRoy Fine: USD Due on 2012-09-21 23:59:00 Please do not reply to this notification as it was automatically generated. If you have any question regarding this notification, please email libr...@gbs.edu. The Overdue Notice Templates are Dear <> <>, According to our current records, you have items that are overdue. Please return or renew them as soon as possible. Here is the template <> by <> Fine: USD Due on <> Please do not reply to this notification as it was automatically generated. If you have any question regarding this notification, please email libr...@gbs.edu. - George W. Gardei (ggar...@gbs.edu) IT CAMS Manager God's Bible School & College 513-763-6516 1810 Young Street, Cincinnati OH 45202 -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-with-Koha-mail-notifications-tp5728717p5728909.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with Koha mail notifications
I have not heard back on this post for a while. I am still having problems with the script (see preivous post) with the fines not displaying and the error meessage in the overdue notices script. - George W. Gardei (ggar...@gbs.edu) IT CAMS Manager God's Bible School & College 513-763-6516 1810 Young Street, Cincinnati OH 45202 -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-with-Koha-mail-notifications-tp5728717p5730449.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha