[Koha] Re: 2.2.4 to 2.2.5 upgrade problem

[Matthew Metzger]

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