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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha