1 Topic by xorock (edited by xorock 2008-03-23 15:59)

  • Registered: 2008-03-23
  • Posts: 1

Topic: Can't add new post

Hi. I'm new to punbb and I'm also having some problems.
I'm using polish (utf-8) translation + postgresql 8.3.1 (with database encoding utf8). Php is also configured for utf8. Now, when I try add new post punbb throws error:

File: /srv/www/domain/public_html/include/search_idx.php
Line: 132

PunBB reported: Unable to fetch search index words

Database reported: ERROR: invalid byte sequence for encoding "UTF8": 0xe5bc6c 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".

Failed query: SELECT id, word FROM forum_search_words WHERE word IN('something','umo?liwiaj?cy')

What should I do?

edit: Oh. I see You don't support multibyte. For now I have manually added /u to all preg_ functions but is there a better way to do this?

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Can't add new post

Well, you could grab a copy of 1.3 (which does support UTF-8) from SVN and test that if you wanted, it would be useful to get more feedback on it from a PostgreSQL/UTF-8 perspective. You shouldn't be using that on a production site though, since it's beta software.
Otherwise, I'm not really sure. Adding /u to preg_* functions isn't the only change required to get PunBB 1.2 working properly with UTF-8.

3 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: Can't add new post

Should it be trying to use the search index if running UTF8? The search function bypasses the index for UTF8/multibyte searches, does it not?

MattF's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Can't add new post

This is for inserting search words for posts, not searching.

5 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: Can't add new post

My apologies. smile

MattF's Website