1 Topic by ayume

  • ayume
  • Junior Member
  • Offline
  • Registered: 2006-01-21
  • Posts: 2

Topic: insert search index words

http://img293.imageshack.us/img293/767/error4ri.png
My forum keeps getting this error whenever we post. I've searched. But I don't understand any of these complicated stuff. Help please?

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

Re: insert search index words

Simplest explanation from what I've heard: the "word" column doesn't have the binary attribute set

3 Reply by ayume

  • ayume
  • Junior Member
  • Offline
  • Registered: 2006-01-21
  • Posts: 2

Re: insert search index words

Smartys wrote:

Simplest explanation from what I've heard: the "word" column doesn't have the binary attribute set

Say what?

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

Re: insert search index words

alter table prefixsearch_words change word word varchar(20) binary not null default ''

Replace prefix with the db_prefix for your PunBB board, run that SQL query