Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Wed Sep 18, 2019 9:48 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: a2billing_batch_process.php bug
PostPosted: Mon Dec 01, 2008 9:36 pm 
Offline

Joined: Wed Nov 05, 2008 8:26 pm
Posts: 13
Bug for postgres (and mysql???) being that firstusedate>0 compares time/date format value to integer and causes an error.

$sql = "SELECT id, credit, nbservice, $UNIX_TIMESTAMP lastuse), username, $UNIX_TIMESTAMP servicelastrun), email FROM cc_card WHERE firstusedate IS NOT NULL AND firstusedate>0 AND runservice=1 ORDER BY id ";

Suggest remove the "AND firstusedate>0" as the db column definition does not allow integer values (0 or -1 as often used in A2B to indicate non-use, irrelevant since db does not allow that as input).

a2b: branch/1.3 (1.3.4+)
db: postgres 8.3


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 01, 2008 10:06 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
Yes, MySQL has never been too fussy about data validation.
This change should be SQL server agnostic.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 01, 2008 10:12 pm 
Offline

Joined: Wed Nov 05, 2008 8:26 pm
Posts: 13
ok, got it :)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 
Voice Broadcast System


All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


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