[Koha] Re: 2.2.4 to 2.2.5 upgrade problem

[Matthew Metzger]

Thanks Alex,

I made the changes in those two files (Search.pm and SearchMarc.pm) and 
Koha now works with MySQL5!

Thanks so much for your help.

-Matthew




Alex King wrote:
> The details of the fix are at 
> http://lists.katipo.co.nz/public/koha/2006/010477.html
> 
> Two files need to be modified, Search.pm and SearchMarc.pm, see the 
> details in the post.  The change is relatively straightforward for 
> anyone with any kind of programming background, the post contains a 
> diff.  You can manually edit the files to change them - that's what I 
> did and my install is working fine.
> 
> In general it is a larger change to downgrade from MySQL5 to MySQL4 than 
> it is to change a couple of files in Koha.  However, if you're more 
> familiar with apt and MySQL4 is available in your version of Ubuntu, you 
> might feel more comfortable with than than editing perl files.
> 
> Matthew Metzger wrote:
>> Alex,
>>
>> your guess is a good one. I checked in the versions of MySQL and the 
>> old (working) server is using 4.1.12 and the new (non-working) server 
>> is using 5.0.22.
>>
>> Do you recommend that I remove MySQL5 and then install MySQL4? Or do 
>> you recommend trying to change the database so that it works with 
>> MySQL5? I'm thinking just going back to 4 would be easier as this is a 
>> new install, but any suggestions would be welcome.
>>
>> thanks for your help.
>>
>> -Matthew
>>
>>
>>
>> Alex King wrote:
>>> 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
>>>>>>>>