[Koha] patron categories [bulkmarcimport]

[Tomas Cohen Arazi]

Eric, the problem seems to be MySQL 5.6, I haven't got through a detailed
review (I don't have it for testing right now) but there are several
changes since MySQL 5.5, notably several default configurations and other
backwards incompatible changes [1].

I recommend that you downgrade to MySQL 5.5, or better install on top of
Ubuntu LTS/Debian Wheeze. I recommend Ubuntu 12.04 Server. And follow the
official instructions [2].

Also, I'd like you to fill a bug in our tracker
http://bugs.koha-community.org
Name it something like 'Webinstaller fails to load sql data on MySQL 5.6'.
Please paste the errors you saw, not all of them, but a representative
example.

Hopefully we can find a solution for this. Unfortunately not everyone might
be interested as the vast majority of the devs, so please be patient, or
ask for advise on the bug itself if you want to provide a fix yourself.

Best regards
Tomás

[1]
http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html
[2] http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages
El jul 4, 2014 4:59 PM, "Eric Lease Morgan" <eric_morgan at infomotions.com>
escribió:

>
> On Jul 4, 2014, at 3:16 PM, Eric Lease Morgan <eric_morgan at infomotions.com>
> wrote:
>
> >>>  $ bulkmarcimport.pl -file /tmp/pamphlets.marc
> >>>
> >>> And for each record in pamphlets.marc I get the following error:
> >>>
> >>>  .DBD::mysql::st execute failed: Field 'marcxml' doesn't have a
> >>>  default value at /usr/local/koha/lib/C4/Biblio.pm line 3222,
> >>>  <GEN15> line 1465.
> >>>  ERROR in _koha_add_biblioitem INSERT INTO biblioitems SET
> >>
> >> Looks like you have an incomplete/broken DB schema. Have you already
> populated sensitive data? Otherwise i'd drop the database, create an empty
> one, and use the webinstaller to create the correct one.
> >
> > Maybe I can initialize my koha database by hand?
>
>
> I tried populating my database with many .sql files found in
> installer/data/mysql. Examples included but were not limited to:
>
>   * mysql -uroot -p koha < kohastructure.sql
>   * mysql -uroot -p koha < sysprefs.sql
>   * mysql -uroot -p koha < en/mandatory/auth_values.sql
>   * ...
>
> I then reconnected via the Web interface, and was prompted to do
> installation, again. (Bummer). It seemed to import things, again, but with
> the same errors as before, plus a few more about duplicate values. After
> this I was still not able to create patron profiles, etc.
>
> I then tried to import the sample z39.50 servers:
>
>   $ mysql -uroot -p koha < sample_z3950_servers.sql
>
> And I got this error:
>
>   ERROR 1364 (HY000) at line 1: Field 'description' doesn't have a default
> value
>
> I then hacked sample_z3950_servers.sql to add a description field and look
> like this:
>
>   INSERT INTO z3950servers
>   (description,host, port, db, userid, password, name, checked, rank,
> syntax, encoding,recordtype) VALUES
>   ('foobar', 'lx2.loc.gov',210,'LCDB','','','LIBRARY OF
> CONGRESS',1,1,'USMARC','utf8','biblio’);
>
> I then imported the sample z3950 file, again. Next, using the Web
> interface, I was (successfully) able to search the Library of Congress.
> After identifying a record of interest, I tried to import it, but failed
> miserably because there were a whole bunch of fields missing. I was finally
> stymied when I could not select a value in Tab #9 for "Koha [default] item
> type”.
>
> I’m not giving up!
>
> —
> Eric Lease Morgan
>
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>