13 Jun
2006
13 Jun
'06
2:43 p.m.
Hi,
look at these config options (config_data_layer.php)
Karel
/**
* Needs to be set when you are useing MySQL >= 4.1
* see mysql manual for more info
*
* $config->data_sql->collation = "utf8_general_ci";
*/
$config->data_sql->collation = "";
/**
* Set to true when you are useing MySQL >= 4.1
* This option set mysql system variables character_set_client,
* character_set_connection, and character_set_results to charset
* used in serweb
*
* $config->data_sql->set_charset = true;
*/
$config->data_sql->set_charset = false;
Zenone napsal(a):
Hi,
I still have troubles with my serveb... (thanks karel for answering my
previous question) I saw the serweb log and it can be read :
"" 'Jun 13 10:13:52 serweb [error] file:
/usr/local/serweb-0.9.4/data_layer/method.get_aliases.php:27: DB Error:
unknown error - select username, domain from aliases where
lower(contact)=lower('sip:zenone@192.168.0.120') order by username
[nativecode=1267 ** Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='] ""
I followed karel advice of july 2005 and it doesn't work anyway.
I work on a fedora with ser 0.9.6 and serweb 0.9.4.
Thanks for your help!
Michel
________________________________________________
Message sent using UebiMiau 2.7.8
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers