[Koha-win32] issue between koha 2.5 and mysql 5.0

[Partha Mukhopadhyay]

Hello Dana,

I would like to have your advice on another MySQL related problem. MySQL
5x suppors Unicode. Can I keep the default charset as UTF-8. This is
required in view of the following problem with MySQL 3x:

I'm doing Bengali Version of Koha (Bengali is an Indic script spoken by
around 270 m people in West Bengal - a major state in India and
Bangladesh). I have developed a complete theme that provides Bengali
language based interface, data entry, retrival and ISO-2709 based
export/import. But at the core of the database (i.e. MySQL) the records
are getting saved as HTML special characters e.g Bengali letter Kaa is
saved as ক - The Unicode value of Bengali Kaa is 2453. Although as
everythin in Koha is over the web interface, the characters and scripts
are displayed properly and even export/import operation can also be
performed in the Bengali script. Here lies my aim to use MySQL 5x to see
whether records are getting stored in native scripts or as HTML special
characters.

Awaiting for ur valuable advice

Partha



  ----- Original Message -----
  From: "P. S. Mukhopadhyay"
  To: Koha-win32 at nongnu.org
  Subject: Re: [Koha-win32] issue between koha 2.5 and mysql 5.0
  Date: Fri, 1 Sep 2006 13:41:28 +0530

  Hello Dana, Thanks a lot for your informative posting. Hope I can now
  solve the problem by following your instructions. Partha

  On 8/29/06, Dana Huff <dana at sefovan.org> wrote:

    There are indeed several issues with running Koha on MySQL 5.0
    and not just
    with Windows so I'm posting this on the Koha general list also.

    First, to log in to Koha you need to make some changes to your
    MySQL
    authentication. With the default installation you will get
    something like:

    >> DBI connect('mycomputer:localhost','koha',...) failed: Client
    does not
    support
    >> authentication protocolrequested by server; consider upgrading
    MySQL
    client at
    >> C:\usr\koha225\modules/C4/Context.pm line 409.

    You can overcome the problem by editing line 1808 of Install.pm
    from:

    print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into
    user
    (Host,User,Password) values
    ('$hostname','$user',password('$pass'))\" mysql\;");

    to:

    print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into
    user
    (Host,User,Password) values
    ('$hostname','$user',OLD_PASSWORD('$pass'))\" mysql\;");

    (Thanks to Andrew Koebrick ( Andrew.Koebrick at state.mn.us) for
    that solution.)

    Or, of course, you can execute the mysql command manually to do
    the same
    thing if you don't use the install script and which you probably
    didn't do
    to install Koha on Windows; anyway, that is what I did.

    Then there is a new reserved word in MySQL 5 – "return" which is
    used as a
    field name in the issues table in Koha. So in any place that is
    referenced
    it must be enclosed in single quotes, or back-quotes. I haven't
    found an
    instance of that in the Koha modules or scripts but I'm still
    looking. It
    will be an issue if you write any of your own sql scripts for
    ad-hoc
    reporting.

    Finally, there are a couple of modules that must be modified
    because of
    changes in the SQL syntax rules with MySQL 5. Theses are in
    intranet/modules/C4:

    Search.pm
    918c918
    <

    on additionalauthors.biblionumber =biblio.biblionumber
    ---
    >

    on (additionalauthors.biblionumber =biblio.biblionumber)
    989c989
    <
    biblio.biblionumber=bibliosubtitle.biblionumber
    ---
    >
    (biblio.biblionumber=bibliosubtitle.biblionumber)
    1305c1305
    < left join
    itemtypes on biblioitems.itemtype = itemtypes.itemtype
    ---
    > left join
    itemtypes on (biblioitems.itemtype = itemtypes.itemtype)
    1494c1494
    <

    from biblio, biblioitems
    ---
    >

    from biblioitems, biblio
    1496,1497c1496,1497
    <

    biblio.biblionumber = bibliosubtitle.biblionumber
    <

    left join itemtypes on
    biblioitems.itemtype=itemtypes.itemtype
    ---
    >

    (biblio.biblionumber = bibliosubtitle.biblionumber)
    >

    left join (itemtypes on
    biblioitems.itemtype=itemtypes.itemtype )


    SearchMarc.pm
    344,346c344,346
    <

    FROM biblio, marc_biblio
    <

    LEFT JOIN biblioitems on biblio.biblionumber =
    biblioitems.biblionumber
    <

    LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype
    ---
    >

    FROM marc_biblio, biblio
    >

    LEFT JOIN biblioitems on (biblio.biblionumber =
    biblioitems.biblionumber)
    >

    LEFT JOIN itemtypes on (itemtypes.itemtype=biblioitems.itemtype)

    That seems to have taken care of my problems. We now have Koha
    2.2.5 working
    with MySQL 5.0 at our installation.

    Dana Huff
    Madrid, Spain
    dana at sefovan.org

    ________________________________________
    From: koha-win32-bounces+dana=sefovan.org at nongnu.org
    [mailto:koha-win32-bounces+dana=sefovan.org at nongnu.org ] On
    Behalf Of P. S.
    Mukhopadhyay
    Sent: Tuesday, August 29, 2006 8:18 AM
    To: Koha-win32 at nongnu.org
    Subject: Re: [Koha-win32] need help



    Hello friends,

    Is any one of us using MySQL 5.0 as backend RDBMS for Koha on
    Windows? I'm
    running it through MySQL 3.23.58 but facing problems with MySQL
    5.x. What is
    the problem? Pl. suggest.

    Partha
    DLISc, Vidyasagar University

    _______________________________________________
    Koha-win32 mailing list
    Koha-win32 at nongnu.org
    http://lists.nongnu.org/mailman/listinfo/koha-win32




  _______________________________________________
  Koha-win32 mailing list
  Koha-win32 at nongnu.org
  http://lists.nongnu.org/mailman/listinfo/koha-win32

-- 
__________________________________________________
Now you can search for products and services
http://search.mail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-win32/attachments/20060901/29200202/attachment-0001.htm>