Bad server response after added a new language about atrocore HOT 7 CLOSED

Hello,

We don't support MariaDB yet.

We plan to use Doctrine in the future, so when we will do it, MariaDB will be available.

from atrocore.

I installed mysql:latest with port 3308 in docker, successfully installed atrocore PIM&DAM. This language 500 error still insist.

logs: /data/logs/atro-2022-06-01.log
[2022-06-01 00:41:38] Log.ERROR: PDO Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'locale.PRIMARY'. For query 'INSERT INTO locale (id, name, language, date_format, time_zone, week_start, time_format, thousand_separator, decimal_mark) VALUES ('1', 'Main', 'en_US', 'DD.MM.YYYY', 'UTC', 'monday', 'HH:mm', '.', ',')' [] []
[2022-06-01 00:50:55] Log.ERROR: API [GET]:/api/v1/Settings, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_zh_cn' in 'field list' [] []
[2022-06-01 00:50:55] Log.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_zh_cn' in 'field list', Code: 42S22 URL: /api/v1/Settings [] []
[2022-06-01 00:52:16] Log.ERROR: API [GET]:/api/v1/Settings, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_zh_cn' in 'field list' [] []
[2022-06-01 00:52:16] Log.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_zh_cn' in 'field list', Code: 42S22 URL: /api/v1/Settings [] []

from atrocore.

We created the issue internally. We will answer about it in the nearest future.

from atrocore.

waiting for it to be fixed soon, we would like to use it in production, SQLSTATE[23000], SQLSTATE[42S22] I dig these in internet, this issue is cause by the PHP strings, would be easy to fix, hope it to be fix by using composer update.

from atrocore.

Please run: php index.php sql diff --run
This will prepare DB for new DB schema.

In the next release of core, we will fix this bug. Thanks, for found this BUG for us.

from atrocore.

Appreciated, this command helpful. need run this command by each language has added

from atrocore.

The problem fixed at core 1.4.50

from atrocore.