mahara-contributors team mailing list archive

[Simon Story <simon.story@xxxxxxxxxxxxxxx>]

Hello all,

I've tested this with Mahara 1.5.1 on Windows Server 2008 R2 + IIS +
Postgresql 9.1.4 + PHP 5.3.13, and I can now search for users containing
diacritics without a problem.

I also tested this with Mahara 1.4 with the above environment and the
bug could replicated.

Running the database on an Ubuntu host but the PHP on Windows does work
around the problem.

This does not appear to have been a problem on Mahara on Ubuntu, at
least at Mahara version 1.4 it wasn't.

However (Always the way...) the registration email link does not work,
it throws a similar error. I will make a new bug report out of that.

-- 
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:
  Triaged

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/760546/+subscriptions