[Serusers] DB Unknown error

[Zenone]

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

________________________________________________
Message sent using UebiMiau 2.7.8