I again come to this group to see if you can help us through somethings that have been happening. I want to let you know that I'm the librarian that's been working through the problems and trying to communicate them to our IT staff who are trying to do more of the support themselves. I do not have access to any of the operations dealing with MySQL, Zebra, etc. I only have access to what I see with the program. Having said all that here are the problems we are experiencing. Any help or direction you could point us in would be appreciated. 1) When we catalog new items (whether it be a record we have imported in, an item we have added to an existing record or a new record we have done original cataloging for) we are unable to get it to show up in the results screen when we search for it in the catalog. I can enter the barcode at check in and it comes up and I can enter the barcode in at checkout and check it out to a patron and it comes up fine. It just doesn't come up when I search for it in the catalog. 2) Because the book is not coming up when I search for it I'm also not able to search for it when I want to print the barcode. I can print the barcode using a barcode generator but it should work in the program. 3) When I am able to print other barcodes that I have in existing batches, some of the barcodes print like they are supposed and others just print as black boxes so it's hit and miss wheter or not the barcode will print correctly or not. 4) We followed the Koha spec information about where and what information needed to be included in the 952 tag. I assumed that because we had the vendor put the information there that it would show up in the item record area in the corresponding fields. The information does not and I then need to input all the data into the required fields. Shouldn't the information show up there if it's in the 952 tag? 5) When I can get back into an item record and look at the edit items area I notice (with just the books I have added) that there is column that says Koha normalized classification for sorting. In this column it shows the call number but it's not quite right ie: FIC _DUP. What does the Koha normalized classification for sorting mean? And finally, 6) Our It person found this today: Cron job to update Zebra indexes every 15 minutes returning the following via email: X-Cron-Env: <HOME=/home/koha> X-Cron-Env: <PERL5LIB=/home/koha/kohaclone> X-Cron-Env: <KOHA_CONF=/home/koha/koha-dev/etc/koha-conf.xml> X-Cron-Env: <TZ=US/Central> X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <PATH=/usr/bin:/bin> X-Cron-Env: <LOGNAME=koha> X-Cron-Env: <USER=koha> DBD::mysql::db do failed: Unknown or incorrect time zone: 'US/Central' at /home/ koha/kohaclone/C4/Context.pm line 675. Again, any help would be appreciated. Thank you in advance for any help you can send our way. Marie J. Wardall Library Media Specialist Mountain Bay Elementary School 8602 Schofield Ave. Weston, WI 54476 mwardall@dce.k12.wi.us Phone: 715-355-0302 ext. 5824 Change Today, Change Tomorrow, Keep Changing
Hi Marie, I am a fellow librarian and understand where you are coming from. I can only comment on 1 below, but we too had the same problem and it turns out we didn't have zebra running. The IT printout below might be indicating that. The list is really helpful though so go ahead and ask these questions; the programmers are really nice and don't bite too hard! cheers Jo. Marie Wardall wrote:
I again come to this group to see if you can help us through somethings that have been happening. I want to let you know that I'm the librarian that's been working through the problems and trying to communicate them to our IT staff who are trying to do more of the support themselves. I do not have access to any of the operations dealing with MySQL, Zebra, etc. I only have access to what I see with the program.
Having said all that here are the problems we are experiencing. Any help or direction you could point us in would be appreciated.
1) When we catalog new items (whether it be a record we have imported in, an item we have added to an existing record or a new record we have done original cataloging for) we are unable to get it to show up in the results screen when we search for it in the catalog. I can enter the barcode at check in and it comes up and I can enter the barcode in at checkout and check it out to a patron and it comes up fine. It just doesn't come up when I search for it in the catalog.
2) Because the book is not coming up when I search for it I'm also not able to search for it when I want to print the barcode. I can print the barcode using a barcode generator but it should work in the program.
3) When I am able to print other barcodes that I have in existing batches, some of the barcodes print like they are supposed and others just print as black boxes so it's hit and miss wheter or not the barcode will print correctly or not.
4) We followed the Koha spec information about where and what information needed to be included in the 952 tag. I assumed that because we had the vendor put the information there that it would show up in the item record area in the corresponding fields. The information does not and I then need to input all the data into the required fields. Shouldn't the information show up there if it's in the 952 tag?
5) When I can get back into an item record and look at the edit items area I notice (with just the books I have added) that there is column that says Koha normalized classification for sorting. In this column it shows the call number but it's not quite right ie: FIC _DUP. What does the Koha normalized classification for sorting mean?
And finally, 6) Our It person found this today:
Cron job to update Zebra indexes every 15 minutes returning the following via email: X-Cron-Env: <HOME=/home/koha> X-Cron-Env: <PERL5LIB=/home/koha/kohaclone> X-Cron-Env: <KOHA_CONF=/home/koha/koha-dev/etc/koha-conf.xml> X-Cron-Env: <TZ=US/Central> X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <PATH=/usr/bin:/bin> X-Cron-Env: <LOGNAME=koha> X-Cron-Env: <USER=koha>
DBD::mysql::db do failed: Unknown or incorrect time zone: 'US/Central' at /home/ koha/kohaclone/C4/Context.pm line 675.
Again, any help would be appreciated. Thank you in advance for any help you can send our way.
Marie J. Wardall Library Media Specialist Mountain Bay Elementary School 8602 Schofield Ave. Weston, WI 54476 mwardall@dce.k12.wi.us Phone: 715-355-0302 ext. 5824
Change Today, Change Tomorrow, Keep Changing _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi,
1) When we catalog new items (whether it be a record we have imported in, an item we have added to an existing record or a new record we have done original cataloging for) we are unable to get it to show up in the results screen when we search for it in the catalog. I can enter the barcode at check in and it comes up and I can enter the barcode in at checkout and check it out to a patron and it comes up fine. It just doesn't come up when I search for it in the catalog.
2) Because the book is not coming up when I search for it I'm also not able to search for it when I want to print the barcode. I can print the barcode using a barcode generator but it should work in the program.
And finally, 6) Our It person found this today:
Cron job to update Zebra indexes every 15 minutes returning the following via email: X-Cron-Env: <HOME=/home/koha> X-Cron-Env: <PERL5LIB=/home/koha/kohaclone> X-Cron-Env: <KOHA_CONF=/home/koha/koha-dev/etc/koha-conf.xml> X-Cron-Env: <TZ=US/Central> X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <PATH=/usr/bin:/bin> X-Cron-Env: <LOGNAME=koha> X-Cron-Env: <USER=koha>
DBD::mysql::db do failed: Unknown or incorrect time zone: 'US/Central' at /home/ koha/kohaclone/C4/Context.pm line 675.
problems 1), 2), 6) are the same: you use Zebra as indexer and Zebra doesn't work well So tell ro your IT support to read CAREFULLY the install.* files in the koha package and try to start Zebra and indexing of the bibliographic/holding data. Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)
Actually, #6 is the root of #1 and #2 and probably #4. The problem with is your system and mysql recognizing your timezone, I believe. Test this on the command line with the following commands: unset TZ date export TZ="US/Central" date See what timezone your system *is* configured for (with TZ unset) and see if the system can handle your TZ. I'm guessing the system itself can, but mysql doesn't like it. So the next thing to look at are the TZ's in mysql, and updating them with * mysql_tzinfo_to_sql*<http://dev.mysql.com/doc/refman/5.1/en/mysql-tzinfo-to-sql.html> : http://dev.mysql.com/doc/refman/5.1/en/mysql-tzinfo-to-sql.html Note, your sysadmin can run (and even schedule) rebuild_zebra.pl without setting TZ, just to get you started. As for #5, the normalized call number for sorting is the call number... normalized for sorting. That is, certain classes of characters that are to be treated as equivalents are mapped to a common character. In your example, it looks like whitespace is mapped to "_". Basically, don't worry about it unless call number order elsewhere seems not to be accurate. That leaves really only #3, for which you should check that you have the best version of your barcode font installed, or try to characterize which data "blocks out" and which prints OK. --Joe Atzberger On Tue, Jan 27, 2009 at 3:56 AM, Zeno Tajoli <tajoli@cilea.it> wrote:
Hi,
1) When we catalog new items (whether it be a record we have imported in, an item we have added to an existing record or a new record we have done original cataloging for) we are unable to get it to show up in the results screen when we search for it in the catalog. I can enter the barcode at check in and it comes up and I can enter the barcode in at checkout and check it out to a patron and it comes up fine. It just doesn't come up when I search for it in the catalog.
2) Because the book is not coming up when I search for it I'm also not able to search for it when I want to print the barcode. I can print the barcode using a barcode generator but it should work in the program.
And finally, 6) Our It person found this today:
Cron job to update Zebra indexes every 15 minutes returning the following via email: X-Cron-Env: <HOME=/home/koha> X-Cron-Env: <PERL5LIB=/home/koha/kohaclone> X-Cron-Env: <KOHA_CONF=/home/koha/koha-dev/etc/koha-conf.xml> X-Cron-Env: <TZ=US/Central> X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <PATH=/usr/bin:/bin> X-Cron-Env: <LOGNAME=koha> X-Cron-Env: <USER=koha>
DBD::mysql::db do failed: Unknown or incorrect time zone: 'US/Central' at /home/ koha/kohaclone/C4/Context.pm line 675.
problems 1), 2), 6) are the same: you use Zebra as indexer and Zebra doesn't work well
So tell ro your IT support to read CAREFULLY the install.* files in the koha package and try to start Zebra and indexing of the bibliographic/holding data.
Bye
Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Joann Ransom -
Joe Atzberger -
Marie Wardall -
Zeno Tajoli