gbadev.org forum archive

This is a read-only mirror of the content originally found on forum.gbadev.org (now offline), salvaged from Wayback machine copies. A new forum can be found here.

OffTopic > Can't create thread in DS homebrew announcements

#176946 - fincs - Wed Nov 02, 2011 11:00 pm

Hello,

I've attempted to create a new thread in the "DS homebrew announcements" section but it does not let me, failing with a SQL error:

Code:
Could not insert new word matches

DEBUG MODE

SQL Error : 1271 Illegal mix of collations for operation ' IN '

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 176945, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN (list of words separated by ' follow...)

Line : 252
File : functions_search.php


Does anybody know what's happening?

EDIT: apparently it was erroring out because I had used the U+2019 (apostrophe) character (not to be confused with ') in my post text, and for some reason it makes phpBB misbehave. Weird.
A mod can delete or lock this thread now.