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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
