[Admin Edit:] moved from https://www.wp-pizza.com/topic/failed-orders/

Had a few people report that they got an error (simple “website says error” pop up” when trying to place an order. Most have been going through fine today but from the error logs we found the following at the time someone was having isses. Might be related to the other post I just made.

CRITICAL ERROR:
10000 | DB: Could not update order: INITIALIZED => FAILED
WPDB LAST QUERY (*might* be related): SELECT *, order_date as date_sort, '1' as blog_id  FROM  wpdp_wppizza_orders WHERE hash = 'b54c7df9499f9af170a843944f52360f045f26c8bb7cb35a2f73c716292508c0e7dbc2cc4451083a0ac3516c2379e1f0' AND payment_status IN ('UNCONFIRMED','INPROGRESS')     ORDER BY  date_sort DESC  LIMIT 0, 1
LAST PHP ERROR (*might* be related): Undefined index: ordervars IN FILE: "/home/calderwo/public_html/order/wp-content/plugins/wppizza/classes/class.wppizza.order_execute.php" ON LINE: "641"
PARAMETERS RECEIVED
Array
(
[code] => parameter_invalid_integer
[doc_url] => https://stripe.com/docs/error-codes/parameter-invalid-integer
[message] => This value must be greater than or equal to 1.
[param] => amount
[type] => invalid_request_error
)
UPDATE VALUES
Array
(
[order_date] => Array
(
[type] => %s
[data] => 2020-05-13 15:13:49
)
[order_date_utc] => Array
(
[type] => %s
[data] => 2020-05-13 14:13:49
)
[transaction_id] => Array
(
[type] => %s
[data] => 1589382829
)
[transaction_errors] => Array
(
[type] => %s
[data] => a:5:{s:4:"code";s:25:"parameter_invalid_integer";s:7:"doc_url";s:61:"https://stripe.com/docs/error-codes/parameter-invalid-integer";s:7:"message";s:46:"This value must be greater than or equal to 1.";s:5:"param";s:6:"amount";s:4:"type";s:21:"invalid_request_error";}
)
[display_errors] => Array
(
[type] => %s
[data] => a:1:{i:0;a:3:{s:8:"critical";b:0;s:8:"error_id";s:25:"parameter_invalid_integer";s:13:"error_message";s:46:"This value must be greater than or equal to 1.";}}
)
[payment_status] => Array
(
[type] => %s
[data] => FAILED
)
)
--------------------------------------------------------------------------

thanks

can you also ask your host and/or server administrator if they are running any kind of caching system as standard/default ?

the first thing that’s puzzeling here is this

those notices/errors there relate to the checkout process
how can there be any checkout payment related (i.e stripe) notices at all
at [13-May-2020 16:32:46 UTC]

if your shop closes at 14:00 PM UK (that would make it 15:00 UTC)

something is not right here…

i would certainly suggest you enable debug like in the link i sent above
your current info tells me it’s still off, so there’s probably not all the error info in the debug.log

i would suggest you increase the memory limit too
40M is fine for a simple blog that doesnt do much
anything more than that (like ecommerce for example) i’d do 128M minimum
though wppizza has quite a small footprint on that front – https://plugintests.com/plugins/wppizza/latest –
putting themes and different plugins alltogether will probably require more

that’s not just a wppizza thing, but generally the case.
i dont think any other ecommerce plugin – woocomerce at all – will recommend anything less than 128 here

>Just looked at debug file again, the error seems to be anytime anyone looks at the order page
ok, that gives me a starting point perhaps and i might be able to figure something out from there
other than the memory limit i talked about above, leave it as is for the moment –

you are closed anyway right now if i’m not mistaken, so you might get these errors sent to you while i try to pin things down , but you can ignore them for now (as you are closed)

>Debug now looks like this for reference
thanks, no need for that though. i can see this myself
let me see if i can reproduce this behaviour here first of all.
will get back to you when i know more – might take a bit of time though