Duplicate entry 'defaultCountry' for key 'PRIMARY'

[Heklaterriol]

When saving the settings I get the error:

Duplicate entry 'defaultCountry' for key 'PRIMARY'

# | Function | Location
1 | () | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433
2 | mysqli_stmt->execute() | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433
3 | Joomla\Database\Mysqli\MysqliStatement->execute() | JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:675
4 | Joomla\Database\DatabaseDriver->execute() | JROOT/components/com_jem/classes/config.class.php:220
5 | JemConfig->store() | JROOT/administrator/components/com_jem/models/settings.php:101
6 | JemModelSettings->store() | JROOT/administrator/components/com_jem/controllers/settings.php:123
7 | JemControllerSettings->save() | JROOT/libraries/src/MVC/Controller/BaseController.php:672
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_jem/jem.php:55
9 | require_once() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
10 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
11 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() | JROOT/libraries/src/Component/ComponentHelper.php:355
12 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/AdministratorApplication.php:143
13 | Joomla\CMS\Application\AdministratorApplication->dispatch() | JROOT/libraries/src/Application/AdministratorApplication.php:186
14 | Joomla\CMS\Application\AdministratorApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:294
15 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/administrator/includes/app.php:61
16 | require_once() | JROOT/administrator/index.php:32

[Heklaterriol]

Just found out:

`#__jem_config` SET `keyname` = 'defaultCountry' WHERE `#__jem_config`.`keyname` = 'DEFAULTCountry';`

solves the problem

[Heklaterriol]

see commit 9004c79

[mckillo]

I agree, tested and works.