JEM5-alpha1: 1062 Duplicate entry 'defaultCountry' for key '###_jem_config.PRIMARY'

[jobrusche]

Joomla 6.02 / PHP 8.4.6 - compat6 disabled
Settings : trying to save default country

Call Stack

| Function | Location

1 | () | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:411
2 | Joomla\Database\Mysqli\MysqliStatement->execute() | JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:649
3 | Joomla\Database\DatabaseDriver->execute() | JROOT/components/com_jem/classes/config.class.php:225
4 | JemConfig->store() | JROOT/administrator/components/com_jem/models/settings.php:115
5 | JemModelSettings->store() | JROOT/administrator/components/com_jem/controllers/settings.php:126
6 | JemControllerSettings->save() | JROOT/libraries/src/MVC/Controller/BaseController.php:730
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_jem/jem.php:53
8 | require_once() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
9 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher::{closure:Joomla\CMS\Dispatcher\LegacyComponentDispatcher::dispatch():70}()
| JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
10 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() | JROOT/libraries/src/Component/ComponentHelper.php:361
11 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/AdministratorApplication.php:150
12 | Joomla\CMS\Application\AdministratorApplication->dispatch() | JROOT/libraries/src/Application/AdministratorApplication.php:206
13 | Joomla\CMS\Application\AdministratorApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:320
14 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/administrator/includes/app.php:58
15 | require_once() | JROOT/administrator/index.php:32

System panel : Database management says problem with JEM database
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', AND null = 'YES'' at line 1
One Problem
Table '###_jem_events' has the wrong type or attributes for column 'modified' with type datetime. (From file 2.3.14.sql.)

[mckillo]

I have tested these 3 defaults setting and all of them work!
Please, test with JEM 5.0.00 Alpha 2:
https://github.com/jemproject/JEM-Project/blob/JEM-5alpha-for-Joomla6/pkg_jem_5alpha2.zip

[jojo12]

I tested with JEM 5.0.0 Alpha 2 on Joomla! 6 with and without compat 6: I can save all 3 default settings without any errors
I tested the same with my adapted JEM 4.0.0 on Joomla!6 with and without compat 6: no errors there too.

EDIT: But I am on php 8.3.30. When I upgrade to php 8.4 I get problems with other extensions too. Not ready!

[jobrusche]

Tested on Joomla 6.0.3 with PHP 8.4.7 (no JEM installed before)
JEM5.0-alpha2 Installed correctly
Can change and save default venue and country
However [Config info] shows JEM 5.0.0-alpha1 and at the top of the config table I see the characters ]; ?>

[jojo12]

Does it make sense to continue testing alpha1 when there is an alpha 2?

[mckillo]

Sorry, this zip was an alpha-1 modifed and I don't change the xml.
I glad that issue go away.

[jojo12]

I relooked this issue. And sorry, I was looking on the wrong place, so I wasn't able to reproduce.
But now I've seen in Alpha 2, that there's still a problem: at the end of the countries list I have a: "NO_VALID_COUNTRY", which should not be!
EDIT: event in my adapted 4.0.0 for J!6 this persists (I thought, we just resolved it (forgot how to)

It could make sense, because there are countries which are not even accepted as country. But then there should be for this key a translation even on english!

[mckillo]

This issue is resolved in JEM 5.0.0 Alpha 2, so it can be closed.