Rick Welykochy wrote:
After upgrading the database, the catalogue search still does not work. Every search on the OPAC quick search page returns the same result: one record, prolly the first in the biblio section of the database.
The tables are populated with records, as one would expect, e.g. here are some sample row counts:
Table biblio: 16473 rows Table biblio_framework: 0 rows Table biblioanalysis: 0 rows Table biblioitems: 16324 rows Table bibliosubject: 15820 rows Table bibliosubtitle: 3902 rows Table bibliothesaurus: 0 rows
Table branches: 10 rows Table items: 16448 rows
Table marc_biblio: 21234 rows Table marc_blob_subfield: 5458 rows Table marc_breeding: 348 rows Table marc_subfield_structure: 1107 rows Table marc_subfield_table: 455964 rows Table marc_tag_structure: 98 rows Table marc_word: 687694 rows
Table systempreferences: 67 rows
I am trying another search: that found on the Catalogue page in the (port 8080) Intranet area. The script is /cgi-bin/koha/MARCdetail.pl The symptoms in this case are much different. The browser never completes the request. This is because the web server goes into a tailspin, load average 6.0+, CPU at 100%, with mysql and perl churning away seemingly forever. Perhaps the query would have eventually stopped, but with the load avg climbing and the server brought to its knees I thought it best to terminate the web process before things got out of hand. Perhaps these symptoms might provide a bit more insight. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Any belief that can't stand up to objective scrutiny is hardly worth having. -- LJ McIntyre