|
Drew Hume
|
December 20, 2024 at 7:27 pm
Hi there, I just updated and everything has gone wrong.
Went through the steps to change to paypal commerce as instructed and now the following things are happening:
– Can’t charge the Order. The Order ID is missing. (found that this means something goes wrong with the request to paypal? But have no idea how to fix)
– ticket selector doesn’t exist so i can’t sent tickets for events
– date selector also gone so can’t sent date for events (found that these two might be related to WP date and time settings, only i tried that and it didn’t work).
I have a multistie, but I’m no programmer. Please help, because right now no one can register for anything.
Thanks,
Drew.
|
|
Tony
|
December 24, 2024 at 3:15 am
Hi Drew,
Sorry for the delay, holiday season so replies are a little slower currently.
Can’t charge the Order. The Order ID is missing. (found that this means something goes wrong with the request to paypal? But have no idea how to fix)
Take a look in Event Espresso -> Payment methods -> Logs.
You’ll find log entries for each transaction there… click on the ID number to the left to open the log.
Do you see any errors there?
I’m guessing your getting ‘invalid_string_length’ somewhere in those?
– ticket selector doesn’t exist so i can’t sent tickets for events
– date selector also gone so can’t sent date for events (found that these two might be related to WP date and time settings, only i tried that and it didn’t work).
Both of those sound like the EE event content isn’t being injected into the_content (so all you get is the description), which happens when themes (or possibly other plugins) are doing something odd.
Do you know which version number you updated from?
Can you link me to an event I can view this on?
|
|
Drew Hume
|
December 27, 2024 at 10:52 am
Hey Tony,
Thanks for getting back to me.
From the log, I get this note: “Can’t charge the Order. The Order ID is missing.”
Unfortunately I don’t remember the previous version number. An event test is here: https://navina.ca/blog/events/test/
The only reason the prices appear is because I have “display ticket selector” – if I untick that, all prices on the event disappear. But even still, I have no price options in the creation of the event – I can’t set event prices there like I could previously.
|
|
Tony
|
December 28, 2024 at 8:39 am
From the log, I get this note: “Can’t charge the Order. The Order ID is missing.”
There will usually be another log entry before that one to try and create the order, the response saved on that log entry will usually help identify why it can’t create the order.
The only reason the prices appear is because I have “display ticket selector” – if I untick that, all prices on the event disappear.
I guess I’m misunderstanding this as that’s exactly what that option should do.
The ‘Display ticket selector’ option tells Event Espresso wether or not this section:
https://monosnap.com/file/2esoCiNvoo5HipPUvXH7QrV04ZoY1p
Should display for your event.
Disabling it will prevent registrations on that event as the ticket selector is where all registrations for each event ‘starts’.
But even still, I have no price options in the creation of the event – I can’t set event prices there like I could previously.
Oh, hang on then!
So it’s the event editor that’s not showing your datetime/ticket editor?
If that’s the case, may I ask what your Date/Time formats are set to in Dashboard -> Settings -> General.
To get you up and running quickly, you can switch to the ‘legecy editor’ in Event Espresso -> Events -> Default Settings (tabs across the top).
Set ‘Activate Advanced Editor?’ to ‘Legacy Editor’ and that should load the ‘old’ event editor and allow you to edit your events.
That’s not a permanent solution as eventually that editor will be removed from EE, but if you need to edit an event right now during the holidays (support is a little slower currently due to it being Christmas) that will get you through and we can figure out whats going on from there.
|
|
Drew Hume
|
December 28, 2024 at 6:25 pm
There’s no other information I can see on the log for the attempted transaction. It just has that text, and nothing else. screenshot here (of the first attempt, but all the attempts gave the same log):
https://d1s2euflwquqkj.cloudfront.net/wp-content/uploads/2024/12/Screenshot-2024-12-28-at-7.12.02 PM.png
Date time settings are: F j, Y and time is g:i a
I changed them to something else to test that out, as I found another forum post mentioning this, but it didn’t help me unfortunately.
Okay, I’ve gone and activated the legacy editor and it looks like I can now see the event date selector and the ticket creator in the event, so that bit seems to be fixed, at least for now. Thank you.
The payment issue still persists though I’m afraid.
|
|
Tony
|
December 30, 2024 at 7:53 am
Can I take a look at this in the admin?
If so send temp login details over using this form:
https://eventespresso.com/send-login-details/
I’ll enable the advance editor and see if I can see why that’s not loading and also take a look at PayPal Commerce to see what is happening.
If not, can you link me to the event so I can test a registration?
|
|
Drew Hume
|
January 9, 2025 at 5:37 pm
Heya – just checking to see if you’ve been able to have a look? I sent the login details the other week.
thank you.
|
|
Tony
|
January 10, 2025 at 4:38 pm
Hi Drew,
My apologies for the delayed reply!
Are you still running into the Payment issue with PayPal Commerce?
I can’t see any payment log entries for PayPal Commerce and the above error would normally be saved with those.
So may I ask how you’re testing this?
|
|
Drew Hume
|
January 10, 2025 at 7:01 pm
Hey Tony,
Yes, still running into issues.
I’m testing it with clients trying to register – I have a couple of events that have always been live and registration is not working with them. I’m having to wait until people email me saying “I’m trying to register but it doesn’t work” and then I just send them a paypal invoice outside of the EE system entirely.
That log, by the way – is from the costarica.navina.ca subdomain of my site. In case you want to use that subdomain to test/see what’s up.
|
|
Drew Hume
|
January 16, 2025 at 7:02 pm
Hey there,
Just looping back again. Still not working.
Any help would be appreciated. I might have to change plugins soon if we can’t resolve this. It’s been almost a month without being able to take reservations. Thanks.
|
|
Tony
|
January 16, 2025 at 7:18 pm
Hi Drew,
Apologies for the delay, I haven’t been ignoring you but I should have kept you in the loop better here.
I spent some time digging into this with one of our developers and this issue is really strange because when you click on the PayPal button here:
https://monosnap.com/file/cjWsXGO1CClPAxNn4Fva0BWLg8SYMq
PayPal generates the order ID and then uses it to display the next step here:
https://monosnap.com/file/bTIoqd1UeN5e8nbedzjKlvdpZ8mm5d
You cannot get to that step within PayPal (that popup is from PayPal servers, without an Order ID) but every time I test this on your site it works as expected.
We’ve just pushed an update to Event Espresso live now and that version adds some additional error checking within PayPal Commerce to try and narrow this down a little. Can you please update to version 5.0.32.p so we can see if any more details show in the logs?
(If the update doesn’t show on the site go to Event Espresso -> General Settings and just hit save to force an update check)
|
|
Tony
|
January 16, 2025 at 7:46 pm
Can you check the error logs to see if there are any errors from EE?
I’m getting fatal errors thrown when editing the cart and the ajax request to progress from the attendee information to payment options is now inconsistent. Sometimes, it works and then others, it sits spinning (which means EE couldn’t process the request; either it didn’t receive one or it had unexpected data within it).
|
|
Drew Hume
|
January 16, 2025 at 8:01 pm
Hey Tony,
Thanks for jumping on this – I’ll update right now and report back.
|
|
Drew Hume
|
January 16, 2025 at 8:30 pm
okay, updated –
I tried to paste the error log here but it seems to make this response not post… so just sending a note to say updated.
|
|
Tony
|
January 17, 2025 at 5:21 am
Yeah, they flag up as suspect; I can view them.
However those are payment logs, I’m after your server error logs now as the fatal will be stored in those.
Do you have file access to the server? If so are you comfortable sending that over so I can take a deeper look?
Side note – do you know the specific point at which people get to before it stops working?
|
|
Drew Hume
|
January 17, 2025 at 12:02 pm
Oh – right. I don’t have direct access anymore but I will request the log from the server and send it over when I have it.
I don’t know exactly, no – but what I’ve also just done last night is installed the Stripe payment gateway so I will also test that out – because if that works, I will just stick with that.
Thanks.
|
|
Drew Hume
|
January 20, 2025 at 2:03 pm
Hey Tony – I’ve got the error log. How can I send it to you?
|
|
Tony
|
January 20, 2025 at 3:47 pm
This reply has been marked as private.
|
|
Tony
|
January 21, 2025 at 8:12 am
Thank you.
Unfortunately, that error log isn’t helpful here.
It does indeed highlight an issue and fatal errors being thrown, but this is what you’re getting:
2025/01/19 19:50:10 [error] 1759401#1759401: *595804 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught TypeError: mysqli_num_fields(): Argument #1 ($result) must be of type mysqli_result, false given in /home/navina/public_html/wp-includes/class-wpdb.php:3859
#6 /home/navina/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(1630): EventEspresso\core\services\datab" while reading response header from upstream, client: 172.70.35.110, server: navina.ca, request: "GET /media/thai-massage-pictures/0494img_8883/feed/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php8.3-fpm.sock:", host: "de.navina.ca"
#5 /home/navina/public_html/wp-content/plugins/event-espresso-core-reg/core/services/database/TableAnalysis.php(90): wpdb->get_results()
#4 /home/navina/public_html/wp-includes/class-wpdb.php(3142): W3TC\DbCache_WpdbNew->query()
#3 /home/navina/public_html/wp-content/plugins/w3-total-cache/DbCache_WpdbNew.php(122): W3TC\DbCache_WpdbInjection_QueryCaching->query()
#2 /home/navina/public_html/wp-content/plugins/w3-total-cache/DbCache_WpdbInjection_QueryCaching.php(227): wpdb->__get()
#1 /home/navina/public_html/wp-includes/class-wpdb.php(780): wpdb->load_col_info()
#0 /home/navina/public_html/wp-includes/class-wpdb.php(3859): mysqli_num_fields()
So EE is calling the activation help, on like 1630, wee see that in the log: EEH_Activation.helper.php(1630)
That code is:
public static function table_exists(string $table_name): bool
{
return EEH_Activation::getTableAnalysis()->tableExists($table_name);
}
But the fatal is thrown becuase W3Total Cache is hooking in there and somehow a core function is trugning an unexpected value.
You can try disabling W3TC’s Database caching within its settings to see if it prevents the fatals BUT… I’m not so sure that fatal is related to the issue at hand. That’s from EE checking if specific database tables exist, its not directly related to the functions that are running when your getting problems although it could be running in the background at the same time.
Have you still had issues whilst using Stripe?
|
