- Koha - lists.katipo.co.nz

database error
by Danabalou Mohanassoundarame 23 Mar '06

23 Mar '06

Bonjour/hello I am a newbie to koha trying to install koha in my server linux mandrak with perl, v5.8.5 built for i386-linux-thread-multi Apache2 Mysql-5.1.8 koha-2.2.5 the installer.pl give the following errers any idea!!!!!!!! thanks in advance mohan ---------------- DATABASE Creating the MySQL database for Koha... 0ERROR 1062 (23000) at line 1: Duplicate entry '%-Koha-kohaadmin' for key 1 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 DBD::mysql::db do failed: Table 'Koha.categoryitem' doesn't exist at scripts/updater/updatedatabase line 1092. DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1093. DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1094. DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1095. DBD::mysql::st execute failed: Table 'Koha.statistics' doesn't exist at scripts/updater/updatedatabase line 1106. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::st execute failed: Table 'Koha.statistics' doesn't exist at scripts/updater/updatedatabase line 1122. **Error : DBI::st=HASH(0x834ae28)->errstr DBD::mysql::st execute failed: Table 'Koha.itemtypes' doesn't exist at scripts/updater/updatedatabase line 1106. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::st execute failed: Table 'Koha.itemtypes' doesn't exist at scripts/updater/updatedatabase line 1122. **Error : DBI::st=HASH(0x8351810)->errstr DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1106. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1122. **Error : DBI::st=HASH(0x83531b4)->errstr DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1122. **Error : DBI::st=HASH(0x8351798)->errstr DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1122. **Error : DBI::st=HASH(0x8348410)->errstr DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1106. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1122. **Error : DBI::st=HASH(0x83517e0)->errstr DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1122. **Error : DBI::st=HASH(0x8352f2c)->errstr DBD::mysql::st execute failed: Table 'Koha.printers' doesn't exist at scripts/updater/updatedatabase line 1134. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::st execute failed: Table 'Koha.printers' doesn't exist at scripts/updater/updatedatabase line 1185. DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1185. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1185. DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1227. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1242. DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1249. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::db do failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1257. DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1374. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::st execute failed: Table 'Koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1410. DBD::mysql::st fetchrow failed: no statement executing DBD::mysql::db do failed: Table 'Koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1419. synch'ing borrowers creating column textmessaging creating column password creating column flags creating column userid creating column homezipcode creating column zipcode creating column sort1 creating column sort2 synch'ing items DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 1460. DBD::mysql::st fetchrow failed: no statement executing synch'ing biblio synch'ing biblioitems creating column place Can't call method "execute" on an undefined value at scripts/updater/updatedatabase line 1510. Problem updating database...

2 1

New document on kohadocs.org (Installing on Debian)
by Stephen Hedges 23 Mar '06

23 Mar '06

Joshua Ferraro has revised his document about installing Koha on Debian to accommodate Koha version 2.2.6 and Debian sarge (3.1). Find it on www.kohadocs.org under "System Administration." If you still need to know how to install older versions of Koha on Debian woody, those documents are still available, too -- substitute "Woody" (capital W) for "sarge" in the url for each type of document. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0

Re: z3950 questions
by Mohamed Imran K R 23 Mar '06

23 Mar '06

Hi marty, your problem may also be due to incompatible mysql server version ( we have already had that discussion on issues with mysql 4 series and the need to revert back). I dont think not starting MYSQL is a problem as your KOHA will not start and will send u a error status 500 message. Also check whether in the z3950-daemon-launch.sh script in line 35 u have given the correct user name. and do use some standard Z 39.50gateways like LOC, AMICUS,CARDIFF etc., Do check ur mysql tables containing the z39.50 result info like z3950results<http://192.168.1.6:10000/mysql/edit_table.cgi?db=Koha&table=z3950results>where KOHA stores all the MARC info u queried on and z3950queue<http://192.168.1.6:10000/mysql/edit_table.cgi?db=Koha&table=z3950queue>to find out if u form the right queries with the right parameters and maybe marc_breeding table too. Having the right MYSQL version should definitely make it work and do ckeck the tables. BestaLuck -- Regards Mohamed Imran K R

1 0

z3950 questions
by Marty Jongepier 23 Mar '06

23 Mar '06

Hi all, First of all, thanks, Stephen, for your fast and helpful responses. I am tackling my problems one by one,as I meet them I tried to do a Z39.50 search, but I had some trouble, and I am clueless as how to solve this. -Question 1, do I have to set up something to make the Z39.50 start automatically? I started it manually (basically because I was not convinced it was running) but if I try to do a cat on a log file, my computer says it doesn't exist or just returns to the command prompt(see below) does that mean they are empty? I was a bit puzzled (not uncommon for me, but even so, I like things to work) -Question 2, the logs that do return something give this output, again, see below. Anybody can give me a hint or help where to go from here? And thanks once again, Marty Jongepier debian:/usr/local/koha/intranet/scripts/z3950daemon# ./z3950-daemon-launch.sh debian:/usr/local/koha/intranet/scripts/z3950daemon# cd /usr/local/koha/log debian:/usr/local/koha/log# ls koha-access_log processz3950queue.pid z3950-daemon-20060321-2108.log koha-error_log z3950-daemon-20060320-2143.log z3950-daemon-20060321-2116.log opac-access_log z3950-daemon-20060320-2206.log z3950-daemon-20060321-2118.log opac-error_log z3950-daemon-20060320-2214.log debian:/usr/local/koha/log# cat z3950-daemon-2006321-2118.log cat: z3950-daemon-2006321-2118.log: No such file or directory debian:/usr/local/koha/log# cat z3950-daemon-2006321-2116.log debian:/usr/local/koha/log# debian:/usr/local/koha/log# cat *.log DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 140. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 143. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 148. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 149. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 140. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 143. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 148. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 149. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 140. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 143. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 148. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 149.

2 1

RE: [Koha] Bilingual interface
by Morgan, John D. 23 Mar '06

23 Mar '06

Hello, The site: http://koha.org/installation/support.html Seems to be in a 404 not found state. Does anyone know if there is a new one? Thanks, Derek

2 1

RE: [Koha] feature suggestions
by Bigwood, David 22 Mar '06

22 Mar '06

Brooke, The University of Pennsylvania is using tags in their library. I think the Ann Arbor Library District is also. It is not unknown. Freetag adds tagging to a MySQL database, same thing Koha uses. Should be able to use that as a starting place. http://www.getluky.net/2005/04/16/freetag-an-open-source-tagging-folkson omy-module-for-phpmysql-applications/ Personally, I'm not conviced of the usefullness of tagging in a small system. Tags work best when lots of folks tag lots of things. Maybe as a personal management system for folks it could be useful. If they tagged something an item toread_dpb, it could be useful for them if not a larger group. Rating an item is a different tool. Recommendations could also be useful but another tool. Trackbacks might be interesting, ping the library copy when discussing a book. Maybe trackbacks would work best for Open WorldCat rather than a local library. Again, a few pings scattered about the catalog would not be very useful. Sincerely, David Bigwood bigwood(a)lpi.usra.edu _____ From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of BWS Johnson Sent: Wednesday, March 22, 2006 11:05 AM To: Koha(a)lists.katipo.co.nz Subject: [Koha] feature suggestions Salvete! I try not to ask for stuff as I can't pay folks, but I'd love to see this. I'm not sure how feasible it would be, but I'll throw it out there anyway, because it could be something that would give Koha a leg up on a whole bunch of other products. I'm also not sure whether I blurted this out sometime in the past, or whether it's something that I've just been mulling over a long time, so I apologise if this is a dupe. If the traditional subject searching gets ironed out, I would love to see tag clouds implemented. How cool would it be to have patrons tag stuff and then be able to do an advanced or separate search on tag clouds to find related items? I don't think I've seen anything like this in any catalogue. People could also rate a given item like on digg. Does anyone know of folks using Koha on a consortial basis? I know that Stephen has different branches set up in Nelsonville so that a patron can find an item based on location. I also figure that folks could assign different usernames and passwords to different members of a consortium for cataloguing purposes. Is there a way to mess with the templates to reflect a different look for different libraries within a consortium? Is there a way to make Koha default to a given branch or library from within that site? I also noticed when I was spying on Stephen's catalogue that he owns Bleak House at the Athens branch. BUT if I title search on that at a different location, Koha doesn't yell at me that the material isn't at my branch, but is at another one in the system. Cheers, Brooke @ Hinsdale MA

1 0

feature suggestions
by BWS Johnson 22 Mar '06

22 Mar '06

Salvete! I try not to ask for stuff as I can't pay folks, but I'd love to see this. I'm not sure how feasible it would be, but I'll throw it out there anyway, because it could be something that would give Koha a leg up on a whole bunch of other products. I'm also not sure whether I blurted this out sometime in the past, or whether it's something that I've just been mulling over a long time, so I apologise if this is a dupe. If the traditional subject searching gets ironed out, I would love to see tag clouds implemented. How cool would it be to have patrons tag stuff and then be able to do an advanced or separate search on tag clouds to find related items? I don't think I've seen anything like this in any catalogue. People could also rate a given item like on digg. Does anyone know of folks using Koha on a consortial basis? I know that Stephen has different branches set up in Nelsonville so that a patron can find an item based on location. I also figure that folks could assign different usernames and passwords to different members of a consortium for cataloguing purposes. Is there a way to mess with the templates to reflect a different look for different libraries within a consortium? Is there a way to make Koha default to a given branch or library from within that site? I also noticed when I was spying on Stephen's catalogue that he owns Bleak House at the Athens branch. BUT if I title search on that at a different location, Koha doesn't yell at me that the material isn't at my branch, but is at another one in the system. Cheers, Brooke @ Hinsdale MA

1 0

Bilingual interface
by Bernuetz, Oliver: CBSC - WPG 22 Mar '06

22 Mar '06

Hi there, I apologize for asking something that's probably been asked before but is there a French-English interface available for Koha? Thanks, Oliver D. Bernuetz

1 0

install and configure it for the first time
by Morgan, John D. 21 Mar '06

21 Mar '06

Hello, I am quite new to Koha and am trying to install and configure it for the first time. I have loaded Debian, MySql, Apache and Perl. However, now I am trying to figure out how to load Koha itself. I download and burned to CD koha-2.2.5.tar.gz Now I am trying to figure out am I heading in the right direction? Un pack the tar file and install it? Thanks, New2Koha

2 1

Is there Chinese interface for Koha?
by Chi-Yu Huang 21 Mar '06

21 Mar '06

Hello, I've just installed Koha on Windows XP. I am pretty new to this software. I would like to build a library catalogue with Chinese (probably Japanese) materials. Could anyone please tell me if there is a Chinese interface for it? Can I input Chinese (or Japanese) characters into the system? Any suggestions will be much appreciated. Cheers, Chi-Yu

1 0