26 Jul
2005
26 Jul
'05
8:54 a.m.
Hello,
please use mailing list serusers(a)lists.iptel.org or serweb-users(a)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@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