[Koha] Re: 2.2.4 to 2.2.5 upgrade problem

[Matthew Metzger]

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
>>>       
>
>