Why are you getting the 'table does not exist' problems? Did you verify that the database was created properly and has all the tables? The koha installer does not do this, you'll need to do this yourself with a command like mysql -u <user> -D <databaseName> -p < /path/to/extracted/koha/installer/data/mysql/kohastructure.sql followed by logging into mysql and checking if around 116 tables were created in the database. Also, don't forget to check that MySQL is using UTF-8 before creating the database. regards, krishnan ________________________________ From: Ulrich Kretschmer <U.Kretschmer@bergruf.de> To: koha@lists.katipo.co.nz Sent: Monday, 22 December, 2008 7:40:42 AM Subject: [Koha] installation help for KOHA 3.0 Hi, can anybody help me to get the installation process finished? Thanks Ulrich Kretschmer Am Sonntag, 14. Dezember 2008 23:26 schrieb Ulrich Kretschmer:

while trying to install Koha 3.0 on openSUSE 11.0, I get the message "production mode - trapped fatal error" while opening the intranet address.

/var/log/koha/koha-error_log says:

[Sun Dec 14 23:09:11 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:11 2008] Reserves.pm: DBD::mysql::db selectrow_array failed: Tabelle 'koha.systempreferences' existiert nicht at /usr/share/koha/lib/C4/Context.pm line 479. (=> mysql table does not exist)

[Sun Dec 14 23:09:11 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:11 2008] mainpage.pl: DBD::mysql::st execute failed: Tabelle 'koha.auth_types' existiert nicht at /usr/share/koha/lib/C4/Koha.pm line 341. (=> mysql table does not exist)

[Sun Dec 14 23:09:11 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:11 2008] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Koha.pm line 342.

(...) (tons of complaints because of non-existing database tables)

[Sun Dec 14 23:09:16 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:16 2008] 404.pl: Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 443. => okay, the redirect to cgi-bin/koha/installer/install.pl works fine

[Sun Dec 14 23:09:16 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:16 2008] install.pl: DBD::mysql::st execute failed: Tabelle 'koha.language_subtag_registry' existiert nicht at /usr/share/koha/lib/C4/Languages.pm line 178. (=> mysql table does not exist)

[Sun Dec 14 23:09:16 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:16 2008] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Languages.pm line 179.

[Sun Dec 14 23:09:16 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:16 2008] install.pl: DBD::mysql::db selectrow_array failed: Tabelle 'koha.systempreferences' existiert nicht at /usr/share/koha/lib/C4/Context.pm line 479. (=> mysql table does not exist)

[Sun Dec 14 23:09:16 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:16 2008] install.pl: Use of uninitialized value $debug_level in string eq at /usr/share/koha/lib/C4/Context.pm line 45. ??? => Help needed

[Sun Dec 14 23:09:16 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:16 2008] install.pl: Use of uninitialized value $debug_level in string eq at /usr/share/koha/lib/C4/Context.pm line 45. ??? => Help needed

[Sun Dec 14 23:09:16 2008] [error] [client 127.0.0.1] [Sun Dec 14 23:09:16 2008] install.pl: Can't call method "id" on an undefined value at InstallAuth.pm line 278. ??? => Help needed

Can please anybody help me what I have to do to continue and complete the installation process? (How to fix the $debug_level problem?)

Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha From Chandigarh to Chennai - find friends all over India. Go to http://in.promos.yahoo.com/groups/citygroups/

On Mon, Dec 22, 2008 at 4:25 AM, vimal laxman <vimallaxman@gmail.com> wrote:

hi all, i am a newbie to Koha and Mysql i have installed koha 3.0 sucessfully without any of the dependency issues.but still unable to perform som of the basic functionalitie like

1.Unable to search books using OPAC .it says No results found .does it have any thing to with my database and encoding(iam using mysql5).

You probably have not built/rebuilt the index. This question is the single most frequently asked question on the Koha list. Use the "rebuild_zebra.pl -a -b -z" script.

2.there is a koha wiki page " http://wiki.koha.org/doku.php?id=encodingscratchpad" which talks about "Changing Default Character Sets for MARC21 libraries using UTF-8" Is it necessary that i should so it since it is specified for an earlies version of koha i believe since the table name that are mentioned are not found in the Koha database

It is very important to get encoding issues correct. But if you had a proper UTF-8 database setup before loading data you do not need to follow the additional steps in that section. That section is only useful for people who loaded UTF-8 data into a non-UTF8 (probably latin1) database.

3.i created a patron and he is unable to place a hold on a book.the koha error log says .

Mon Dec 22 02:11:12 2008] [error] [client 127.0.0.1] File does not exist: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/img/toolbar-hold.gif, referer: http://127.0.0.1:8080/intranet-tmpl/prog/en/css/staff-global.css.

This error is not really related. It just says there is a missing gif image file referenced by CSS. Depending on the version of Koha, the holds problem may be related to the lack of itemtype data.

4.I have added some books to the database .i tried to "checkout" one of them.i inititally changed the items.barcode field to refer to ISBN .and tried entering the ISBN number of a book in the check out field .but it returns "Barcod not found".

It sounds like you are talking about having manipulated the frameworks. This is an erroneous way to proceed and will not provide a reliable system. Among other things, you would not be able to have more than 1 copy of a book and autobarcoding will break. Many publishers have mistakenly reused the same ISBN, so your database would be unable to accomodate both items. This kind of setup should be avoided. It is not worth trying to "save" printing barcodes in this way. --Joe Atzberger

Hi , Thank you so much for your response.i am basically new to perl and Mysql.I believe i have sucessufully installed koha 3.0 on debian without any dependency issues and all the modules seem to work fine.I think i have not made myself clear in the las mial.here are my issues : 1.when i search for books through OPAC it says 'no results found' in catalogue(i have a few books which i imported using Z39.50 search)and error log says" biblio erro 109'.I know this is a basic issue but still i could not find out a right solution.i followed all the instructions that were give in the INSTALL.debian file.devolopers in the community say it is a databse related issue.if so can you let me know how to check whether my database is set to right encoding for Koha 3.0 to read. I have run misc/migration_tools/rebuild_zebra.pl -a -b -r quite a number of times whenever i update a new record it say the total number of record updated.no problem. 2.I dont have a barcode reader with me here.i wish to do the 'Check IN' and 'Check OUT' manually.one person suggested me that i map the barcode field in Administration->Koha to MARC Mapping->items->Barcode to a field of our choice .so i mapped it to ISBN.and i tried to Check Out a particular Patron by manually entering the ISBN number of a particular book that is available in the database.It says 'Barcode not foud'.is it possible for us to do it manually through keyboard withour using barcode reader ?. 3.i found through liblime demo that any staff/patron can place a hold on a particular book.but when i try to do the same in mine there seems to be no respnse in the page.only the koha administrator is able to hold a particular book.i had given permissions to the Staff/Patron to do so but still it does not work.If this is a bug How do i fix this. I hope i have made myself clear. Please do excuse me if some of these are basic and help me to solve these problems. Thanks in advance for your reply, regards, vimal Laxman P On Mon, Dec 22, 2008 at 6:22 PM, Ulrich Kretschmer <U.Kretschmer@bergruf.de>wrote:

Hi,

thanks for your friendly help...

Am Montag, 22. Dezember 2008 07:56 schrieb Krishnan M:

...

Why are you getting the 'table does not exist' problems?

Did you verify that the database was created properly and has all the tables? The koha installer does not do this, you'll need to do this yourself with a command like

mysql -u <user> -D <databaseName> -p < /path/to/extracted/koha/installer/data/mysql/kohastructure.sql

Well, I thought the installer would do this. As far as I can see, this required installation step seems to be undocumented. Should be added to the installation documentation. (I hope somebody from Koha project members reads this...)

My tables are now present and looking fine. But again I get the message "production mode - trapped fatal error" while opening the intranet address.

The log file says now:

[Mon Dec 22 23:33:16 2008] [error] [client 127.0.0.1] [Mon Dec 22 23:33:16 2008] mainpage.pl: Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 443. => okay

[Mon Dec 22 23:33:17 2008] [error] [client 127.0.0.1] [Mon Dec 22 23:33:17 2008] install.pl: Use of uninitialized value $debug_level in string eq at /usr/share/koha/lib/C4/Context.pm line 45. => ???

[Mon Dec 22 23:33:17 2008] [error] [client 127.0.0.1] [Mon Dec 22 23:33:17 2008] install.pl: Use of uninitialized value $debug_level in string eq at /usr/share/koha/lib/C4/Context.pm line 45. => ???

[Mon Dec 22 23:33:17 2008] [error] [client 127.0.0.1] [Mon Dec 22 23:33:17 2008] install.pl: Can't call method "id" on an undefined value at InstallAuth.pm line 278. => ???

Any ideas how I can repair the $debug_level problem??

I've looked into the Context.pm source code. Line 443 checks for this variable's value. But I can't find the place where this value should have been defined before.

Thanks for more help

Ulrich _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Thanks Joe, I made it at last.The problem was that the zebra daemon was not running.i folowe option 2 for running the zebra process as daemon.then i tried option 1 as indicted in the Installation document and the search engine worked. and about the barcode stuff i did the same way as you told me to .it had some problems initially like the items location was not defined and item type was not getting saved properly.after a few strugle i was able to Check out the book sucessfully. Now that i have to add some of the books manually because they are not available online.indoing that i have customized my framework to just a few key fields.but when i entered them manually and tried to save them the application gives an error saying "cannot be saved with Tag =''".it says i have left some of the subfilds empty but i made sure that i have entered the data for all the fields and subfields. could sny one suggest me a way to enter this manually. regards, vimal On Tue, Dec 23, 2008 at 12:06 PM, Joe Atzberger <ohiocore@gmail.com> wrote:

Vimal --

On Tue, Dec 23, 2008 at 5:02 AM, vimal laxman <vimallaxman@gmail.com>wrote:

...

1.when i search for books through OPAC it says 'no results found' in catalogue(i have a few books which i imported using Z39.50 search)and error log says" biblio erro 109'.I know this is a basic issue but still i could not find out a right solution.i followed all the instructions that were give in the INSTALL.debian file.devolopers in the community say it is a databse related issue.if so can you let me know how to check whether my database is set to right encoding for Koha 3.0 to read.

When you run rebuild_zebra you have to remember to set and export KOHA_CONF and PERL5LIB, but it sounds like you have done this. Then, check your zebra logs for additional information about the errno 109.

...

2.I dont have a barcode reader with me here.i wish to do the 'Check IN' and 'Check OUT' manually.one person suggested me that i map the barcode field in Administration->Koha to MARC Mapping->items->Barcode to a field of our choice .so i mapped it to ISBN.and i tried to Check Out a particular Patron by manually entering the ISBN number of a particular book that is available in the database.It says 'Barcode not foud'.is it possible for us to do it manually through keyboard withour using barcode reader ?.

I have already responded in this thread why it would be a bad idea to try to use ISBN. Even if you don't have a barcode scanner, it will still be more reliable and easier for you to use a self-generated barcode manually than to use the ISBN. Even if you don't have a printer and you just use a typewriter or a pencil, it will be easier than trying to use the ISBN. If you use incremental barcodes, then instead of having to key in at least 10 digits, it would be as small a number of keystrokes as possible.

hi all, Thank you Mr.krishnan for your valuable advice on customizig the framework. iam trying to integerate SIP2 with my Koha installation .its giving the follwing error *""MarkIssueReturned" is not exported by the C4::Circulation module'*".i tried some of the patches suggested on the net but without sucess.can anybody help me out. regards, vimal On Mon, Dec 29, 2008 at 11:20 AM, Krishnan M <kmlist@yahoo.in> wrote:

Vimal,

In customizing your framework, you would have encountered the list of MARC fields. (by clicking on 'Marc Structure' against your framework)

One of the columns in this table (between 'repeatable' and 'auth value') states whether the particular field is "Mandatory" or not. For e.g., 000 Leader is almost always mandatory

Unfortunately, this table cannot be 'sorted' by its columns, so there is no alternative but to run through several screens to find out which of the 900+ fields are currently mandatory. You can then edit the sub-fields and un-check that 'mandatory' option. Perhaps there's a simple database query that will give you the answer, but i don't have access to a database right now to send you one.

i have very little cataloging experience, but i would caution you against arbitrary decisions on toggling a mandatory tag to make it optional.

Generally, for example, with the leader tag itself, Koha itself will generate a value for the tag while cataloging, if you click within the box or on the ellipsis next to one. But, clearly, this is just a set of defaults that does not necessarily make sense, so you may end up with a tag that has very little relevant information in it.

As a non-librarian that encountered cataloging when using Koha, i was mightily irritated to come up short against mandatory tags that i could not make sense of..

regards, krishnan

------------------------------ *From:* vimal laxman <vimallaxman@gmail.com> *To:* Joe Atzberger <ohiocore@gmail.com> *Cc:* koha@lists.katipo.co.nz *Sent:* Monday, 29 December, 2008 12:09:27 PM *Subject:* Re: [Koha] installation help for KOHA 3.0

Thanks Joe, I made it at last.The problem was that the zebra daemon was not running.i folowe option 2 for running the zebra process as daemon.then i tried option 1 as indicted in the Installation document and the search engine worked. and about the barcode stuff i did the same way as you told me to .it had some problems initially like the items location was not defined and item type was not getting saved properly.after a few strugle i was able to Check out the book sucessfully. Now that i have to add some of the books manually because they are not available online.indoing that i have customized my framework to just a few key fields.but when i entered them manually and tried to save them the application gives an error saying "cannot be saved with Tag =''".it says i have left some of the subfilds empty but i made sure that i have entered the data for all the fields and subfields.

could sny one suggest me a way to enter this manually.

regards, vimal

On Tue, Dec 23, 2008 at 12:06 PM, Joe Atzberger <ohiocore@gmail.com>wrote:

...

Vimal --

On Tue, Dec 23, 2008 at 5:02 AM, vimal laxman <vimallaxman@gmail.com>wrote:

...

1.when i search for books through OPAC it says 'no results found' in catalogue(i have a few books which i imported using Z39.50 search)and error log says" biblio erro 109'.I know this is a basic issue but still i could not find out a right solution.i followed all the instructions that were give in the INSTALL.debian file.devolopers in the community say it is a databse related issue.if so can you let me know how to check whether my database is set to right encoding for Koha 3..0 to read.

When you run rebuild_zebra you have to remember to set and export KOHA_CONF and PERL5LIB, but it sounds like you have done this. Then, check your zebra logs for additional information about the errno 109.

...

2.I dont have a barcode reader with me here.i wish to do the 'Check IN' and 'Check OUT' manually.one person suggested me that i map the barcode field in Administration->Koha to MARC Mapping->items->Barcode to a field of our choice .so i mapped it to ISBN.and i tried to Check Out a particular Patron by manually entering the ISBN number of a particular book that is available in the database.It says 'Barcode not foud'.is it possible for us to do it manually through keyboard withour using barcode reader ?.

I have already responded in this thread why it would be a bad idea to try to use ISBN. Even if you don't have a barcode scanner, it will still be more reliable and easier for you to use a self-generated barcode manually than to use the ISBN. Even if you don't have a printer and you just use a typewriter or a pencil, it will be easier than trying to use the ISBN. If you use incremental barcodes, then instead of having to key in at least 10 digits, it would be as small a number of keystrokes as possible.

------------------------------ Add more friends to your messenger and enjoy! Invite them now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/>

_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha