[Koha] new koha installation not working properly

[Alex King]

This is probably the MySQL5 issue.  Are you running on MySQL 5?  Koha 
2.2.5 won't run out of the box with it.

See http://lists.katipo.co.nz/public/koha/2006/010477.html

That message describes three issues, an authentication issue, the 
"return" reserved word, and a couple of query fixes.

I didn't find I needed the authentication fix.  I suspect that it is 
only needed for upgrading an existing Koha db, not new installs.

OTOH, the "return" reserved word does affect new installs, in the SQL 
file used for initialising MySQL it appears (once from memory) 
unquoted.  You will need to modify that file and quote the field name 
(return) with single quotes, and reinstall Koha (or at least 
re-initialise the database - if you want to be sure your db structure is 
100% correct)

You also need to modify the two search module files as mentioned.  They 
are what is preventing the biblios displaying.

Alternatives would be to downgrade MySQL or pull Koha 2.2.6 from CVS 
(which I would assume has the fixes).

Cheers,

Alex

khayos wrote:
> Hello,
>
> I've got a new Koha installation that is behaving rather oddly.  I
> should say that, to begin with, the database tables
> 'systempreferences' and 'itemtypes' did not exist -- I had to create
> them manually.  Subsequently, I had to populate 'systempreferences'
> with as many of the entries that I could find, but I suspect I haven't
> got them all, or that some of the settings are incorrect.
>
> At any rate, the problem appears to be that, once I add a biblio
> record to the system, I can't see it.  I try searching for it, and I
> get a blank screen: nothing shows up when I try to display using
> 'normal', 'marc', or 'isbd'.  What should I be looking for?  Does
> anyone know what might have gone wrong during the installation
> process?  I certainly didn't see anything amiss...
>
> Further detail:
> Koha version: 2.2.5
> Operating system: Xubuntu (descendent of Debian)
>
> Any help at all that can be offerred will be greatly appreciated.
>
> Cheers,
> JR
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha