That's odd, the schema should allow the creditcard_number,
creditcard_expire, and rerun_date to be inserted as null values and
mysql puts in zeroes for you. Did you happen to use any particular
windows gui tool to import the default citrus database schema? It
looks like there may be some kind of bug that may not create the
proper schema, http://bugs.mysql.com/bug.php?id=36250
`creditcard_number` bigint(16) default NULL,
`creditcard_expire` smallint(4) unsigned zerofill default NULL,
`rerun_date` date default NULL,
Paul
On Tue, Apr 29, 2008 at 5:00 PM, Rich Cloutier <[EMAIL PROTECTED]> wrote:
> [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
>
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
-------------------------------------------------------------------------
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
