[EMAIL PROTECTED] wrote:
> Can you show me the query it prints? Maybe with fake data if necessary.
>
> Paul
No, because I fixed it. It was definitely data-related. We are still
fleshing out our data and many fields are blank still.
The initialization of many empty numeric and date fields to "" is what
caused the failure. I saw that in the CVS version you had error
reporting turned on, but for the release 1.2.2.1 version, all the
database errors are masked. Perhaps a field in config to set the debug
level would be nice in future versions. :)
Anyway, I added code in the billing module as follows, starting at line
92 of /modules/billing/edit.php:
$creditcard_number = $base->input['creditcard_number'];
if ($creditcard_number==""){$creditcard_number = 0;} // Initialization
of empty values to proper data type
$creditcard_expire = $base->input['creditcard_expire'];
if ($creditcard_expire==""){$creditcard_expire = 0;} // Initialization
of empty values to proper data type
$billing_status = $base->input['billing_status'];
$next_billing_date = $base->input['next_billing_date'];
$from_date = $base->input['from_date'];
$payment_due_date = $base->input['payment_due_date'];
$rerun_date = $base->input['rerun_date'];
if ($rerun_date==""){$rerun_date = "0000-00-00"; // Initialization of
empty values to proper data type
It may not be the most elegant way to fix this, but I'm still learning
my way around citrusdb. :)
Rich C.
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
