Stripe checkout not working

[jpena]

For your info - putting everything back per instructions and our posts here - this is complete response:

{
“code”: “42000”,
“file”: “/home2/estatej/public_html/dmxConnectLib/lib/db/Connection.php”,
“line”: 112,
“message”: “SQLSTATE[42000]: Syntax error or access violation: 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 ‘))’ at line 1”,
“trace”: “#0 /home2/estatej/public_html/dmxConnectLib/lib/db/Connection.php(112): PDO->prepare(‘SELECT PID, ...')\n#1 \/home2\/estatej\/public_html\/dmxConnectLib\/modules\/dbconnector.php(96): lib\\db\\Connection->execute('SELECT PID, …’, Array, true, ‘’, Array)\n#2 /home2/estatej/public_html/dmxConnectLib/lib/App.php(206): modules\dbconnector->select(Object(stdClass), ‘query’, Array)\n#3 /home2/estatej/public_html/dmxConnectLib/lib/App.php(178): lib\App->execSteps(Object(stdClass))\n#4 /home2/estatej/public_html/dmxConnectLib/lib/App.php(146): lib\App->execSteps(Array)\n#5 /home2/estatej/public_html/dmxConnectLib/lib/App.php(135): lib\App->exec(Object(stdClass), false)\n#6 /home2/estatej/public_html/dmxConnectLib/lib/App.php(113): lib\App->exec(Object(stdClass))\n#7 /home2/estatej/public_html/dmxConnect/api/cart_checkout.php(7): lib\App->define(Object(stdClass))\n#8 {main}”
}

[Teodor]

How did it become from this:

@jpena

to this:

@jpena

putting everything back per instructions and our posts here - this is complete response:

{
“code”: “42000”,
“file”: “/home2/estatej/public_html/dmxConnectLib/lib/db/Connection.php”,
“line”: 112,
“message”: “SQLSTATE[42000]: Syntax error or access violation: 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 ‘))’ at line 1”,
“trace”: “#0 /home2/estatej/public_html/dmxConnectLib/lib/db/Connection.php(112): PDO->prepare(‘SELECT PID , ...')\n#1 \/home2\/estatej\/public_html\/dmxConnectLib\/modules\/dbconnector.php(96): lib\\db\\Connection->execute('SELECT PID , …’, Array, true, ‘’, Array)\n#2 /home2/estatej/public_html/dmxConnectLib/lib/App.php(206): modules\dbconnector->select(Object(stdClass), ‘query’, Array)\n#3 /home2/estatej/public_html/dmxConnectLib/lib/App.php(178): lib\App->execSteps(Object(stdClass))\n#4 /home2/estatej/public_html/dmxConnectLib/lib/App.php(146): lib\App->execSteps(Array)\n#5 /home2/estatej/public_html/dmxConnectLib/lib/App.php(135): lib\App->exec(Object(stdClass), false)\n#6 /home2/estatej/public_html/dmxConnectLib/lib/App.php(113): lib\App->exec(Object(stdClass))\n#7 /home2/estatej/public_html/dmxConnect/api/cart_checkout.php(7): lib\App->define(Object(stdClass))\n#8 {main}”
}

i am not sure i am following.
What did you change now that now you get a different error? What have you been doing until now and what is different between your last post and the one before the last post?

[jpena]

Sorry went back to look at it again and double checked and saw that this was set correctly as it is now and got that error. This is the same error as I had always been getting as I originally posted. I’ve literally only changed the following from your instructions this morning since this began.

$_POST.lineItems.flatten.flatten(‘pid’)

[Teodor]

@jpena

$_POST.lineItems.flatten.flatten(‘pid’)

That looks like a totally wrong expression…please double and triple check my previous replies.

@Teodor

No it’s wrong, it should be:

$_POST.lineItems.flatten('pid')

I really think you have some very fundamental syntax issue in your query step.

[jpena]

No you are correct - I went back to look and this is what it read under flatten:
$_POST.lineItems.flatten.flatten(‘pid’)

But fixed it to
$_POST.lineItems.flatten(‘pid’)
and tried again and now get this error back again (so it remains):

[jpena]

Thanks again for the help @Teodor - I await you or @Patrick’s reponse!

[Teodor]

@Teodor

Are you sure you’ve properly entered your stripe api key and secret in the server connect settings? Please double check these and enter them again if needed.

@jpena

Yes I am and just did so again - I have the Stripe account under test mode and using the test keys it provides. Still get this:

I am pretty sure you didn’t add your stripe secret key in Server Connect settings:

I just built a page and a server action following the tutorial you are also following and the only way to recreate your error is to leave the secret key in Server Connect settings empty. So please make sure to add it there.

[jpena]

No sir I assure you I have done so:

[jpena]

I would be more than happy to allow you access to my computer to see everything if you would like. I can message you over the online program to do so if you would like?

[Teodor]

In the Server Connect settings you need to put your private key and in App Connect Stripe component your publishable key.

[jpena]

That is what I have. In Stripe the private key is referred to as Secret Key, but yes that is what I have. As I just showed you.

[Teodor]

But check if the App Connect Stripe component you added the publishable key from stripe. On your screenshots i see the same key on both places.

[jpena]

No its correct - as the keys start off with a pk_test for publishable key and sk_test for secret key

[Teodor]

Right click in the file panel in Wappler, enable hidden. Open the .wappler folder and browse to this file:

Open it and see if the stripe key is there. There should be an entry $CONFIG_STRIPE_SECRET_KEY

[jpena]

It is - although my directory listing on the right doesn’t look exactly like yours:

[jpena]

I meant on the left (directory listing)

[Teodor]

Please zip and send me your cart_checkout.php server action in a personal message, so i can check it.

[jpena]

I will post all answers and help that Teodor helped me with on solving the cart and stripe problem I went thru for anyone’s help. BUT right now I have a question as why in the new 6.0.5 version does the cart data information not appear in the app connect but it does in 5.8.2?

6.0.5-Not appearing

5.8.2 - Correct

[Cheese]

@jpena

I have a question as why in the new 6.0.5 version does the cart data information not appear in the app connect but it does in 5.8.2?

See this Bug Report @jpena

Data Store properties panel is empty again

Wappler Version : 6.0.4 Operating System : Windows 11 Server Model: NodeJS Expected behavior You should be able to edit properties in the data store Actual behavior It is blank [image] Same issue that was fixed here Can confirm it was working after 6.0.2 and I’m not 100% sure but I think it worked fine in 6.0.3 but now in 6.0.4 it is not working.