One-Page Checkout [Support Thread]

[carlwhat]

I wonder if the above is to do with MySql Strict Mode, although I had no problem with the same database version on ZC v1.5.8

(I am running MySQL 5.5.68-MariaDB, I know, but an upgrade is in my sights - I have to update my VPS from CentOS 7 to Alma 8 which is a bit of a headache)

i can not see what strict mode would have to do with it. it does not look to be a database problem.

line 173 expects the zone id to be an integer. it is not.

the question is what is the address? and specifically the zone_id.

you might be able to change line 2080 to:

'PAYMENTREQUEST_0_SHIPTOSTATE' => zen_get_zone_code($temp_address['country']['id'], (int)$temp_address['zone_id'], $temp_address['state']), 

but i would be curious what the address is. and again what is the zone_id.

right after line 2073, you could add, something like:

if (!is_int($temp_address['zone_id'])) {
    trigger_error(json_encode($temp_address));
} 

which would create a zc log file with the whole address.

hope that gives you a couple of ways forward.

best.