<span dir="ltr"></span><div class="gmail_quote"><div>Hello Friend Krishnan,<br><br>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.<br>
<br>Thank you,<br><br>Sony George<br>Cochin<br> <br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Message: 1<br>
Date: Thu, 6 Nov 2008 12:42:22 +0530 (IST)<br>
From: Krishnan Mani <<a href="mailto:krishnanm75@yahoo.com">krishnanm75@yahoo.com</a>><br>
Subject: Re: [Koha] No tables found after my installation<br>
To: <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>
Message-ID: <<a href="mailto:628750.20899.qm@web95008.mail.in2.yahoo.com">628750.20899.qm@web95008.mail.in2.yahoo.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Sony,<br>
<br>
1) An empty database is a well-known problem.<br>
<br>
You will need to manually create the tables. Thankfully, this is done very easily. You need to use a command like<br>
<br>
mysql -u {kohauser} -D {koha-database} -p < {/path/to/extracted/koha}/installer/data/mysql/kohastructure.sql<br>
<br>
(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.<br>
<br>
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.<br>
<br>
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)<br>
<br>
Keep at it, you are very close to the finish line, and its all worth it once you have Koha up and running!<br>
<br>
Thanks and regards,<br>
<br>
<br>
<br>
krishnan mani<br>
<br>
Pune, India<br>
<br>
--- On Thu, 6/11/08, sony george <<a href="mailto:geosony@gmail.com">geosony@gmail.com</a>> wrote:<br>
From: sony george <<a href="mailto:geosony@gmail.com">geosony@gmail.com</a>><br>
Subject: [Koha] No tables found after my installation<br>
To: <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>
Date: Thursday, 6 November, 2008, 12:15 PM<br>
<br>
Hello friends,<br>
<br>
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.<br>
<br>
<br>
After running the Makefile.PL i got these warnings at the end.<br>
<br>
Warning: prerequisite Algorithm::CheckDigits 0.5 not found.<br>
Warning: prerequisite Biblio::EndnoteStyle 0.05 not found.<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Data::ICal 0.13 not found.<br>
<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Date::ICal 1.72 not found.<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Email::Date 1.103 not found. We have 1.102.<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite GD 2.39 not found. We have 2.35.<br>
<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite HTML::Template::Pro 0.69 not found.<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite Lingua::Stem 0.82 not found.<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite MARC::Charset 0.98 not found.<br>
<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite MARC::Crosswalk::DublinCore 0.02 not found.<br>
[Sat Nov? 1 11:47:43 2008] Makefile.PL: Warning: prerequisite MARC::File::XML 0.88 not found.<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite PDF::Reuse 0.33 not found.<br>
<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite PDF::Reuse::Barcode 0.05 not found.<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite POE 0.9999 not found. We have 0.9989.<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite SMS::Send 0.05 not found.<br>
<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Schedule::At 1.06 not found.<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Text::CSV 0.01 not found.<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Text::CSV_XS 0.32 not found. We have 0.30.<br>
<br>
[Sat Nov? 1 11:47:45 2008] Makefile.PL: Warning: prerequisite Text::Iconv 1.7 not found. We have 1.5.<br>
<br>
<br>
will those missing packages mirrors the empty database ?? Help me friends, i am new to koha.<br>
<br>
Thank you,<br>
<br>
<br>
Sony George<br>
<br>
<br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br>
<br>
</blockquote></div><br>