1 Topic by eger

  • eger
  • Junior Member
  • Offline
  • Registered: 2006-04-26
  • Posts: 3

Topic: Unable to insert search index words

Hi,

I saw there was a Traditional Chinese language pack for punbb and punbb is very simple and clean and I am trying to use it for a chinese board. The database collation is big5_chinese_ci. I have been having some problems registering users and making posts (the error was about a collation mismatch between big5 and latin1, forget exact error).

Now I am not getting those errors, and users can register. But when testing post I get this error:

File: /usr/home/jc/www/worldscreen/forums/include/search_idx.php 
 Line: 149 
  
 PunBB reported: Unable to insert search index words  
  
 Database reported: Duplicate entry '測試ä¸' for key 1 (Errno: 1062)

I'm guessing this might have something to do with the db collation.

Anyone have any idea what might cause this? Is big5 compatable with punbb (I assumed it was since there was a Traditional CHinese pack).

Thanks for help!

2 Reply by Smartys (edited by Smartys 2006-04-26 23:42)

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

Re: Unable to insert search index words

I'd suggest making sure "word" in the search_words table is set as varbinary (or varchar with a binary attribute)
Like Rickard explains here

3 Reply by eger

  • eger
  • Junior Member
  • Offline
  • Registered: 2006-04-26
  • Posts: 3

Re: Unable to insert search index words

Yes, that was part of it!

After some more searching I found all the info here: http://punbb.org/forums/viewtopic.php?id=9146

This thread explains the modifications needed. I had to drop all the tables, set my default collation to utf8_unicode_ci, and reinstall punbb to make all the tables correct collation. Then the 'word' field modification and the addition to common_db.php worked and everything is displaying correctly now.

Though it will be nice when other sections like Admin section can alsu use language pack.

This forum is very nice and clean open source board. I like it as a better alternative to phpbb. Good work!