Problem with Phpnuke 7.8 and character support

Nuke Cadet Joined: Sep 05, 2005 Posts: 2

I have a paid host and created database with cp1251 character set. Everything is ok, and you can write with cyrillic letters except in the forum. When I try to write I receive the following message

Could not insert new word matches

DEBUG MODE

SQL Error : 1267 Illegal mix of collations (latin1_bin,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation ' IN '

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 5, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('жаоаяяжа')

Line : 252
File : functions_search.php

I have trried so many things and nothing. Could you help me to solve the problem? Thanks in advanced.

Posted: Mon Sep 05, 2005 1:29 am

Open 7.8 DB with your phpmyadmin.
And find the two tables:

nuke_bbsearch_wordlist
nuke_bbsearch_wordmatch

Delete the above two tables and then run the following two DB tables (these are my own change and was tested).

** Comments: The reasons was "latin1 character code," which you are supposed to use "binary."

Code:

CREATE TABLE nuke_bbsearch_wordlist (
word_text varchar(50) binary NOT NULL default '',
word_id mediumint(8) unsigned NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (word_text),
KEY word_id (word_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbsearch_wordlist`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbsearch_wordmatch`
#

CREATE TABLE nuke_bbsearch_wordmatch (
post_id mediumint(8) unsigned NOT NULL default '0',
word_id mediumint(8) unsigned NOT NULL default '0',
title_match tinyint(1) NOT NULL default '0',
KEY word_id (word_id)
) TYPE=MyISAM;

Nuke Cadet Joined: Sep 05, 2005 Posts: 2

Sorry but it doesn't work, I'm trying to use phpnuke with character dabase cp1251
so this is the errors

Could not insert new word matches

DEBUG MODE

SQL Error : 1267 Illegal mix of collations (cp1251_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation ' IN '

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 4, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('ожаоаооа')

Line : 252
File : functions_search.php