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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers