Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Jul 23, 2019 10:11 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Creation date not working in a2billing.
PostPosted: Fri Feb 16, 2007 8:42 am 
Offline

Joined: Fri Dec 22, 2006 2:43 pm
Posts: 76
Location: London, UK
Hello guys,

Its me again with my lots of questions.

I will start helping others out when i am confident in my knowledge of the product.

My problem this time is with the creation date.

I am trying to list all users created within the last week but nothing is coming up when i am confident users were created. I checked the database and realize that all the creation date for all the users are set to '0000-00-00 00:00:00'.

Can someone help me in sorting this bug out it is important that we know when an account was created.

Any help will be greatly appreciated.


Top
 Profile  
 
 Post subject: Re: Creation date not working in a2billing.
PostPosted: Fri Feb 16, 2007 9:03 am 
Offline

Joined: Thu Oct 19, 2006 9:56 am
Posts: 300
Location: Athens, Greece
karie_ng wrote:
Hello guys,

My problem this time is with the creation date.

Any help will be greatly appreciated.


Most important hint: which db are you using? Implementations for time on Postgres/Mysql are really different.


Top
 Profile  
 
 Post subject: Creation date not working in a2billing.
PostPosted: Fri Feb 16, 2007 9:42 am 
Offline

Joined: Fri Dec 22, 2006 2:43 pm
Posts: 76
Location: London, UK
XRG,

Thanks for replying.

I am using:

mysql server version: 4.1.20


Top
 Profile  
 
 Post subject: Creation date not working in a2billing.
PostPosted: Sat Feb 17, 2007 7:06 pm 
Offline

Joined: Fri Dec 22, 2006 2:43 pm
Posts: 76
Location: London, UK
Hey Guys,

I have resolved this issue.

Incase anyone is having the same problem here is what i did.

Change the default data type of creationdate from TIMESTAMP to CURRENT_TIMESTAMP.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Feb 17, 2007 8:15 pm 
Offline

Joined: Fri Apr 28, 2006 5:11 am
Posts: 426
which file?


Top
 Profile  
 
 Post subject: Creation date not working in a2billing.
PostPosted: Sat Feb 17, 2007 11:51 pm 
Offline

Joined: Fri Dec 22, 2006 2:43 pm
Posts: 76
Location: London, UK
Anest,

Sorry i wasn't clear.

I change the default data type of the creationdate from TIMESTAMP to CURRENT_TIMESTAMP on the cc_card table.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Feb 18, 2007 7:53 am 
Offline

Joined: Fri Apr 28, 2006 5:11 am
Posts: 426
can you make .sql file for patch?


Top
 Profile  
 
 Post subject: Creation date not working in a2billing.
PostPosted: Sun Feb 18, 2007 4:26 pm 
Offline

Joined: Fri Dec 22, 2006 2:43 pm
Posts: 76
Location: London, UK
Here goes;

Log into mya2billing database and issue the following commands:

ALTER TABLE `cc_card` CHANGE `creationdate` `creationdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Or you may acchieve the same result by:

Going to your phpMyAdmin interface and click on table cc_card then click on structure and edit column creationdate and click on the check box for CURRENT_TIMESTAMP which is just below default2

Hope this helps.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Feb 18, 2007 5:45 pm 
Offline

Joined: Thu Oct 19, 2006 9:56 am
Posts: 300
Location: Athens, Greece
Your solution sounds most appropriate. Will work.
( I personally use Postgres, so it doesn't affect me )

However, it bothers me why the current implementation (in a2b v. 1.2.3) doesn't work. See:
A2B_entity_card_multi.php:86
and FG_var_card.inc:582

Hint: try increasing the verbosity with FG_DEBUG and look at the query string.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Feb 18, 2007 8:50 pm 
Offline

Joined: Fri Apr 28, 2006 5:11 am
Posts: 426
thank you karie_ng! good job!! :)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 
Auto Dialer Software


All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group