cache.php and critical app errors

[RCodiaDavid]

Hi, strange things happening all of a sudden today.

I have a huge error log all relating to cache.php

Also a customer order came through but no email received and it's not in orders or in customer history.
Speaking of which, there in NO customer order history at all, all gone! Orders are still in Sales/Orders but not this one.

Here is an example of the logs, it goes on for 6626 lines so best not paste it all here. I deleted the log and it came back again.

2::warning
Trying to access array offset on value of type null in /home/customer/www/ourstore.com/public_html/store/core/lib/cache.php on line 624
2::warning
Undefined array key "layout" in /home/customer/www/ourstore.com/public_html/store/core/lib/cache.php on line 598
2::warning
Trying to access array offset on value of type null in /home/customer/www/ourstore.com/public_html/store/core/lib/cache.php on line 598
2::warning
Undefined array key "layout" in /home/customer/www/ourstore.com/public_html/store/core/lib/cache.php on line 601
2::warning
Trying to access array offset on value of type null in /home/customer/www/ourstore.com/public_html/store/core/lib/cache.php on line 601
2::warning
Undefined array key "layout.block.template.12.3.store_0" in /home/customer/www/ourstore.com/public_html/store/core/lib/cache.php on line 616
2::warning
Undefined array key "layout" in /home/customer/www/ourstore.com/public_html/store/core/lib/cache.php on line 621

We also have a critical App Error:

App Error
Message status:
critical
Date:
09/22/2023 03:36:32 PM
Number of repetitions:
101
aMySQLi class error: Try to escape non-string value: array ( 0 => '830', ) (file: /home/customer/www/ourstore.com/public_html/store/core/lib/cart.php line 255) Trace: #0 /home/customer/www/ourstore.com/public_html/store/core/database/amysqli.php on line 154 #1 /home/customer/www/ourstore.com/public_html/store/core/lib/db.php on line 107 #2 /home/customer/www/ourstore.com/public_html/store/core/lib/cart.php on line 255 #3 /home/customer/www/ourstore.com/public_html/store/core/lib/cart.php on line 154 #4 /home/customer/www/ourstore.com/public_html/store/core/lib/cart.php on line 838

Can someone help?

[llegrand]

a bit of confusion on our part

the "ourstore.com"  goes to https://store.ourrescue.org/   and that is a shopify site>

We have to ask,  are you asking for help in the correct forum ? AbanteCart

[RCodiaDavid]

Yeah it's Abantecart, I just changed the name of the store in case it was a security issue.

[Basara]

Hello,
It seems that you have debug mode on, which causes a lot of logs to appear. To turn it off, go to Admin → System → Settings → System and change Debug Level: to Level 1 or Level 0. Debug mode should not be On in production.

Then, clear your AbanteCart error log.

Also, please share your AbanteCart error and tell me if this is a fresh installation or an upgrade from an older version.

[RCodiaDavid]

Hi,
Yes it was already set to level 1 so I have set it to 0 and cleared logs now.

We started with version 1.2.15 and we are now on 1.3.4.

It seems to be working again for the moment as other orders have gone through before and after the missing one. Just one order the payment went through but nothing registered on the store.

But no transaction history is being saved for anyone, it shows the total number of orders but nothing under the customer account transactions tab.

[Basara]

Hello.
One possible reason for missing records is that your database was offline when the payment confirmation was sent. This could prevent the payment information/order from being stored in the database.

[RCodiaDavid]

Hi again,
That may have been the case with that transaction but now we are getting more errors in the log.
Seems to be the same error repeated 4 times at different intervals, same OrderId but at different times. 4:13, 6:14, 8:14 & 10:15 so two hours apart.

2023-09-26 4:13:01 - Paypal webhook PAYMENT.CAPTURE.COMPLETED: order ID 9540
Paypal related OrderId: 89U11368WC821835M but not found in the database.

Then there is a load of raw input data after this. (if you need full log let me know)

Customer says the transactions kept failing so he then paid via credit card, but then got a confirmation that they had indeed paid with PayPal so may have possibly paid twice! For now I have disabled the new PayPal module and have reactivated the old one to see if that stops this from reoccurring whilst we figure what is happening.

Edit: Seems these error logs are related to the earlier disappearing order but the logs showed up later after I deleted the other logs. As you say, it was probably a bad DB connection for that one transaction. Client getting jumpy with this second issue being raised so I will reactivate the newer PayPal module and keep an eye on it for now.

[Basara]

Hello.
Did you check Incomplete orders? In the Admin > Orders select the Incomplete status in the top bar

[RCodiaDavid]

Hi,
Ah yes they are there.

But we still have the issue that no notifications are coming through when the order is placed except from PayPal, and we have had another order go missing today. It seems it is just the PayPal payments so I'm guessing it's just the new PayPal module?

I've just clicked the "Update Webhooks" button but surely that would only need clicking once after connecting the account?

I've disconnected the new PayPal module and switched back to the old one again for now as I'm getting hassled lol.

[Basara]

Hello.
What is the order status you set in the PayPal module for the Success & captured and Success & not captured?
What is your Transaction Method?

[RCodiaDavid]

The transaction method is Capture
Success & Captured and also Not Captured is Processing

I think they are pretty much the default tbf.

[RCodiaDavid]

Well we have had another PayPal order come through but not register, no email from store but in orders under incomplete. Payment gone through to PayPal though.
And that is after switching to old PayPal module so it must be something deeper.

Also keep getting this error in the logs every 2 hours from the original missing order:
2023-09-26 18:17:51 - Paypal webhook PAYMENT.CAPTURE.COMPLETED: order ID 9540
Paypal related OrderId: 89U11368WC821835M but not found in the database.

Along with this one also:
2023-09-27 5:18:46 - Unknown Error: AbanteCart core v.1.3.4 Unknown named parameter $message in <b>/home/customer/www/ourstore.com/public_html/store/extensions/default_pp_standart/storefront/controller/responses/extension/default_pp_standart.php</b> on line <b>352</b>

Going to switch back to the newer PayPal module.
Client is pulling their hair out and not happy. I have no clue what is going on with it.

[abolabo]

Well we have had another PayPal order come through but not register, no email from store but in orders under incomplete. Payment gone through to PayPal though.
And that is after switching to old PayPal module so it must be something deeper.

Also keep getting this error in the logs every 2 hours from the original missing order:
2023-09-26 18:17:51 - Paypal webhook PAYMENT.CAPTURE.COMPLETED: order ID 9540
Paypal related OrderId: 89U11368WC821835M but not found in the database.

Along with this one also:
2023-09-27 5:18:46 - Unknown Error: AbanteCart core v.1.3.4 Unknown named parameter $message in <b>/home/customer/www/ourstore.com/public_html/store/extensions/default_pp_standart/storefront/controller/responses/extension/default_pp_standart.php</b> on line <b>352</b>

Going to switch back to the newer PayPal module.
Client is pulling their hair out and not happy. I have no clue what is going on with it.

default_pp_standart does not supported anymore. Please use paypal_commerce extension instead

[RCodiaDavid]

Yes I switched it out as I thought the new one might be causing the trouble. The new one is back on now.

I have done a Service Request now.

[RCodiaDavid]

Okay, after support looked at it it appears that the PayPal Express Checkout payment module, even though it wasn't active, was the culprit.

Even though we've never used it, it's not compatible with the new store template and needed uninstalling completely.

Still early days but looking okay so far.