Page 1 of 1

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

Posted: 22 Aug 2025, 09:41
by 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

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

Posted: 26 Aug 2025, 12:37
by 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:

Image

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

Posted: 24 Nov 2025, 17:43
by 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

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

Posted: 29 Nov 2025, 01:16
by Jan
Hi, the default user field for country is integer value:

Image

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?

Image

Jan

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

Posted: 09 Dec 2025, 14:41
by steffanov
Hi Jan,
i found the mistake. Among the options of the formular field 'country' two fields contained the string 'Deutschland':
https://imgur.com/a/lBGICjQ
After having cleared both fields, the error was fixed.
Thank you for your help and your great PhocaCart!

Stefan

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

Posted: 09 Dec 2025, 20:52
by Benno
@steffanov,
danke für Deinen Screenshot. Ich konnte damit einen Fehler in:
de-DE.com_phocacart.ini
reparieren.

Vorher:
Image

Nachher:
Image

Gefixt in:
https://www.reisefotografien.eu/downloa ... -j5-j6-zip

Freundliche Grüße,
Benno