Problems modifying a new record
Hi all, We have recently installed Koha at our school, and today our librarian ran into some trouble when she tried to modify a new entry. This server is not available on the internet except via ssh (text mode). I poked around the database using mysql after she reported this problem: ============================================================================== I used the marc lookup and imported the file for Charlie Horse/Mrs. White's Secret Sock. I modified the data before saving. It set up the biblio for the book, plus my item number 5658. Then I later realized that I wanted to add one more subject to the subject listing. I looked up Charlie Horse in the catalog. I clicked on it which gave me the Biblio. I clicked on modify. Even though the biblio showed subject lines, the subject lines were missing on the modify screen! I input the one it wanted to add and clicked the query(save) button. Normally it flips me to the new modified biblio, but this time it only brought up a blank biblio. I again looked up Charlie Horse in the catalog. This time before trying to add the new subject, I realized that when I added it to the catalog in the first place I caused an accidental mispelling to the title. I tried to fix that only, but with no more success than when I had tried to add the subject line. Finally I decided that I would delete the entire thing and start again. I had to first delete my item number 5658. Then I deleted the biblio. At that point both the book title and item number no longer showed up when I searched the catalog. So I assumed everything had been erased out and went to start all over again on the book. But the computer would act like the biblio was already there and prompt me for an item number. It would act like it was taking the item number -- no error messages or warnings that the number was already in use. But then when I would look up Charlie Horse, the title was there but it refused to say that there was an item in the library. ============================================================================== I don't really know my way around in MySQL - just enough to be dangerous. And I really don't know how the db is laid our in Koha. Here's what I found/did. I found that the original biblionumber for the "Charlie Horse" book was 934, and the new one had a biblionumber of 940. biblioitems and bibliosubject both still had entries for biblionumber 934, which I deleted. The items table still had an entry for biblionumber="934", but no entry for biblionumber="940". So I did an update items set biblionumber = "940" where barcode="5658"; Which seemed to partially fix the problem. After I did this, she tried to do a dummy checkout of the book, but it couldn't find it. Can anyone advise me at this point? Are there other tables I need to modify? Should I refrain from manipulating the db with mysql (yes)? -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas@bittware.com http://www.bittware.com (703) 779-7770 I thought I was wrong once, but I was mistaken.
On Tue, Jan 14, 2003 at 03:36:04PM -0500, Jim Thomas said:
Hi all,
We have recently installed Koha at our school, and today our librarian ran into some trouble when she tried to modify a new entry. This server is not available on the internet except via ssh (text mode). I poked around the database using mysql after she reported this problem:
Hi Jim Just a quick question, what version of koha are you running? Whichever version it is, it sounds like there is definitely a bug in the modify biblio code, ill take a look but i wont to be looking at the right version :-) Oh and if you are poking around the DB, here is a diagram that may or may not help http://developer.koha.org/koha.png Specifically how the biblio/biblioitems and items fit together. Hope this is some help Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Chris Cormack wrote:
Just a quick question, what version of koha are you running?
Hi Chris, Thanks for responding so quickly. We're running 1.2.2
Whichever version it is, it sounds like there is definitely a bug in the modify biblio code, ill take a look but i wont to be looking at the right version :-)
Oh and if you are poking around the DB, here is a diagram that may or may not help http://developer.koha.org/koha.png Specifically how the biblio/biblioitems and items fit together.
Hope this is some help
I'm sure it will. Thanks for the pointer. -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas@bittware.com http://www.bittware.com (703) 779-7770 I thought I was wrong once, but I was mistaken.
In article <3E2474B4.E05D744B@bittware.com>, Jim Thomas <jthomas@bittware.com> wrote:
I used the marc lookup and imported the file for Charlie Horse/Mrs. White's Secret Sock. I modified the data before saving. It set up the ^ biblio for the book, plus my item number 5658.
The book title has an apostrophe; this looks like Bug 148. Bug 148 is listed as affecting Koha 1.2.3, so 1.2.2 will be affected as well. -- Ambrose Li <a.c.li@ieee.org> http://ada.dhs.org/~acli/cmcc/ http://www.cccgt.org/ DRM is theft - We are the stakeholders
"acli@ada.dhs.org via news-to-mail gateway" wrote:
In article <3E2474B4.E05D744B@bittware.com>, Jim Thomas <jthomas@bittware.com> wrote:
I used the marc lookup and imported the file for Charlie Horse/Mrs. White's Secret Sock. I modified the data before saving. It set up the ^ biblio for the book, plus my item number 5658.
The book title has an apostrophe; this looks like Bug 148. Bug 148 is listed as affecting Koha 1.2.3, so 1.2.2 will be affected as well.
That sounds like it then. Now that I know about it, we can avoid apostrophe's in the future, or we can fix the bug (is there a patch?). Is there a way to clean up the mess it made? Thinking that apostophes are not that uncommon in book titles led me to try this: select title from biblio where title LIKE "%'%"; Which returned 112 rows. Do I need to do something to fix them, or will a patch address this? -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas@bittware.com http://www.bittware.com (703) 779-7770 A pessimist is an optimist with experience
On Wed, Jan 15, 2003 at 01:04:10PM -0500, Jim Thomas said:
The book title has an apostrophe; this looks like Bug 148. Bug 148 is listed as affecting Koha 1.2.3, so 1.2.2 will be affected as well.
That sounds like it then. Now that I know about it, we can avoid apostrophe's in the future, or we can fix the bug (is there a patch?).
1.2.3 will fix this bug when its released, i can work on a patch for 1.2.2 if youd like, but 1.2.3 isnt to far away.
Is there a way to clean up the mess it made?
Thinking that apostophes are not that uncommon in book titles led me to try this: select title from biblio where title LIKE "%'%";
Which returned 112 rows. Do I need to do something to fix them, or will a patch address this?
A patch will address it, it will be a simple case of the ' not being escaped in the sql statement. Ill take a look after work tonight. Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Mandi! Chris Cormack In chel di` si favelave...
1.2.3 will fix this bug when its released, i can work on a patch for 1.2.2 if youd like, but 1.2.3 isnt to far away.
Note thet for non-english language, and in particulary Italian, this patches are absolutely needed. Our language are apostrophe-addicted. ;) -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) gaio(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797 Difendiamo PeaceLink! Campagna di solidarietà per la tutela legale di una voce scomoda. http://www.peacelink.it/emergenza/
On Thu, Jan 16, 2003 at 10:03:05AM +0100, Marco Gaiarin said:
Mandi! Chris Cormack In chel di` si favelave...
1.2.3 will fix this bug when its released, i can work on a patch for 1.2.2 if youd like, but 1.2.3 isnt to far away.
Note thet for non-english language, and in particulary Italian, this patches are absolutely needed.
Our language are apostrophe-addicted. ;)
I have some good news for you :-) 1.2.3rc26 is out and available for download from sourceforge. Complete with the fix :-) Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Chris Cormack wrote:
On Thu, Jan 16, 2003 at 10:03:05AM +0100, Marco Gaiarin said:
Mandi! Chris Cormack In chel di` si favelave...
1.2.3 will fix this bug when its released, i can work on a patch for 1.2.2 if youd like, but 1.2.3 isnt to far away.
Note thet for non-english language, and in particulary Italian, this patches are absolutely needed.
Our language are apostrophe-addicted. ;)
I have some good news for you :-) 1.2.3rc26 is out and available for download from sourceforge. Complete with the fix :-)
OK, I downloaded 1.2.3rc26, untarred it, and found a koha.upgrade script. Is there anything I should know before I run it (I'm trying to upgrade from 1.2.2)? -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas@bittware.com http://www.bittware.com (703) 779-7770 Air conditioning may have destroyed the ozone layer - but it's been worth it!
participants (4)
-
acli＠ada.dhs.org via news-to-mail gateway -
Chris Cormack -
Jim Thomas -
Marco Gaiarin