asterisk2billing.org http://forum.asterisk2billing.org/ |
|
a2billing_batch_process.php bug http://forum.asterisk2billing.org/viewtopic.php?f=16&t=4611 |
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 http://www.phpbb.com/ |