asterisk users - Nov 2005 - A2billing with Mysql-5.0.15

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

Rafael R. GV wrote:
> 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 5.0.15 introduces stored functions and procedures that are invoked 
by 'call()'. A2Billing uses 'call' for the name of the cdr
table. Find
all occurencies of 'call t1' or ' call ' in A2Billing's sql
queries and
replace them to 'calls t1' and ' calls '. Don't forget to
rename 'call'
table to 'calls'. In short, latest A2Billing doesn't work on mysql 
5.0.15 / PHP5 out of box.

On the side note, MySQL doesn't support more than 1 entry with default 
value of "DEFAULT now() NOT NULL" in one table.

regards,
Vahan