Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP! - Error 1064


Wingpilot66

Recommended Posts

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
Link to comment
Share on other sites

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?

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

 

 

 

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...