[Asterisk-Users] A2billing with Mysql-5.0.15

[Rafael R. GV]

Hi
I was using a2billing with mysql-4.1.12 and php-5.0.4 very successfully
(thanks to areski for this great project and its invaluable assistance to
solve some issues in my last installation...) now I´ve upgraded mysql to
last release 5.0.15 and, without changes in 'mya2billing' database I am able
to make calls, create and see created cards, etc, but I get this errors when
invoke CDR´s in both admin or user interfase:

*Database error:* Invalid SQL: SELECT t1.starttime, t1.src, t1.calledstation,
t1.destination, t1.sessiontime, t1.username, t1.terminatecause, t1.sipiax,
t1.calledrate, t1.sessionbill FROM call t1 WHERE UNIX_TIMESTAMP(t1.starttime)
>= UNIX_TIMESTAMP('2005-11-12') ORDER BY t1.starttime DESC LIMIT 0,25
*MySQL Error*: 1064 (You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >=
UNIX_TIMESTAMP('2005-11-12') ORDE' at line 1)
*Database error:* Invalid SQL: SELECT substring(t1.starttime,1,10) AS day,
sum(t1.sessiontime) AS calltime, sum(t1.sessionbill) AS cost, count(*) as
nbcall FROM call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >=
UNIX_TIMESTAMP('2005-11-12') GROUP BY substring(t1.starttime,1,10) ORDER BY
day
*MySQL Error*: 1064 (You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >=
UNIX_TIMESTAMP('2005-11-12') GROU' at line 1)
*Database error:* Invalid SQL: SELECT count(*) FROM call t1 WHERE
UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2005-11-12')
*MySQL Error*: 1064 (You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >=
UNIX_TIMESTAMP('2005-11-12')' at line 1)
*Database error:* next_record called with no query pending.
*MySQL Error*: 1064 (You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >=
UNIX_TIMESTAMP('2005-11-12')' at line 1)

some advice?

rafael

--

rrgv
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051112/554266c5/attachment.htm