Thank you Karel, now it works! But after subscribing i don't receive any mail to confirm my registration. I saw apache logs and serweb logs, and they are normal...no error. Thank you for your help! Michel --------- Message d'origine -------- De: Karel Kozlik karel@iptel.org A: Zenone zenone@telip.com Copies: serusers@lists.iptel.org Objet: Re: [Serusers] DB Unknown error Date: 13/06/06 11:43
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
________________________________________________ Message sent using UebiMiau 2.7.8