- Koha - lists.katipo.co.nz

SMUG - Koha Rep?
by gsl 26 Jan '09

26 Jan '09

Any Koha users/reps/interested parties planning on attending the SMUG meeting in July 2009? If anybody besides me will be there maybe we could have a BOF or just dinner or something. Should I wear my new lime green Koha t-shirt? http://www.sirsimidwestusersgroup.org/ Greg Lawson Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 816-232-5479 x2303

1 0

Koha 3 not running, files don't exist?
by Marty 26 Jan '09

26 Jan '09

Okay, it has been a while since I have been here, I am on the road a lot for work. Back to Koha 3, I have the search page and librarian screens, but I cannot do anything with either. Search results are always "not found" and patrons don't exist. My /usr/share/koha/opac/htdocs/ only contains the opac-tmpl file... Below are the outputs of koha-opac-error_log and koha-error_log I do not know where to go from here, so any ideas are welcome. Running on debian etch. Thanks! Output of koha-opac-error_log [Sat Jan 24 13:42:23 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:42:23 2009] opac-main.pl: DBD::mysql::st execute failed: Unknown column 'categories.category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 536. [Sat Jan 24 13:42:24 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:42:23 2009] opac-main.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 537. [Sat Jan 24 13:42:29 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/opac/htdocs/utilities, referer: http://debian/ [Sat Jan 24 13:42:40 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/opac/htdocs/container, referer: http://debian/ [Sat Jan 24 13:42:45 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/opac/htdocs/menu, referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: DBD::mysql::st execute failed: Unknown column 'c.categorytype' in 'where clause' at /usr/share/koha/lib/C4/Branch.pm line 306., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /usr/share/koha/lib/C4/Branch.pm line 308., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: ---------, referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: Enter buildQuery, referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: --------- at /usr/share/koha/lib/C4/Search.pm line 863., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: TRUNCATION: NON:>paul< RIGHT:>< LEFT:>< RIGHTLEFT:>< REGEX:>< at /usr/share/koha/lib/C4/Search.pm line 1000., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: TRUNCATED OPERAND: >< at /usr/share/koha/lib/C4/Search.pm line 1041., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: STEMMED OPERAND: >< at /usr/share/koha/lib/C4/Search.pm line 1047., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: FIELD WEIGHTED OPERAND: >< at /usr/share/koha/lib/C4/Search.pm line 1054., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: QUERY BEFORE LIMITS: > paul< at /usr/share/koha/lib/C4/Search.pm line 1098., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: QUERY:paul at /usr/share/koha/lib/C4/Search.pm line 1161., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: QUERY CGI:q=paul at /usr/share/koha/lib/C4/Search.pm line 1162., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: QUERY DESC:paul at /usr/share/koha/lib/C4/Search.pm line 1163., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: LIMIT: at /usr/share/koha/lib/C4/Search.pm line 1164., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: LIMIT CGI: at /usr/share/koha/lib/C4/Search.pm line 1165., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: LIMIT DESC: at /usr/share/koha/lib/C4/Search.pm line 1166., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: ---------, referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: Leave buildQuery, referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: --------- at /usr/share/koha/lib/C4/Search.pm line 1167., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: DBD::mysql::st execute failed: Unknown column 'imageurl' in 'field list' at /usr/share/koha/lib/C4/Search.pm line 1223., referer: http://debian/ [Sat Jan 24 13:43:07 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:43:07 2009] opac-search.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Search.pm line 1224., referer: http://debian/ [Sat Jan 24 13:43:08 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/opac/htdocs/utilities, referer: http://debian/cgi-bin/koha/opac-search.pl?q=paul [Sat Jan 24 13:43:19 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/opac/htdocs/container, referer: http://debian/cgi-bin/koha/opac-search.pl?q=paul [Sat Jan 24 13:43:32 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/opac/htdocs/menu, referer: http://debian/cgi-bin/koha/opac-search.pl?q=paul Output of koha-error_log [Sat Jan 24 13:44:14 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/utilities, referer: http://debian:8080/ [Sat Jan 24 13:44:18 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/button, referer: http://debian:8080/ [Sat Jan 24 13:44:21 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/container, referer: http://debian:8080/ [Sat Jan 24 13:44:25 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/menu, referer: http://debian:8080/ [Sat Jan 24 13:44:50 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:50 2009] mainpage.pl: DBD::mysql::st execute failed: Unknown column 'branches.branchprinter' in 'field list' at /usr/share/koha/lib/C4/Auth.pm line 620., referer: http://debian:8080/ [Sat Jan 24 13:44:50 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:50 2009] mainpage.pl: DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/share/koha/lib/C4/Auth.pm line 634., referer: http://debian:8080/ [Sat Jan 24 13:44:50 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:50 2009] mainpage.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 13:44:50 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:50 2009] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 13:44:51 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/utilities, referer: http://debian:8080/ [Sat Jan 24 13:44:55 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:55 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 13:44:55 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:55 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 13:44:55 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/button, referer: http://debian:8080/ [Sat Jan 24 13:44:58 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:58 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 13:44:58 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:44:58 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 13:44:58 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/container, referer: http://debian:8080/ [Sat Jan 24 13:45:02 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:02 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 13:45:02 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:02 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 13:45:02 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/menu, referer: http://debian:8080/ [Sat Jan 24 13:45:05 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:05 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 13:45:05 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:05 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: DBD::mysql::st execute failed: Unknown column 'c.categorytype' in 'where clause' at /usr/share/koha/lib/C4/Branch.pm line 306., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /usr/share/koha/lib/C4/Branch.pm line 308., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: ---------, referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: Enter buildQuery, referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: --------- at /usr/share/koha/lib/C4/Search.pm line 863., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: TRUNCATION: NON:>matthew< RIGHT:>< LEFT:>< RIGHTLEFT:>< REGEX:>< at /usr/share/koha/lib/C4/Search.pm line 1000., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: TRUNCATED OPERAND: >< at /usr/share/koha/lib/C4/Search.pm line 1041., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: STEMMED OPERAND: >< at /usr/share/koha/lib/C4/Search.pm line 1047., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: FIELD WEIGHTED OPERAND: >< at /usr/share/koha/lib/C4/Search.pm line 1054., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: QUERY BEFORE LIMITS: > matthew< at /usr/share/koha/lib/C4/Search.pm line 1098., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: QUERY:matthew at /usr/share/koha/lib/C4/Search.pm line 1161., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: QUERY CGI:q=matthew at /usr/share/koha/lib/C4/Search.pm line 1162., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: QUERY DESC:matthew at /usr/share/koha/lib/C4/Search.pm line 1163., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: LIMIT: at /usr/share/koha/lib/C4/Search.pm line 1164., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: LIMIT CGI: at /usr/share/koha/lib/C4/Search.pm line 1165., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: LIMIT DESC: at /usr/share/koha/lib/C4/Search.pm line 1166., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: ---------, referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: Leave buildQuery, referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: --------- at /usr/share/koha/lib/C4/Search.pm line 1167., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: DBD::mysql::st execute failed: Unknown column 'imageurl' in 'field list' at /usr/share/koha/lib/C4/Search.pm line 1223., referer: http://debian:8080/ [Sat Jan 24 13:45:28 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:28 2009] search.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Search.pm line 1224., referer: http://debian:8080/ [Sat Jan 24 13:45:30 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/utilities, referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:33 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:33 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:33 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:33 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:33 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/button, referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:37 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:37 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:37 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:37 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:37 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/container, referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:40 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:40 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:40 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:40 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:40 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/menu, referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:44 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:44 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 13:45:44 2009] [error] [client 127.0.0.1] [Sat Jan 24 13:45:44 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/cgi-bin/koha/catalogue/search.pl?q=matthew [Sat Jan 24 14:07:16 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:16 2009] mainpage.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359. [Sat Jan 24 14:07:16 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:16 2009] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368. [Sat Jan 24 14:07:17 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/utilities, referer: http://debian:8080/ [Sat Jan 24 14:07:22 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:22 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 14:07:22 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:22 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 14:07:22 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/button, referer: http://debian:8080/ [Sat Jan 24 14:07:26 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:26 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 14:07:26 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:26 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 14:07:26 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/container, referer: http://debian:8080/ [Sat Jan 24 14:07:29 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:29 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 14:07:29 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:29 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/ [Sat Jan 24 14:07:29 2009] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/menu, referer: http://debian:8080/ [Sat Jan 24 14:07:33 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:33 2009] 404.pl: DBD::mysql::st execute failed: Unknown column 'category_type' in 'field list' at /usr/share/koha/lib/C4/Members.pm line 359., referer: http://debian:8080/ [Sat Jan 24 14:07:33 2009] [error] [client 127.0.0.1] [Sat Jan 24 14:07:33 2009] 404.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Members.pm line 368., referer: http://debian:8080/

4 3

KohaCon 2009 - information about the conference and Registration
by David Schuster 26 Jan '09

26 Jan '09

Sorry for any cross or double posting just trying to get the word out in as many ways as possible. KohaCon 2009 Registration KohaCon 2009 will be held in Plano, TX April 16 and 17. This is a FREE conference. There is no registration fee, but we are requesting that all attendees pre-register. Details (travel, hotels, agenda draft, etc) can be found at: Koha WIKI: http://wiki.koha.org/doku.php?id=kohacon2009 There is a "Tentative Schedule" - it will change as more people sign up probably for programs. Travel information along with Hotel accomodation information. Lunch and dinners will be on your own. Feel free to contact any of the three people listed on the Wiki at the top or email me directly. David Schuster -- View this message in context: http://www.nabble.com/KohaCon-2009---information-about-the-conference-and-R… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Article "Why you can't find a library book in your search engine"
by Owen Leonard 26 Jan '09

26 Jan '09

"Why you can't find a library book in your search engine" http://www.guardian.co.uk/technology/2009/jan/22/library-search-engines-boo… I remember a time at our library when our (2.x) Koha server was getting hit by Google so much that we had to block access. It was necessary at the time so that we could continue to do business at a reasonable pace, but I wonder if Koha 3 is better equipped to handle that kind of abuse? "The National Library of Sweden has put its entire catalogue on the web as linked data, the first effort by a national library to become part of the semantic web." I guess I don't keep up well enough with the issue to understand the technical meaning of "linked data." What would Koha have to do to fit the definition? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 1

KohaCon 2009 - information about the conference and Registration
by dschust1＠tx.rr.com 26 Jan '09

26 Jan '09

KohaCon 2009 Registration KohaCon 2009 will be held in Plano, TX April 16 and 17. This is a FREE conference. There is no registration fee, but we are requesting that all attendees pre-register. Details (travel, hotels, agenda draft, etc) can be found at: Koha WIKI: http://wiki.koha.org/doku.php?id=kohacon2009 There is a "Tentative Schedule" - it will change as more people sign up probably for programs. Travel information along with Hotel accomodation information. Lunch and dinners will be on your own. Feel free to contact any of the three people listed on the Wiki at the top or email me directly. David Schuster

1 0

Help wanted importing bib records from Horizon to Koha
by Rodney.Foley＠utas.edu.au 26 Jan '09

26 Jan '09

3 2

Out of office
by howard_dahdah＠idg.com.au 24 Jan '09

24 Jan '09

1 0

Too Many renewals
by kevin smith 23 Jan '09

23 Jan '09

In KOHA 3 when I issue anything to a borrower, it shows as Too Many renewals, even though no renewals have been made and the item type is set up to allow 2 renewals. Have a missed something in configuration? Thanks, -- Kevin Smith Assistant Director Cass District Library AND The Fiddling Librarian: http://ashkev.weblogs.us

2 1

CPAN Error
by Uma Mukkamala 23 Jan '09

23 Jan '09

My internet runs on Proxy. I am trying to set the CPAN. I have given the Proxy IP Address. But still i am getting upto the follwing point and structed up. Select your continent (or several nearby continents) [] 7 invalid items entered, try again Select your continent (or several nearby continents) [] 2 invalid items entered, try again Select your continent (or several nearby continents) [] Sorry! since you don't have any existing picks, you must make a geographic selection. Select your continent (or several nearby continents) [] Sorry! since you don't have any existing picks, you must make a geographic selection. Select your continent (or several nearby continents) [] Caught SIGINT (1) Africa invalid items entered, try again Select your continent (or several nearby continents) [] Got another SIGINT Please, help me out. Thanks & Regards, Uma Sankar Mobile : +91 9967007817 "Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s). are confidential. and may be privileged. If you are not the intended recipient. you are hereby notified that any review. re-transmission. conversion to hard copy. copying. circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient. please notify the sender immediately by return email. and delete this message and any attachments from your system. Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email. The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."

1 1

Koha 3 Reset Database
by David Riggs 22 Jan '09

22 Jan '09

Hello, I'm a very-new Koha user, and have a fresh installation of Koha 3.00.00 on Ubuntu 8.04. I initially choose to have the sample data installed out of the box, but would now like to try the application out using semi-real data. A search turned up only info for older versions, so I'll pose this question: What is the best way to reset or "wipe" the database clean in Koha 3, while (optionally) retaining configuration settings? Thanks! - DR -- david a. riggs software engineer, createTank mailto:riggs@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com

1 0