Forum

Pay Now leads to an Error

Hallo Support Team,

I got the pay now and add to cart button thanks to you running, but now if I click the pay now then I run into that 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 '' at line 3

I use SQL version 5.7 and so far everything was ok with it. I would be very happy if you help me to solve that issue - thanks you.

My Payment Plugin is TF PayPal and it is setup in options / payment plugin.

The Form by Plugin option is set to no as you mentioned at my other issue with the pay and add to cart button nor appearing.

Kind regards, Andi :)

Hello

Can you email me temporary Joomla administration credentials? I need to investigate the issue at site level.

When I click Buy button here: https://phpsocial-net.com/index.php/market/themes/darkly-theme

I am not getting error. It is redirecting to Paypal but it is not working.

Please test Paypal in sandbox mode.

First of all thank you. I did what you told me and at least I got so far that I could see the PayPal Login form in sandbox mode, but in sandbox mode I can not login with my default PayPal Login Data. Do I have to create a extra new account at paypal sadbox?

Yes, for testing PayPal, login details are different.

You have to create two test accounts in Paypal: One for the merchant that will be used for business email in the plugin. Second for the customer that will be used for payment on the frontend.

The keys will be different as well.

Check here: https://developer.paypal.com/developer/accounts

Of course I will give you admin access. I have enough trust in you and I'm really happy if you can fix the mistake I hope.

Sorry I sent you the wrong password. Here is the right one.

Ok in sandbox mode everything is working well now. So whats the next step now? Does that mean that the SQL error no longer exists or did you fix it with the TF Library update yesterday? Can I now switch to active mode and assume everything is working? I'm really scared of pissing off the first customers. In any case, I would like to thank you very much! Your support is really outstanding. Kind regards, Andy ;)

SQL error was may be due to some misconfiguration.

If it is working in sandbox mode, then it will work in live mode in same way. You can switch to active!

All the best for your shop :)

Sorry, but one last question remains. In demo mode, PayPal tells me that everything is ok and the payment was successful - when I go back to my homepage, to the product download area, I get the status "failed". Is it because I'm in sandbox mode or is there still an error in the purchasing process? Kind regards, Andy ;)

Status should be Paid.

In sandbox mode, there is some delay (about 5 to 15 minutes) in making payments and processing orders. After payment, immediate status should be Pending and then it should become Paid.

Please try again.

Ahhh ok thanks The topic can be closed now - I wish you a good time. Kind regards, Andy ;)