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