0 Incorrect integer value: 'Deutschland' for column 'country' at row 1

[steffanov]

Hi,
maybe this is a bug according to recent updates, because in earlier versions it worked fine:
When i try to edit a order and save it, i get the error '0 - Incorrect integer value: 'Deutschland' for column 'country' at row 1'.
Guess the country should be saved as a varchar or its ID should be taken.

Joomla 5.3.3
PHP 8.3.24
DB MySQL 8.0.36 (utf8mb4_general_ci)

Thanx in advance
Stefan

[Jan]

Hi, which version of Phoca Cart do you use? Are you able to install n3t debug on your site and detect the wrong SQL when saving?

https://n3t.bitbucket.io/extension/n3t-debug/

(when enabled debug mode and n3t debug, the SQL should be displayed when the script stops with this error)

When debugging the values when saving order, both country columns have standard integer value: