[Koha] No tables found after my installation

[Krishnan Mani]

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 at gmail.com> wrote:
From: sony george <geosony at gmail.com>
Subject: [Koha] No tables found after my installation
To: koha at 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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha



      Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20081106/b1cc7020/attachment.htm