2.2.4 to 2.2.5 upgrade problem
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
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
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 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 ?) ?
-- Henri-Damien LAURENT
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
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
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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 >
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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 >>
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
participants (4)
-
Alex King -
Henri-Damien LAURENT -
Matthew Metzger -
Matthew Metzger