Rafael R. GV a écrit :
[...]
2.- Change value FG_TABLE_NAME="call t1" for FG_TABLE_NAME="calls
t1" in following files:
A2Billing_UI/Public/call-log-customers.php
A2Billing_UI/Public/invoices.php
A2BCustomer_UI/balance.php
A2BCustomer_UI/invoices.php
You forgot:
A2Billing_UI/Public/aster
Rafael R. GV wrote:
PS: mysql-schema does not work properly in mysql 5.0.x because only one
timestamp with default now() in a table its allowed as you told me and
also I´ve found other issue related to auto_increment value:
ERROR 1064 (42000) at line 87: You have an error in your SQL syntax;
Thank you
this is what I made to solve it:
1.- create table 'calls' using: " starttime TIMESTAMP DEFAULT
now() NOT NULL, " (it can be "starttime TIMESTAMP DEFAULT
CURRENT_TIMESTAMP NOT NULL," too) :
CREATE TABLE calls (
id BIGINT NOT NULL AUTO_INCREMENT,
sessionid CHAR(40) NOT NULL,
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 DEFA
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:
mysql> CREATE TABLE calls (
-> id BIGINT NOT NULL AUTO_
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 'mya2bil
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