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:
mysql> CREATE TABLE calls (
-> id BIGINT NOT NULL AUTO_INCREMENT,
-> sessionid CHAR(40) NOT NULL,
-> uniqueid CHAR(30) NOT NULL,
-> username CHAR(40) NOT NULL,
-> nasipaddress CHAR(30),
-> starttime TIMESTAMP DEFAULT 'now()' NOT NULL,
-> stoptime TIMESTAMP,
-> sessiontime INT,
-> calledstation CHAR(30),
-> startdelay INT,
-> stopdelay INT,
-> terminatecause CHAR(20),
-> usertariff CHAR(20),
-> calledprovider CHAR(20),
-> calledcountry CHAR(30),
-> calledsub CHAR(20),
-> calledrate float,
-> sessionbill float,
-> destination CHAR(40),
-> id_tariffgroup INT,
-> id_tariffplan INT,
-> id_ratecard INT,
-> id_trunk INT,
-> sipiax INT DEFAULT '0',
-> src CHAR(40),
-> PRIMARY KEY (id)
-> );
ERROR 1067 (42000): Invalid default value for 'starttime'
I have to do some research in mysql 5 manual but I prefer to use PostgreSQL :-)
rafael
On 11/13/05, Vahan Yerkanian <[EMAIL PROTECTED]> wrote:
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
_______________________________________________
--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
--
rrgv
_______________________________________________ --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
