Do any of your field values have a backslash \ in them?  there may
some issue with magic_quotes that I ran into once.  I'm trying to
figure out the best way around it, since PHP6 won't have magic_quotes,
but 4 and 5 do by default.

Paul

On Mon, Apr 28, 2008 at 9:49 PM, Rich Cloutier <[EMAIL PROTECTED]> wrote:
> Hi all,
>
>  I'm new to this list, and I apologize, but for the life of me I could
>  not find out how to get a digest over a longer term or search the
>  archives. Any enlightenment on that subject would be appreciated.
>
>  But I will post about my issue anyway:
>
>  Windows 2003 server Standard Edition
>  MySQL Essentials 5.0.45
>  PHP 5.2.4
>
>  Latest version of Citrus DB (1.2.2.1)
>
>  register_globals is off
>  mysql.trace_mode is on
>
>  Virgin install of citrus DB. (I did this when I encountered the problem,
>  just to be sure it wasn't my modifications or my data.)
>
>  In the billing module, I can't edit the default billing information. I
>  can update the Billing address to match the customer address if I change
>  it, but when I try to edit the billing info and click save changes, i
>  get "Query Failed."
>
>  Now here's where it gets strange. I modified the code to display the
>  MySQL error as follows:
>
>  Edited /modules/billing/edit.php Line 128:
>    $result = $DB->Execute($query) or die ("Query failed: " .
>  mysql_error() . " Actual query: " . $query);
>
>  The query is displayed, but NO MySQL ERROR! I'm not a PHP or MySQL guru
>  by any means, so I don't understand how the function can die with no
>  error. So I'm kind of at a roadblock. Other parts of the program operate
>  fine (customers and support) so I doubt there is anything fundamentally
>  wrong with my install of either MySQL or PHP.
>
>  Thank you in advance for any assistance anyone can offer.
>
>  --
>  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

Reply via email to