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:<br><div style="margin-left: 40px;">
unset TZ<br></div><div style="margin-left: 40px;">date<br>export TZ="US/Central"<br>date<br></div><br>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. <br>
<br>So the next thing to look at are the TZ's in mysql, and updating them with <a href="http://dev.mysql.com/doc/refman/5.1/en/mysql-tzinfo-to-sql.html" title="4.4.7. mysql_tzinfo_to_sql — Load the Time Zone Tables"><span><strong class="command">mysql_tzinfo_to_sql</strong></span></a>:<br>
<div style="margin-left: 40px;"><a href="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</a><br></div><br>Note, your sysadmin can run (and even schedule) rebuild_zebra.pl without setting TZ, just to get you started. <br>
<br>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 "_". <br>
Basically, don't worry about it unless call number order elsewhere seems not to be accurate.<br><br>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. <br>
<br>--Joe Atzberger<br><br><div class="gmail_quote">On Tue, Jan 27, 2009 at 3:56 AM, Zeno Tajoli <span dir="ltr"><<a href="mailto:tajoli@cilea.it">tajoli@cilea.it</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<div class="Ih2E3d"><br>
>1) When we catalog new items (whether it be a record we have<br>
>imported in, an item we have added to an existing record or a new<br>
>record we have done original cataloging for) we are unable to get it<br>
>to show up in the results screen when we search for it in the<br>
>catalog. I can enter the barcode at check in and it comes up and I<br>
>can enter the barcode in at checkout and check it out to a patron<br>
>and it comes up fine. It just doesn't come up when I search for it<br>
>in the catalog.<br>
><br>
>2) Because the book is not coming up when I search for it I'm also<br>
>not able to search for it when I want to print the barcode. I can<br>
>print the barcode using a barcode generator but it should work in the program.<br>
><br>
><br>
</div><div class="Ih2E3d">>And finally,<br>
>6) Our It person found this today:<br>
><br>
>Cron job to update Zebra indexes every 15 minutes returning the<br>
>following via email:<br>
>X-Cron-Env: <HOME=/home/koha><br>
>X-Cron-Env: <PERL5LIB=/home/koha/kohaclone><br>
>X-Cron-Env: <KOHA_CONF=/home/koha/koha-dev/etc/koha-conf.xml><br>
>X-Cron-Env: <TZ=US/Central><br>
>X-Cron-Env: <SHELL=/bin/sh><br>
>X-Cron-Env: <PATH=/usr/bin:/bin><br>
>X-Cron-Env: <LOGNAME=koha><br>
>X-Cron-Env: <USER=koha><br>
><br>
>DBD::mysql::db do failed: Unknown or incorrect time zone:<br>
>'US/Central' at /home/<br>
>koha/kohaclone/C4/Context.pm line 675.<br>
<br>
<br>
</div>problems 1), 2), 6) are the same:<br>
you use Zebra as indexer and Zebra doesn't work well<br>
<br>
So tell ro your IT support to read CAREFULLY the install.* files in<br>
the koha package and try to start Zebra and indexing of the<br>
bibliographic/holding data.<br>
<br>
Bye<br>
<font color="#888888"><br>
Zeno Tajoli<br>
CILEA - Segrate (MI)<br>
tajoliAT_SPAM_no_prendiATcilea.it<br>
(Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)<br>
</font><div><div></div><div class="Wj3C7c"><br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</div></div></blockquote></div><br>