Some kind of Table Problem?
Hello, thank you for the help with Acquisitions. My systems parameters are now set. But there seems to be more trouble. As we install the sampledata we had the following problems: 1. "Biblio" table (as installed by Koha) seems to miss one column. Actual installation has: biblionumber author title unititle notes serial seriestitle copyrightdate timestamp 2. some other tables seems to be missing (ethnicity, shelfcontents, bookshelf) I have some trouble to complete the whole acquisition process with the "normal" interface and also with the Catalogue Search (at the librarians interface). Should I install Koha again? Veronica Lencinas Errorlog: [Tue Nov 26 18:15:48 2002] [error] [client 200.16.22.190] script not found or unable to stat: /u sr/local/koha/intranet/cgi-bin/acqui/whitcoulls.html DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Search.pm line 877, <KC> line 20. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 880, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 9 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 138, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 150, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 161, <KC> line 30. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 9 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 138, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 150, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 161, <KC> line 30. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 231, <KC> line 40. DBD::mysql::st execute failed: You have an error in your SQL syntax near ')' at line 2 at /usr/l ocal/koha/intranet/modules/C4/Biblio.pm line 238, <KC> line 40. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Search.pm line 760, <KC> line 10. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 763, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'and biblioitems.biblio number=' at line 7 at /usr/local/koha/intranet/modules/C4/Search.pm line 841, <KC> line 20. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 842, <KC> line 20. Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html
On Tue, 26 Nov 2002, [iso-8859-1] Veronica Lencinas wrote:
thank you for the help with Acquisitions. My systems parameters are now set. But there seems to be more trouble.
It looks like the database tables never got updated. Did you use the installer script or the manual installation instructions? If manual, did you run the updatedatabase.pl script to update the database? This script should be located in your Koha installation directory under: /usr/local/koha/intranet/scripts/updater/updatedatabase.pl and should be run as: perl -I /usr/local/koha/intranet/modules updatedatabase.pl Steve.
participants (2)
-
Tonnesen Steve -
Veronica Lencinas