[Koha] Re: 2.2.4 to 2.2.5 upgrade problem

[Matthew Metzger]

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