Error Guest checkout

[Webguy]

Error after ordering as a guest

Incorrect integer value: 'undefined' for column 'fleevnL_joomla24:kr36u_phocacart_order_users.region' at row 1

Region is disabled in the form fields



Also wondering, when using guest checkout the admin email has a lot of empty paramaters;
What is the right approach for this?
Voornaam: {b_name_first}
Tussenvoegsel: {b_name_middle}
Achternaam: {b_name_last}
Adres: {b_address_1}
Stad: {b_city}
Postcode: {b_zip}
Email: {b_email}
Telefoonnummer: {b_phone_1}

[Jan]

Hi, the region column is default column in table phocacart_order_users. Did you or someone else remove it from database? Such column needs to be a part of this table.

What do you mean with empty parameters?

Jan

[Webguy]

Hi Jan,

Region
Region is in the table.
# Naam Type Nul Standaardwaarde
20 region int(11) Nee 0

Region is disabled in the form for this webshop because we don't want it present in the user details. Address, postal code & City is enough. I don't know if that can have something to do with it?


Empty mail
The empty paramaters as above seen that is how the mail was received. Guest details were not put into the parameters. For example {b_name_first} should've been replaced by the guest first name.