I don't have an XP machine with AMP on it to try, but It's doing two
different things when you change a billing record. It's updating what
you changed on the record, and also updating the to_date according to
the billing type selected. You can watch it do queries by turning on
ADODB's debug feature. You'll need to add a line to the file
/modules/billing/edit.php:
$DB->debug = true;
right after line 104, "if ($save) {" and before the UPDATE query would
be a fine place for it
You'll also have to comment out line 134 that redirects back the the
billing index, so it stays on the update page and will show you the
output and any errors.
Paul
On Thu, Apr 10, 2008 at 2:04 PM, Daniel Diaz <[EMAIL PROTECTED]> wrote:
> I install Citrusdb on linux and run without problem.
> When I tried on Xp it gave me Query failed when change the billing
> type for a customer.
> If I go to the billing table through mysql and change the billing type
> of a customer, and then trying the Print New Invoices tool on citrusdb
> it gave me: history update failed.
>
> Any suggestion?
>
>
> OS : Widows XP Prof
> MySql: MySql5.0.51a-community
> Citrus Database Version: 1.2.2
> Citrus Software Version: 1.2.2
> Apache 2.2
> PHP Version 5.2.5
>
>
>
> Thanks,
> Daniel Díaz
>
> -------------------------------------------------------------------------
> 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
