Just a thought. Are you being hit by the 2.2.5 and earlier MySQL5 incompatibility? Ie, do you have MySQL5 installed on your Ubuntu machine? If so there was a recent post to this list specifying one or two where the mysql queries needed to be modified to work right with MySQL5 Cheers, Alex Matthew Metzger wrote:
I un-installed koha and then reinstalled it, being careful to choose Marc21 during the install process. I still get the same result. The fields turn up blank when searching for books in the opac. It returns the right number of records (the data is there), but it doesn't show up in the opac. As shown in: http://matthew.metzger.cc/wiki/index.php?title=Koha_upgrade_problem
marc_tag_structure. 108 total rows - same on old working and new non-working installations
marc_subfield_structure 1134 total rows - same on old working and new non-working installations
biblio 2754 total rows - same on old working and new non-working installations
marc_biblio 2754 total rows - same on old working and new non-working installations
thanks for your help.
-Matthew
when viewing marc_subfield_structure in phpmyadmin, there are warning messages on the bottom of the page. They say "PRIMARY and INDEX keys should not both be set for column `frameworkcode`" and "More than one INDEX key was created for column `frameworkcode`". I don't think that it matters because it says the same things on the koha installation on the older server that is working properly.
Matthew Metzger wrote:
I set it up over a year ago, so I'm not entirely sure, but I think it's Marc21 because that is the format [syntax] of the z39.50 servers that I have listed in the Parameters section of the admin. I'll have to do some digging for your questions concerning the database.
thanks for the tips.
-Matthew
Henri-Damien LAURENT wrote:
What MARC flavour do you use (if you use any) ? How many records do you have in marc_tag_structure, in marc_subfield_structure, in biblio, in marc_biblio, in biblio, in items (before and after upgrade. Is there a difference ?) ?
Matthew Metzger a écrit :
I've been working several days on this and I still don't have any results. After restoring the database, searching in the opac returns blank table cells. The data is there because I browsed the books in the database with phpmyadmin. I've uninstalled koha and installed 2.2.4 (that's the version that the database was from), dropped and restored the database, did a lot of research, but I still haven't fixed this problem.
The problem is visually shown on: http://matthew.metzger.cc/wiki/index.php?title=Koha_upgrade_problem
Any help would be greatly appreciated. thanks,
Matthew Metzger
Matthew Metzger wrote:
Hello,
I've set up an extra koha server using the process described in my koha on ubuntu guide. http://matthew.metzger.cc/wiki/index.php?title=Install_Koha_on_Ubuntu_6.06
The old database was on koha 2.2.4, the new installation is 2.2.5
I have inserted my database by deleting the default database created by the set up, creating a new empty database named Koha, and then using "mysql -uroot -p Koha < 2006_09_21_koha.sql" to insert the database that I had dumped from my other koha installation on the old server.
Everything seems to work great and the data seems to be there, but when I search for items in the opac, they just don't show up. It lists the correct number of results, but the fields are just blank. I have put screen shots up at the url below.
http://matthew.metzger.cc/wiki/index.php?title=Koha_upgrade_problem
I also ran the updater script after adding the line "use lib '/usr/local/koha/intranet/modules';" directly under the "#Koha modules" line near the beginning of the script. Running the script seemed to fail. Here's the output:
sudo ./updatedatabase ----------- connected to your DB. Checking & modifying it Could convert to MyISAM database tables... Alter encoding in marc_breeding Alter printername in printers Alter bookfundid in aqbookfund DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at ./updatedatabase line 1186. Alter aqbudgetid in aqbudget DBD::mysql::st execute failed: Invalid default value for 'id' at ./updatedatabase line 1186. Alter id in z3950servers synch'ing borrowers synch'ing items synch'ing biblio synch'ing biblioitems Checking for data required in table userflags... Checking for data required in table systempreferences... -----------
Any help would be greatly appreciated. Thanks.
-Matthew
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha