[Serusers] DB Unknown error

[Karel Kozlik]

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