Hi <br>
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:<br>
<br>
<b>Database error:</b> 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<br>
<b>MySQL Error</b>: 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)<br>
<b>Database error:</b> 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<br>
<b>MySQL Error</b>: 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)<br>
<b>Database error:</b> Invalid SQL: SELECT count(*) FROM call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2005-11-12')<br>
<b>MySQL Error</b>: 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)<br>
<b>Database error:</b> next_record called with no query pending.<br>
<b>MySQL Error</b>: 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)<br>
<br>
some advice?<br>
<br>
rafael<br>
<br>
-- <br><br>rrgv