3 replies to this topic

[Wingpilot66]

HELP!

Hello, I finally got my ECHO working again. the order is taken and is processed. I had to completely reinstall the ECHO system and setups. All is well with that now.
BUT..... now on the final order part after the card and order is confirmed I get the following error:

********************************

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'S PUBLISHING
ECHO Order Number &nbs' at line 1

UPDATE orders SET echo_result='

**********************************

ANY HELP is appreciated!


David W.

Edited by Wingpilot66, 30 August 2010, 13:12.

[web-project]

Quote

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'S PUBLISHING
ECHO Order Number &nbs' at line 1

could you publish the whole SQL query, please?

[Wingpilot66]

web-project, on 30 August 2010, 20:52, said:

could you publish the whole SQL query, please?

That's the problem. I don't know where it's coming from? I don't know the file that is generating this error.

I just know when it happens. It's just after the Credit Card is approved and it attempts to give the result and subtract stock levels.
So, I don't know if it is a echo result file or OS commerce result file??

Thanks for replying. Is there anything else that might help to figure this error out?


David

[Wingpilot66]

BUMP.. Any HELP out there?!?!?!?

Wingpilot66, on 31 August 2010, 13:32, said:

That's the problem. I don't know where it's coming from? I don't know the file that is generating this error.

I just know when it happens. It's just after the Credit Card is approved and it attempts to give the result and subtract stock levels.
So, I don't know if it is a echo result file or OS commerce result file??

Thanks for replying. Is there anything else that might help to figure this error out?


David