[Citrusdb-users] Greetings

[Rich Cloutier]

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.

[Paul Yasi]

Can you show me the query it prints? Maybe with fake data if necessary.

Paul

Post by Rich Cloutier
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.
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
$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
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Paul Yasi]

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

Post by Rich Cloutier
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.
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
$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
https://lists.sourceforge.net/lists/listinfo/citrusdb-users