mahara-contributors team mailing list archive

[Adrian Kapias <760546@xxxxxxxxxxxxxxxxxx>]

Hello François,

thanks for your reply.
Today (26.4.2011) i had downloaded and upgraded version 1.3.3. to the latest 1.4.0alphadev2 version.

Unfortunately still the same situation -> A nonrecoverable error occured. This probably means you have encountered a bug in the system.
Same error message in the PHP logfile.

What's really strange is the fact that the creation of new user containing diacritics (characters like á č ý í ) goes perfectly OK.
As you can see (attachment) from the screenshot taken directly from PostgreSQL database table named 'usr'.

But every time i tried to search (in Mahara) username with diacritics (
'ukázkový' in this example) ends with errror message.

To be honest hint from PHP error logfile about "invalid byte sequence
for encoding "UTF8"" is not helpful either. As database was created
using UTF-8 encoding.

Don't know if it is some peculiarity based on our setup (windows server
2003, IIS, PostgreSQL)

Thanks in advance for any clues
Adrian


** Attachment added: "user with diacritics in database"
   https://bugs.launchpad.net/mahara/+bug/760546/+attachment/2089764/+files/user-with-diacritics-in-database.png

-- 
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.