Koha 3 not running, files don't exist?
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/
[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/
I don't know about the other errors, but this one looks like a problem with the yuipath system preference. I recommend this preference point to the Yahoo-hosted version unless there are bandwidth issues at your location: http://yui.yahooapis.com/2.5.1/build -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
On 2009/01/25, at 8:31 AM, Marty wrote:
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...
hmmm, opac-tmpl should be a directory, is yours not?
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!
you definitely seem to have a database issue either no db perms for your koha user, no database, or a database with very few tables or a typo for your dbname - in your koha conf file my advice, do new install - from a 'make clean; perl Makefile.PL' and try a 'dev' install for comparison,
The file not found errors are byproducts of the more fundamental database error. A lot of those paths should be controlled by system preferences that you appear not to have loaded. The important errors are: DBD::mysql::st execute failed: Unknown column any_table.any_field It's not just values, it seems the tables themselves aren't there. You could connect on the mysql command line and check with "show tables". Mason is right that repeating the install steps is probably the best way to go. --Joe On Sat, Jan 24, 2009 at 4:01 PM, Mason James <mason.loves.sushi@gmail.com>wrote:
On 2009/01/25, at 8:31 AM, Marty wrote:
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...
hmmm, opac-tmpl should be a directory, is yours not?
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!
you definitely seem to have a database issue
either no db perms for your koha user, no database, or a database with very few tables or a typo for your dbname - in your koha conf file
my advice, do new install - from a 'make clean; perl Makefile.PL'
and try a 'dev' install for comparison,
participants (4)
-
Joe Atzberger -
Marty -
Mason James -
Owen Leonard