Using koha 3.10.4 If I run a 'MARC bibliographic framework test' I get this: -------------------------- MARC bibliographic framework test Test Result itemnum The field itemnum MUST be mapped The corresponding subfield MUST be in with -1 (ignore) tab OK All item fields are in the same tag and in item tab OK Only 1 MARC tag mapped to items OK biblioitems.itemtype defined homebranch NOT mapped the items.homebranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have authorised value=branches holdingbranch NOT mapped the items.holdingbranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have authorised value=branches OK at least 1 item type defined OK at least 1 library defined biblio and biblionumber The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield, OK no NULL value in frameworkcode subfields not in same tabs Not all subfields for the following tags are in the same tab (or marked 'ignored'). Code Description Tag Tabs in use Default framework 999 1,0 NEW new 999 1,0 OK all authority types used in the frameworks are defined TOTAL You have 5 error(s) in your MARC configuration. Please fix them before using Koha ------------------------------- I'm trying to fix the homebranch first. I choose 'koha to marc mapping' -> items -> and see that homebranch is mapped to '952 a Permanent location'. Tried saving it to something else as well. nothing sees to fix the error. same issue with holdingbranch Why am I getting this error in my marc framework and is there anyway to fix it? Any queries I could run on the db as a test? Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Marc-framework-errors-tp5751439.html Sent from the Koha-general mailing list archive at Nabble.com.
This is probably to specific a problem to be useful to anyone but here goes: This problem was caused by a bug in how 'Toad For mysql' deals with tiny int values in version 6.3.0.642. When I exported marc_subfield_structure from a clean koha and imported into my upgraded koha I got the error above. I later learned that toad exported the the 'tab' field as only 0 or 1, but it should have contained values 0-10. I decided to use the heidiSQL administrator to do the export/import and my marc framework turned out perfect. -- View this message in context: http://koha.1045719.n5.nabble.com/Marc-framework-errors-tp5751439p5751898.ht... Sent from the Koha-general mailing list archive at Nabble.com.
At 10:44 AM 4/22/2013 -0700, rfblanchard wrote:
This is probably to specific a problem to be useful to anyone but here goes: This problem was caused by a bug in how 'Toad For mysql' deals with tiny int values in version 6.3.0.642. When I exported marc_subfield_structure from a clean koha and imported into my upgraded koha I got the error above. I later learned that toad exported the the 'tab' field as only 0 or 1, but it should have contained values 0-10. I decided to use the heidiSQL administrator to do the export/import and my marc framework turned out perfect.
A colleague raised this with me (separate project) a couple of months ago. Apparently Toad has some glitches with MySQL 5.5 (the most popular release???) but was fairly reliable on previous versions. What version are you using? Just curious, but why use Toad? Dump and restore are relatively trivial; from my notes: *** change date on dump filename as required *** Backup [dump] : /$ mysqldump --user=koha --password=****** koha385 > /mnt/data1/backup/koha385dump_21_apr_13.sql Restore : /$ mysql --user=koha --password=****** koha385 < /mnt/data1/backup/koha385dump_21_apr_13.sql and a 2 line shell script allows you to make this into a CRON job as soon as you're happy it works to your liking :} Best regards, Paul
participants (2)
-
Paul -
rfblanchard