when I try to send an email, I get the following error, and not found an SQL function as it should. any suggestions?
Code:
2012-12-27 21:14:38 COT ERROR: no existe la función if(boolean, numeric, numeric) en carácter 11
2012-12-27 21:14:38 COT HINT: Ninguna función coincide en el nombre y tipos de argumentos. Puede desear agregar conversión explícita de tipos.
2012-12-27 21:14:38 COT SENTENCIA: SELECT *, IF((typepaid=1) AND (creditlimit IS NOT NULL), credit + creditlimit, credit) AS real_credit FROM cc_card WHERE id = 14
this error occurs when you try to send an email
Operation System Version : Debian GNU/Linux 6.0.4 (squeeze)
Asterisk Version : 1.8
PHP Version : 5.3.3-7+squeeze14
A2B DataBase Version : 1.7.0
User Interface : A2Billing v2.0.1 is a voip billing software licensed under the AGPL 3.
Copyright (C) 2004-2012 Star2billing S.L.
http://www.star2billing.com/User Interface Path : /var/www/asterisk/a2billing/admin/Public/dashboard.php/
MYSQL : PostgreSQL 8.4.13 on i486
A2Billing v2.0.1