Hello Friend Krishnan, I did as you said, you are absolutely right, now my databse is filled with 116 tables. i want to install all other missing perl modules and will try again. You are a dedicated koha user. Thank you, Sony George Cochin Message: 1

Date: Thu, 6 Nov 2008 12:42:22 +0530 (IST) From: Krishnan Mani <krishnanm75@yahoo.com> Subject: Re: [Koha] No tables found after my installation To: koha@lists.katipo.co.nz Message-ID: <628750.20899.qm@web95008.mail.in2.yahoo.com> Content-Type: text/plain; charset="utf-8"

Hi Sony,

1) An empty database is a well-known problem.

You will need to manually create the tables. Thankfully, this is done very easily. You need to use a command like

mysql -u {kohauser} -D {koha-database} -p < {/path/to/extracted/koha}/installer/data/mysql/kohastructure.sql

(Fill in your values for all things in {}). This is the typical location for the sql script that creates tables, and this hardly takes a few seconds.

Once you run this, connect manually to the koha database in MySQL, do a 'show tables;' and verify that you have around 120 tables created.

2) Fixing the database will not solve the problem with missing modules. You must install them all (or as many of them as you can manage)

Keep at it, you are very close to the finish line, and its all worth it once you have Koha up and running!

Thanks and regards,

krishnan mani

Pune, India

--- On Thu, 6/11/08, sony george <geosony@gmail.com> wrote: From: sony george <geosony@gmail.com> Subject: [Koha] No tables found after my installation To: koha@lists.katipo.co.nz Date: Thursday, 6 November, 2008, 12:15 PM

Hello friends,

My koha database is empty after installing koha-3.0.0 in my fedora 8 system.. i found the error? -- mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/local/koha/lib/C4/Context.pm line 479 -- in the error log. what will be the problem.

After running the Makefile.PL i got these warnings at the end.

Warning: prerequisite Algorithm::CheckDigits 0.5 not found. Warning: prerequisite Biblio::EndnoteStyle 0.05 not found. [Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Data::ICal 0.13 not found.

[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Date::ICal 1.72 not found. [Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Email::Date 1.103 not found. We have 1.102. [Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite GD 2.39 not found. We have 2.35.

[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite HTML::Template::Pro 0.69 not found. [Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Lingua::Stem 0.82 not found. [Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite MARC::Charset 0.98 not found.

[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite MARC::Crosswalk::DublinCore 0.02 not found. [Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite MARC::File::XML 0.88 not found. [Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite PDF::Reuse 0.33 not found.

[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite PDF::Reuse::Barcode 0.05 not found. [Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite POE 0.9999 not found. We have 0.9989. [Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite SMS::Send 0.05 not found.

[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Schedule::At 1.06 not found. [Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Text::CSV 0.01 not found. [Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Text::CSV_XS 0.32 not found. We have 0.30.

[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Text::Iconv 1.7 not found. We have 1.5.

will those missing packages mirrors the empty database ?? Help me friends, i am new to koha.

Thank you,

Sony George

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