- Koha - lists.katipo.co.nz

Database creation has two errors in 2.2.7
by Rick Welykochy 15 Jan '07

15 Jan '07

Hi, I am installing Koha/2.2.7. We are using Mysql 5.0. I tweaked the koha.mysql and Search*.pm modules as required. They seem fine. During the database creation phase, the following two error messages appear: DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1705. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1705. Has anyone else seen these two error messages? cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Almost every man wastes part of his life attempting to display qualities which he does not possess. -- Samuel Johnson

1 0

REGISTROS DE AUTORIDAD Y USO DEL TESAURO
by Homero Almeida 12 Jan '07

12 Jan '07

Hola a todos, Talvez alguien puede guiarme o facilitarme información sobre como organizar los registros de autoridad, como organizar el tesauro dentro de KOHA... Obviamente en español, ya que he realizado la descripción temática utilizando tesauros en español....etc.... hasta pronto homero __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/

1 0

Help! Number of titles that may be checked out by users with Koha
by Amber Amland 12 Jan '07

12 Jan '07

We're a small school library that has happily been using Koha for about a year. It's our first automated system. We just started using it with our elementary library (added as a branch), and every time we try to check books out to elementary students it gives the red flag that says "Too many issues (already issued / max : a 0/0)". I made sure the student has permission to borrow books and have set up our issuing rules so that elementary students may have three books for 7 days. What's wrong? Does anyone have any ideas for how to fix this? Thanks, Amber _________________________________________________________________ >From photos to predictions, The MSN Entertainment Guide to Golden Globes has it all. http://tv.msn.com/tv/globes2007/?icid=nctagline1

3 3

New translations for koha 2.2.7
by Paul POULAIN 10 Jan '07

10 Jan '07

Hello all, I just commited some new translations for koha 2.2.7. They are available here : http://cvs.savannah.nongnu.org/viewcvs/koha/misc/translator/po/?root=koha&o… you'll find : -Italian translation (updated, thanks to Gaetano Piazza) - chinese, japanese & korean translations (new, thanks to laxendion, long_sam) Enjoy. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

1 0

Problem in importing Barcode Numbers
by Mirza Muhammad Naseer 09 Jan '07

09 Jan '07

Dear list members, We are converting our MS Access data to KOHA. Data from different fields was successfully imported to KOHA in bulk but ITEM INFORMATION (BAR CODES) are not being imported by the bulk code instead null values are shown for bar codes in imported records. Can anyone suggest what is the problem and how it can be handled. Yours, MIRZA MUHAMMAD NASEER Pakistan.

1 0

No results in search except in OPAC using default theme
by Pedro Maia 08 Jan '07

08 Jan '07

Im a new koha user trying to implement this software in a Public Library in Portugal. I've imported UNIMARC records with bulkmarcimport and I only get results of my searches in the OPAC of the default theme. Any other searches in any other theme result as 0. I have no erros in the MARC structure and when i made changes to it i run rebuildnonmarc.pl. Besides this i have imported the records with bulkmarcimport but i always get errors. First i got these ones: DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 333. DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 430. Now when i try to import i got these messages: ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (33146,concat(710,a),11,1,REPORT,soundex(REPORT)) DBD::mysql::st execute failed: Duplicate entry '1' for key 3 at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1183. ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (33146,concat(995,k),12,1,0148,soundex(0148)) DBD::mysql::st execute failed: Duplicate entry '1' for key 3 at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1183. ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (33146,concat(090,9),13,1,33140,soundex(33140)) At the eng i get the message telling that the "x" marc records have been imported. The records seem to be in the database but something must be wrong. I'm using koha 2.2.4 Any help is welcome. Thanks. Pedro Maia Centro de Informação e Documentação Instituto de Informática do Ministério das Finanças e da Administração Pública pedro.maia(a)inst-informatica.pt 214723295 <http://www.inst-informatica.pt/cid>

1 0

help: error 500 intranet & opac
by sapto siswoyo 06 Jan '07

06 Jan '07

Greetings. I found this error logs in my system. 1. intranet-error_logs premature end of script headers: mainpage.pl install_driver (mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: c:/usr/koha227/intranet/modules c:/usr/lib c:/usr/site/lib.) at (eval 16) line 3. perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the ccapitalissation of 'mysql' isn't right. Available drivers: DBM, ExampleP, File, Proxy, Sponge. at c:/ussr/koha227/intranet/modules/c4/Context.pm line 411. 2. opac-error logs premature end of script headers: opac-main.pl install_driver (mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: c:/usr/koha227/intranet/modules c:/usr/lib c:/usr/site/lib.) at (eval 14) line 3. perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the ccapitalissation of 'mysql' isn't right. Available drivers: DBM, ExampleP, File, Proxy, Sponge. at c:/ussr/koha227/intranet/modules/c4/Context.pm line 411. Compilation failed in require at c:/usr/koha227/opac/cgi-bin/koha/opac-main.pl line 9. BEGIN failed--compilation aborted at c:/usr/koha227/opac/ci-bin/koha/opac_main.pl line 9. I can read it at all, but I dont understand what I suppose to do. Please let me know it further. Thank you in advance for all of your supports. Regards, Sees __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

Problem in running "bulkmarcimport.pl" script
by arnab 04 Jan '07

04 Jan '07

Hi, All, When I'm trying to run the script "bulkmarcimport.pl" it showing the error....... C:\usr\koha227\scripts\misc\migration_tools>bulkmarcimport.pl -file t.mrc Can't locate object method "encoding" via package "MARC::Record" at C:\usr\koha227\scripts\misc\migration_tools\bulkmarcimport.pl line 218. bulkmarcimport.pl 216 if ($marcFlavour eq 'MARC21') { 217 my $tag000_pos09; 218 if ($record->encoding() eq 'UTF-8') { 219 if ($verbose) { 220 print "\nRecord $i encoding is UTF-8\n"; 221 $tag000_pos09 = substr ($record->leader, 9, 1); 222 $ ....... Could anybody help me. With Regards, Arnab -- View this message in context: http://www.nabble.com/Problem-in-running-%22bulkmarcimport.pl%22-script-tf2… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 2

[first installation]Problem updating database..
by Thibaud Hulin 04 Jan '07

04 Jan '07

Hello and happy new year ! The help of Jogiraju has partially solve my problem with php5, but I can't always install koha. Now, I have his error after enter the root password : Creating the MySQL database for Koha... 0 Start tag expected, '<' not found at /usr/lib/perl5/XML/LibXML/SAX.pm line 64 at /usr/share/perl5/XML/Simple.pm line 287 BEGIN failed--compilation aborted at scripts/updater/updatedatabase line 21. Problem updating database.. Thanks for help, Thibaud. Jogiraju TALLAPRAG a écrit : > hi, > > 'return' is a reserved word in mysql5 which is not so for mysql5. You > have to edit the file koha.mysql file found in the koha installation > directory ( same directory where installer.pl file is found) and put > keyword return in backticks like this `return` and proceed with the > installation: > perl inataller.pl > It is always good to put all the fieldnames of the table definitions in > back ticks. > > Regards, > > > T. Jogi Raju > Librarian, Malla Reddy Engieering College, Hyderabad, India > > */Thibaud Hulin <hulin.thibaud(a)wanadoo.fr>/* wrote: > > Yes, I'm using mysql Ver 14.12 Distrib 5.0.30, for pc-linux-gnu (i486) > using readline 5.2 > Can I use mysql 4 and 5 ? Or must I uninstall mysql5 and install > mysql 4 ? > > Kochin Chang a écrit : > > Are you using MySQL 5.x? The current version of Koha is not > compatible > > with MySQL 5.x. > > > > Kochin > > > > Thibaud Hulin wrote: > >> Hi ! > >> I'm trying Koha on a Debian sarge testing, but I have an error after > >> launching install.pl and enter my sql password. This is the error > >> message : > >> CREATING DATABASE > >> > >> Creating the MySQL database for Koha... > >> 0 > >> ERROR 1064 (42000) at line 772: You have an error in your SQL > syntax; > >> check the manual that corresponds to your MySQL server version > for the > >> right syntax to use near 'return char(4) default NULL, > >> renewals tinyint(4) default NULL, > >> timestamp tim' at line 9 > >> > >> Start tag expected, '<' not found > >> at /usr/lib/perl5/XML/LibXML/SAX.pm line 64 > >> at /usr/share/perl5/XML/Simple.pm line 287 > >> BEGIN failed--compilation a > >> > >> I'm a beginner with sql. > >> > >> Thanks for help, > >> Thibaud. > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com >

1 0

rebuilding the MARC
by Keith LaBumbard 03 Jan '07

03 Jan '07

Hi, I'm having a problem when running the rebuildnonmarc.pl. The following is the text that appears when I run it. Can't locate C4/Context.pm in @INC (@INC contains: /usr/lib/perl5/5.8.3/i386-lin ux-thread-multi /usr/lib/perl5/5.8.3 /usr/lib/perl5/site_perl/5.8.3/i386-linux-t hread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl 5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-li nux-thread-multi /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 / usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site _perl /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/ve ndor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-li nux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/l ib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendo r_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at r ebuildnonmarc.pl line 10. BEGIN failed--compilation aborted at rebuildnonmarc.pl line 10. [root@localhost misc]# Can someone tell me what I can do to make this work please? Thanks Keith

2 1