[Admin Edit:] moved from https://support.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
            )

    )

    --------------------------------------------------------------------------

or conversely – whatever is easiest – set everything to 10000000 or something and then individually set the once you want to have lower stock levels.
either will work

maybe one day i allow for “-1” or something to mark things as “always in stock”, but that’s not happening anytime soon as stated

And finally, here it is https://support.wp-pizza.com/downloads/wppizza-stockmanagement/

just a quick update on the above , as this is somewhat easier now with wppizza v3.something

you can target elements when pickup is selected like so (assuming here you want to hide the name and address for example)
use your browsers element inspector to ascertain whats the exact classname you need

.wppizza-order-ispickup .wppizza-personal-details > .wppizza-cname{display:none}
and/or
.wppizza-order-ispickup .wppizza-personal-details > .wppizza-caddress{display:none}
and/or 
etc etc 

make sure to not hide things that you have also set to be “required” though or the customer will never be able to check out ….

>Is this possible please?
in a nutshell: no. the plugin allows to select from an available date/time according to your settings.
i would have thought that the vast majority of customers are not going to complain if its a few minutes earlier

but of course, you could somewhat adjust the labeling somewhat from the default
“When would you like to order for ?”
to
“When would you like to order by ? (we might be up to 15 minutes earlier)”
or something to that effect

they are centered with the name you have given the sizes underneath
see here what this typically looks like
https://demo.wp-pizza.com/kale/

but as you have chosen to make the “sizes” name something like “box of strawberries 500 grams” you’ll have to set the css to be right aligned if you want it that way
https://docs.wp-pizza.com/developers/?section=frontend-css-styles-layout

PS: something in your site also inexplicably adds things like

<font style="vertical-align: inherit;"><font style="vertical-align: inherit;" class="">3.00</font></font>

around the prices…
just mentioning it , it’s certainly not wppizza doing it

ok, thanks
nothing too obvious, but have you tried turning off all non-wppizza plugins to see if it’s caused by one of those ?
or indeed switching to a default theme ?

>Is there a possibility

that’s what the “set as private reply” checkbox is for

no
if you are open between 5 and 7 the only timeslots available are between 5 and 7
if you are closed at any given time the timeslots available will still only be the ones between 5 and 7

in essence, the customer can order outside of your opening hours (unless specifically disabled) for a timeslot *during* your opening hours

>How does the sort order work if all of them are 0 – does it then sort by title to determine the order?
that’s a question for wordpress actually the default (ID) simply orders by “menu_order” column in the wp_posts table.
(WPPIZZA is just a custom post type so on that front behaves just like other posts) i suspect that wordpress itself soe some sorting if 2 order id’s are equal by published date or something
all thing being equal, the frontend is essentially the same order as the order the items are displayed in the backend (wppizza>menu items)

ignoring all of that, i somewhat suspect you have some other plugin running somewhere that changes the sort order
have you tried turning off other plugins ?