close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Testing a payment but receiving this error upon return from Paypal

Thread began 4/13/2018 8:01 pm by graham | Last modified 4/13/2018 10:43 pm by Ray Borduin | 70 views | 5 replies |

graham

Testing a payment but receiving this error upon return from Paypal

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 '(@@FieldNameStrParam@@) values (@@ColumnTypeStrParam@@@@FieldValueStrParam@@@@Co' at line 1

Ray, I read on a related thread that it may be fixed with manual updates on the confirm.php and pp_confirm.php pages - I don't see any conflicts, any idea? I have attached ... I know you are probably getting ready for the weekend, but I thought I would fire them off anyway (weekends are my time to dabble :) )

UPDATE - must have messed up with the wizard settings, bindings are all off in store order and orderdetails to database. Manually amending them now, which values do I bind them to on confirm.php and pp_confirm.php? Thanks, Ray.

Sign in to reply to this post

Ray BorduinWebAssist

This happens when your database connection isn't working when you go through the wizard. Since it can't detect your database columns and types it puts in placeholders.

The best thing to do is to test you connection to make sure it works and run the wizard again.

If you have made changes to the pages you want to keep, then save them as a backup and just copy over the store cart summary and store cart details in database code chunks from the new pages after the wizard has run.

Sign in to reply to this post

graham

Thanks, Ray ... I will do it that way. Follow-up of sorts ... I am not subscribed to Paypal Pro, so I am not able to use the seamless option (?), which I would like ... you mentioned that you had configured Square to work - would it process onsite? Thanks

Sign in to reply to this post

Ray BorduinWebAssist

You can still use paypal express checkout, which is relatively seamless particularly if you use the lightbox method. I'm not sure what the square process would look like. I suppose that would depend on the type of square integration you have done. I'd look at their documentation to see examples of their various offerings.

Sign in to reply to this post

graham

I did like the Express look ... would I just remove the coding for the cc payment from my checkout.php page, leaving only the Paypal option?

Sign in to reply to this post

Ray BorduinWebAssist

I think the easiest option would be to re-run the wizard with express checkout only and let it create the necessary forms and pages.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...