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