[Asterisk-Users] A2billing with Mysql-5.0.15

[Vahan Yerkanian]

Rafael R. GV wrote:
> thanks Vahan
> you are right, I have changed 'call t1' for 'calls t1' in balance.php 
> and invoices.php files and then tried to create a new table named 
> 'calls' but mysql 5 has changed syntax for 'TIMESTAMP DEFAULT' and this 
> is the error:

>     ->     starttime  TIMESTAMP DEFAULT 'now()' NOT NULL,

this should read

starttime TIMESTAMP DEFAULT now() NOT NULL

now() is a builtin MySQL function and doesn't need to be enclosed in 's.
Also, you can have only one timestamp with default now() in a table...


HTH,
Vahan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: vahan.vcf
Type: text/x-vcard
Size: 287 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20051113/a59294aa/vahan.vcf