[Koha] Re: 2.2.4 to 2.2.5 upgrade problem

[Alex King]

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