mahara-contributors team mailing list archive

[Adrian Kapias <760546@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Mahara version 1.2.5 (same behaviour seen with installation of version 1.3.3)
platform is Windows 2003 server, PostgreSQL, IIS +PHP version 5.2.11

Every time I try to search in Mahara any user name containing national
characters (e.g. nováková) only error page shows up.

"A nonrecoverable error occured. This probably means you have
encountered a bug in the system"

Searching names without national characters works OK.

In PHP error log (see attached logfile) i have noticed this:

Failed to get a recordset: postgres7 error: [-1: ERROR:  invalid byte
sequence for encoding "UTF8": 0xe3a16b

HINT:  This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".] in EXECUTE("...

Database in PostgreSQL was created using following command:
CREATE DATABASE ...
  WITH OWNER = ....
       ENCODING = 'UTF8'
       LC_COLLATE = 'Czech, Czech Republic'
       LC_CTYPE = 'Czech, Czech Republic'
       CONNECTION LIMIT = -1;

When i checked inside PostgreSQL database tables in Mahara i had found
that username "nováková" is saved correctly.

I had already set and checked client_encoding=UTF8 variable for
postgresql, even tried to set default_charset=UTF-8 variable in php.ini.

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/760546

Title:
  Cannot search users with Czech characters (UTF-8 problem?)

Status in Mahara ePortfolio:
  New

Bug description:
  Mahara version 1.2.5 (same behaviour seen with installation of version 1.3.3)
  platform is Windows 2003 server, PostgreSQL, IIS +PHP version 5.2.11

  Every time I try to search in Mahara any user name containing national
  characters (e.g. nováková) only error page shows up.

  "A nonrecoverable error occured. This probably means you have
  encountered a bug in the system"

  Searching names without national characters works OK.

  In PHP error log (see attached logfile) i have noticed this:

  Failed to get a recordset: postgres7 error: [-1: ERROR:  invalid byte
  sequence for encoding "UTF8": 0xe3a16b

  HINT:  This error can also happen if the byte sequence does not match
  the encoding expected by the server, which is controlled by
  "client_encoding".] in EXECUTE("...

  Database in PostgreSQL was created using following command:
  CREATE DATABASE ...
    WITH OWNER = ....
         ENCODING = 'UTF8'
         LC_COLLATE = 'Czech, Czech Republic'
         LC_CTYPE = 'Czech, Czech Republic'
         CONNECTION LIMIT = -1;

  When i checked inside PostgreSQL database tables in Mahara i had found
  that username "nováková" is saved correctly.

  I had already set and checked client_encoding=UTF8 variable for
  postgresql, even tried to set default_charset=UTF-8 variable in
  php.ini.