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