[Serusers] Re: [SERweb]DB Error: unknown error

[Karel Kozlik]

  Hello,
please use mailing list serusers at lists.iptel.org or serweb-users at lists.iptel.org for 
your further questions.

Yes I encountered this error. Try set these config variables in file 
config/config_data_layer.php:

/**
  *  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;

regards Karel


seehoe yee napsal(a):
> Good day Karel,
> 
> I'm a new SER user, I've successfully installed SERweb but after logging
> into SERweb I was displayed with 
>            DB Error: unknown error
> 
> on my_account.php and pages like accounting.php, phonebook.php
> 
> I've logged the error below is the log:
> 
> # -----
> Jul 27 03:25:09 serweb [debug] Html form was not assigned to APU
> apu_aliases3.  Useing default.
> Jul 27 03:25:09 serweb [debug] Html form was not assigned to APU
> apu_acl4.  Useing default.
> Jul 27 03:25:09 serweb [error] file:
> /var/www/html/serweb/application_layer/apu_aliases.php:112: DB Error:
> unknown error - select username, domain from aliases where
> lower(contact)=lower('sip:77771111 at 192.168.0.106') order by username
> [nativecode=1267 ** Illegal mix of collations
> (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
> operation '=']
> # -----
> 
> I've google through thought it was MySQL problem as I searched "Illegal
> mix of collations". Therefore, I upgrade from 4.1.12 -> 4.1.13 but still
> no go. The same error message I get.
> 
> Just wondering if you have encountered this issue before?
> 
> Regards,
> See Hoe
>