Hello everyone I have conceded to utilize stripe and find that it is great although I"m having a major problem trying to get it to work. I have the shopping cart done correctly, but following all the tutorials on the stripe checkout do not work. I keep getting the error - "syntax error or access violation: 1064 You have an error in your SQL syntax; … I can’t figure out the error.
I would greatly appreciate some help on this PLEASE - trying to get this project done with more e-commerce sites getting backed up. SOMEONE PLEASE HELP ME OUT - I have been dealing with this for five days and cant get it figured out. I have the screenshots below.
Hello,
Can you show us which is the tutorial you’re refering ?
yes sir gladly - and thankyou for the response - I have tried:
1-Stripe Checkout with Custom Products
2-Stripe Checkout with Custom Products - a different one - posted by Teodore directly.
3-Getting Started with Stripe Integration in Wappler
And many other tutorials thru the community and I am now quite envious of everyone that it succeeded for. I usually don’t have a problem, but this one is now beyond me. I got the the cart working, and then got an error with no response for id in session and conquered that one, but this error I cannot figure out as stated in the initial post above. Any help would be great!
Can you try changing this:
To this $_POST.lineItems.flatten('pid') ?
Remember being on “code view”
doing now
nope - now I get this: (it doesn’t recognize the id#)
But the header is 200 -good and preview and response both show the info correctly - id’s and all.
What about:
$_POST.lineItems.join(',', 'pid').split(',')
Same: Id is missing in session response.
Sorry
This has nothing to do with the 500 error you showed at first.
The 500 error was because your expression was calling a string “pid” and not a value from “pid” so that’s why the quotes.
The Id is missing in session response. is related to the stripe checkout, so I don’t know how can I help you, my friend as I never implemented it 
Check this:
Problems with stripe checkout
Id is missing in session response
Can you share your steps so others can see what is wrong with the stripe checkout?
The error changed after changing the flatten part in the query. I appreciate it though. I’ll try Teodore directly - hope he is available.
Exactly, they’re two diferents errors.
I’ll recommend you first using this community as the team are very busy fixing bugs and other stuffs.
And if someone can help you, it will also helps others as well.
Try to share everything you can on this community, I’m sure they’ll be glad to help you out the best they can 
1 Like
Thank you and my apologies for already doing so - as I said been dealing with this for 5 days and had another post previously done with no help. I intend on adding it to the post if and when i get it resolved for anyone elses problem with this as well.
1 Like
Are you following this tutorial: Stripe Checkout with Custom Products
And if yes, are you sure you strictly followed it as explained here:
Stripe checkout expects 4 values to be sent to it:
title(mandatory) - The name of the product
amount(mandatory) - The price of the product
currency(optional) - The currency. If not provided it defaults tousd
quantity(optional) - The quantity that should be added to the cart. If not provided, it defaults to1
in this part:
Also - have you enabled the Output for the set value Id step?
Yes sir I have - hate to say have done it 3 times. I will try once again this morning and let you know -sincerely appreciate the response.
There’s no need to redo everything from scratch, just check the things i mentioned 
Ok I just did it again and set it up exactly as you have (other than the true names of the fields in the database-but put the alias names in) and it still doesn’t work - still get an error.
So the error now is not the missing Id but an SQL error?
Can you disable the query step and the steps after it, and create a setvalue step that uses the $_POST.lineItems as a value, enable output for it then try to run the process again and see the output in the dev tools.
Yes correct as I posted earlier figured out the id session part and then got the SQL error - will disable rest like you want right now
