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:

[steffanov]

Hi Jan,

thank you for your quick answer in august and sorry that it took me 3 months to reply, here are some more informations for you:

Currently we have Phoca Cart Version 5.2.2 and our problem of not being able to edit saved orders still persists.

Enabling debug mode gives me the following:

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

Call Stack
# Function --- Location
1 () --- JROOT/administrator/components/com_phocacart/models/phocacartorder.php:441
2 PhocaCartCpModelPhocacartOrder->storeOrderAddress() --- JROOT/administrator/components/com_phocacart/models/phocacartorder.php:182
3 PhocaCartCpModelPhocacartOrder->save() --- JROOT/libraries/src/MVC/Controller/FormController.php:689
4 Joomla\CMS\MVC\Controller\FormController->save() --- JROOT/libraries/src/MVC/Controller/BaseController.php:730
5 Joomla\CMS\MVC\Controller\BaseController->execute() --- JROOT/administrator/components/com_phocacart/controllers/phocacartcommon.php:23
6 PhocaCartCpControllerPhocaCartCommon->execute() --- JROOT/administrator/components/com_phocacart/phocacart.php:26
7 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
8 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() --- JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
9 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() --- JROOT/libraries/src/Component/ComponentHelper.php:361
10 Joomla\CMS\Component\ComponentHelper::renderComponent() --- JROOT/libraries/src/Application/AdministratorApplication.php:150
11 Joomla\CMS\Application\AdministratorApplication->dispatch() --- JROOT/libraries/src/Application/AdministratorApplication.php:205
12 Joomla\CMS\Application\AdministratorApplication->doExecute() --- JROOT/libraries/src/Application/CMSApplication.php:304
13 Joomla\CMS\Application\CMSApplication->execute() --- JROOT/administrator/includes/app.php:58
14 require_once() --- JROOT/administrator/index.php:32

Using also the n3t-Plugin we get in addition:

User Deprecated: Since joomla/database 2.2.0: The parameter $new is deprecated and will be removed in 4.0, use Joomla\Database\DatabaseDriver::createQuery() instead.

Note: the last muted error may have nothing to do with the thrown exception.

.../libraries/vendor/symfony/deprecation-contracts/function.php:25

15: *
16: * @param string $package The name of the Composer package that is triggering the deprecation
17: * @param string $version The version of the package that introduced the deprecation
18: * @param string $message The message of the deprecation
19: * @param mixed ...$args Values to insert in the message using printf() formatting
20: *
21: * @author Nicolas Grekas <p@tchwork.com>
22: */
23: function trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void
24: {
25: @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
26: }
27: }

and under 'Environment/$_POST/jform:


'billing_address' =>

array

'id' => '218'
'name_first' => 'XXX'
'name_last' => 'XXX'
'company' => ''
'address_1' => 'XXX'
'zip' => 'XXX'
'city' => 'XXX'
'country' => '81'
'email' => 'XXX'
'shipping_address' =>
[i replaced true name, address, zip, city and email with XXX]
array

'id' => '219'
'ba_sa' => '1'
'name_first' => ''
'name_last' => ''
'company' => ''
'address_1' => ''
'zip' => ''
'city' => ''
'country' => ''


A huge thank you in advance.
Stefan

[Jan]

Hi, the default user field for country is integer value:



Do you use other form field for storing country? (e.g. the default was removed in database and changed)

When not, can you post a screenshot of country (form field) setting? (like the screenshot in this post).

Can you paste the screenshot of form fields in order edit?



Jan