Support

Home Forums Event Espresso Premium database error at checkout payment

database error at checkout payment

Posted: June 11, 2019 at 1:53 pm


Jeffrey

June 11, 2019 at 1:53 pm

Our customers are getting this error after they choose the payment option and then proceed to the actualy payment.

https://monosnap.com/file/6ZmFoiN6fuRLGQFqoFA43iNALJMwEb

Can you help?


Josh

  • Support Staff

June 11, 2019 at 2:41 pm

Can you activate WP_DEBUG to log the error? There’s information for exactly how to do that in the troubleshooting documentation:

https://eventespresso.com/wiki/troubleshooting-checklist/#wpdebug


Jeffrey

June 12, 2019 at 12:42 pm

Ok, i’ve now done that.

What’s the next step?

Thanks,
MD


Josh

  • Support Staff

June 12, 2019 at 1:36 pm

You try/test a registration and if you get the same error, then check the log. Or wait for another registration, then check the log. The log file is located in your wp-content folder, its name is debug.log.


Jeffrey

June 13, 2019 at 9:00 am

This reply has been marked as private.


Jeffrey

June 13, 2019 at 9:03 am

Also, let me add that users are not able to make purchases at all with these errors. They are able to register for the class though.


Josh

  • Support Staff

June 13, 2019 at 9:35 am

Hi,

It’s not clear from the screenshot, may I ask which payment method is active on that site. Is it PayPal Standard, PayPal Express, or PayPal Express with Smart buttons?


Jeffrey

June 13, 2019 at 10:05 am

We’re using Paypal Standard.

Thanks,
MD


Josh

  • Support Staff

June 13, 2019 at 10:27 am

What you’ll need to do is switch to either PayPal Express or PayPal Express Checkout with Smart Buttons. The forum is included in the core EE4 plugin, and the latter is available to download as an add-on from your account page.

You can use your same PayPal account that you’re using now with the newer Express options, and here are links to their set up guides:
https://eventespresso.com/wiki/paypal-express-payment-gateway/
https://eventespresso.com/wiki/paypal-express-checkout-smart-payment-buttons-payment-gateway/

The PayPal Standard gateway was deprecated some time ago (you probably didn’t see the email?) and should be avoided.


Jeffrey

June 14, 2019 at 11:20 am

Thank you for the information.

So we’re going to switch to Paypal express.

What is the advantage of PPE with smart payment buttons?

Thanks,
MD


Josh

  • Support Staff

June 14, 2019 at 11:26 am

One advantage of smart buttons is the user doesn’t totally leave your site, and they’re presented with options to pay with credit card, pay with PayPal, and (if available) pay with PayPal credit or Venmo.


Jeffrey

June 14, 2019 at 11:51 am

They’ll be able to go through the full paypal payment without ever leaving the site? Is that different than the built in PPE?

Thanks,
MD


Josh

  • Support Staff

June 14, 2019 at 12:14 pm

They’ll be able to go through the full paypal payment without ever leaving the site?

Yes. What it does is it loads up the payment user interface from PayPal.com through an iframe that’s displayed in front of your site’s checkout page. So they never leave your site.

Is that different than the built in PPE?

Yes. The built in PayPal Express has a flow more like a traditional PayPal payment where the user is taken to PayPal.com, then pay, then after payment they’re redirected back to your site’s Thank You page.


Jeffrey

June 16, 2019 at 4:36 pm

When our users choose the Send me an Invoice option they’re not receiving the confirmationa and invoice. What could be wrong?

Thanks,
MD


Tony

  • Support Staff

June 17, 2019 at 7:01 am

Hi there,

When you look in Event Espresso -> Registration and find a registration that has selected Invoice, does it show as having ‘Incomplete’ or ‘Abandoned’ under their Txn Date?

Heres a screenshot showing the different – https://monosnap.com/file/mniqSLngPU5JJwBeOKhmSSH1SgIvMz

So do they show up like the top or bottom registration in that list?


Jeffrey

June 28, 2019 at 11:43 am

[Sorry for the delay]

It says Incomplete. See here – https://monosnap.com/file/UmZJNJsFzuyvmd03bMiUlePVrVwwVl


Tony

  • Support Staff

June 28, 2019 at 11:52 am

On that registration, click on the icon.

Does it show the Pending Payment message sent there?


Jeffrey

June 28, 2019 at 12:15 pm

Yes, it says it on the page linked to from the icon – https://monosnap.com/file/Cqb6nRzqCGFKxZGEgEyaWnBNCMFsWQ

It also said Pending Payment in the Name column in the last screenshot.

Just to clarify: We are receiving the confirmation and invoice, but it doesn’t include the link to pay.

Thanks,
MD


Tony

  • Support Staff

June 28, 2019 at 12:27 pm

That screenshot isn’t from clicking the icon I mentioned above. That’s from viewing the registration itself.

Clicking the icon would show the message sent by EE for that specific registration, like this – https://monosnap.com/file/BP6l0b8s8mAKPAdvSOolWeAu4tIX86

It also said Pending Payment in the Name column in the last screenshot.

Yeah, I can see its Pending Payment, but with the above, I’m confirming the Pending Payment emails for that registration were actually triggered/sent without error.

Just to clarify: We are receiving the confirmation and invoice, but it doesn’t include the link to pay.

Ok so the email is actually sent, but you want a link to pay within that?

Which email is it? What’s the ‘subject’ of the email?

I’m assuming the ‘Registration Pending Payment’ email sent to the user with that same subject.


Jeffrey

June 30, 2019 at 11:50 am

See here – https://monosnap.com/file/OsaAMAHRfxVv4jfMWgV2zyo7iKWRCd
There is a payment link in the email, but there’s no payment link in the invoice that that email links to. How do we get a link in that linked online invoice?

Thanks,
MD


Tony

  • Support Staff

July 1, 2019 at 4:28 am

Ah ok, I see.

The payment link text is from the Invoice payment method ‘Instructions’ section (Event Espresso -> Payment methods -> Invoice -> Instructions).

There’s no payment link on the invoice by default, but you can add one.

Go to Event Espresso -> Messages -> Default message settings -> Invoice.

In the main content section, you can add the [PAYMENT_LINK_IF_NEEDED_*] shortcode, which shows “You can make a payment here ».” by default if there are monies owing and nothing otherwise.

Personally, I’d add that to the payment table, like so – https://monosnap.com/file/LZr1C86i7Nc7kb4UWolfsX6Wx4ljbv

Which would then look like this – https://monosnap.com/file/kE2TfvAagMkosZeiTH6quGt3RFG0YL

Is that what you are looking for?

The support post ‘database error at checkout payment’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso