a2billing_batch_process.php bug
Page 1 of 1

Author:  infiniti_guy [ Mon Dec 01, 2008 9:36 pm ]
Post subject:  a2billing_batch_process.php bug

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

Author:  stavros [ Mon Dec 01, 2008 10:06 pm ]
Post subject: 

Yes, MySQL has never been too fussy about data validation.
This change should be SQL server agnostic.

Author:  infiniti_guy [ Mon Dec 01, 2008 10:12 pm ]
Post subject: 

ok, got it :)

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group