Query Failed

[cathobby]

I am trying to edit my items and everytime I hit the submit button I get a message:

QUERY FAILED

HELP!!!!
Is this a bug?

[Jamie]

Hi,

Is this on a particular table? You can get that message when editing Customer records, if you enter an email address that is already in the database. Also, if you happen to have 1 customer that has a blank email address, you cannot enter another one with a blank address.

If this is not the case, then put this line at the very bottom of the "squirrelcart/index.php" file, above the </body> tag:

<? print mysql_error(); ?>

This will output the actual error returned by MySQL. If you respond with that error, we can troubleshoot further.

Thanks,
Jamie

[cathobby]

This is happening when I try to edit products!
I added the line you asked me to in my squirrelcart/index.php file.
What do I do now? This is getting very annoying, I am trying to fix my products and this keeps happening.

How do I get it to "print" the errors?

[Jamie]

Hi Cathobby,

This is happening because you have "magic_quotes_gpc" set to "off" in your PHP settings. Please ask your web host to turn it on for you. If they refuse, we can modify the cart to work with it off, but it would be much easier to get it turned on.

The next version of the cart supports "magic_quotes_gpc" both "on" and "off".

Thanks,
Jamie

[cathobby]

Jamie,

I called my host and they turned ON the feature you mentioned.
I just tried to edit a product and I got a QUERY FAILED once again.
Please help!!!

[Jamie]

Hi,

I just tried to create a product with the name:

test'

and it let me. It seems OK now. They may have reset your server or something. Can you please try again?

Thanks,
Jamie