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
begin:vcard
fn:Vahan Yerkanian
n:Yerkanian;Vahan
org:ARMINCO Global Telecommunications;Head, Research & Development dept.
adr:;;28, Isahakian ave., PO BOX 10;Yerevan;;375009;Armenia
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
url:http://www.arminco.com/
version:2.1
end:vcard

_______________________________________________
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to