Hi I'm using version 2.2.9 on Ubuntu Feisty with mysql 5.0 When running buildnonmarc.pl to fix koha/marc linking I get the following error message after record the script cycles through: </collection> at /usr/local/koha/intranet/modules/C4/Biblio.pm line 597. .DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./rebuildnonmarc.pl line 98. DBD::mysql::st execute failed: Column 'biblionumber' cannot be null at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1924. XML : <?xml version="1.0" encoding="UTF-8"?> <collection Should I log this under bugs/database in Bugzilla? Or is this not a bug, possible a misconfiguration? If so any idea where to look, what to try? TIA, Bo
Hi Bo, I'm guessing it's a misconfiguration. I'd check to make sure you have a mapping in place for biblio.subtitle in your MARC framework. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS ----- "Bo Schafers" <bo@weavebrain.com.au> wrote:
Hi I'm using version 2.2.9 on Ubuntu Feisty with mysql 5.0
When running buildnonmarc.pl to fix koha/marc linking I get the following error message after record the script cycles through:
</collection> at /usr/local/koha/intranet/modules/C4/Biblio.pm line 597. .DBD::mysql::db do failed: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1 at ./rebuildnonmarc.pl line 98. DBD::mysql::st execute failed: Column 'biblionumber' cannot be null at
/usr/local/koha/intranet/modules/C4/Biblio.pm line 1924. XML : <?xml version="1.0" encoding="UTF-8"?> <collection
Should I log this under bugs/database in Bugzilla? Or is this not a bug, possible a misconfiguration? If so any idea where to look, what to try?
TIA, Bo _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi All, Joshua M. Ferraro wrote:
I'm guessing it's a misconfiguration.
Yes, it was, thanks J! After a good night's sleep I had another look at this and seem to have found the solution. It was staring me in the face (error message) -Duh: DBD::mysql::st execute failed: Column 'biblionumber' cannot be null [snip]... Solution: ******** In Koha:Marc Links ~biblioitems tab biblioitems.biblionumber ---------> set to 090c biblioitems.biblioitemnumber ----> set to 090d Notes: ***** -Both subfields had to be set to 'ignore', not '-1' for the Marc Check Utility to be satisfied with the 'syntax' -The Liblime installation does not have these settings. biblioitems.biblionumber in the ~biblioitems tab of Koha:Marc Links is *not* set (This is what threw me 'cos I check every one of my settings against theirs). Dunno why..too esoteric for me at the moment. Anyhoo.....I now have full editing ability and syncing of Marc and Koha fields. One step closer to a production system. Bo
----- "Bo Schafers" <bo@weavebrain.com.au> wrote:
Hi All,
Joshua M. Ferraro wrote:
I'm guessing it's a misconfiguration.
Yes, it was, thanks J! After a good night's sleep I had another look at this and seem to have found the solution. It was staring me in the face (error message) -Duh:
DBD::mysql::st execute failed: Column 'biblionumber' cannot be null [snip]...
Solution: ******** In Koha:Marc Links ~biblioitems tab biblioitems.biblionumber ---------> set to 090c biblioitems.biblioitemnumber ----> set to 090d
Notes: ***** -Both subfields had to be set to 'ignore', not '-1' for the Marc Check
Utility to be satisfied with the 'syntax' -The Liblime installation does not have these settings. biblioitems.biblionumber in the ~biblioitems tab of Koha:Marc Links is
*not* set (This is what threw me 'cos I check every one of my settings
against theirs). Dunno why..too esoteric for me at the moment.
Anyhoo.....I now have full editing ability and syncing of Marc and Koha fields. One step closer to a production system. Congrats!
-- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
participants (2)
-
Bo Schafers -
Joshua M. Ferraro