Incorrect datetime value for column `seat`.`alliances`.`date_founded`

bpvital commented 2 years ago

Installed fresh SeAT 7 days ago

Some jobs from public queue has been failing. one example:

PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2022-03-27 03:25:19' for column `seat`.`alliances`.`date_founded` at row 1 in /var/www/seat/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117

Stack trace: ... Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2022-03-27 03:25:19' for column seat.alliances.date_founded at row 1 in /var/www/seat/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: ... Next Illuminate\Database\QueryException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2022-03-27 03:25:19' for column seat.alliances.date_founded at row 1 (SQL: insert into alliances (alliance_id, name, creator_id, creator_corporation_id, ticker, executor_corporation_id, date_founded, faction_id, updated_at, created_at) values (99011459, An Unfortunate Alliance, 2116372381, 98709492, AUA, 1196707484, 2022-03-27 03:25:19, ?, 2022-04-05 06:06:24, 2022-04-05 06:06:24)) in /var/www/seat/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669 Stack trace: ...

Data:

warlof commented 2 years ago

Hi @bpvital,

can you send us the structure of table alliances ? You can do this by running the following query:

SHOW COLUMNS FROM alliances;

also, can you share your mysql settings related to sql_mode ? You can do so using this query:

SHOW VARIABLES;

in addition, can you give us information regarding your environment ?

is it docker ?
which distribution are you using ?
what's your processor architecture ?
what's your system architecture ? 32 bits ? 64 bits ?
which package versions are you using ? You can find those into Seat > Settings - there is a clipboard quick copy/paste function next to packages versions

bpvital commented 2 years ago

Hello, Thank you for response. Here is the additional info:

SHOW COLUMNS FROM alliances;

+-------------------------+--------------+------+-----+---------------------+-------+
| Field                   | Type         | Null | Key | Default             | Extra |
+-------------------------+--------------+------+-----+---------------------+-------+
| alliance_id             | int(11)      | NO   | PRI | NULL                |       |
| name                    | varchar(255) | YES  |     | NULL                |       |
| creator_id              | bigint(20)   | YES  | MUL | NULL                |       |
| creator_corporation_id  | bigint(20)   | YES  | MUL | NULL                |       |
| ticker                  | varchar(255) | YES  |     | NULL                |       |
| executor_corporation_id | bigint(20)   | YES  | MUL | NULL                |       |
| date_founded            | timestamp    | NO   |     | current_timestamp() |       |
| faction_id              | int(11)      | YES  | MUL | NULL                |       |
| created_at              | timestamp    | YES  |     | NULL                |       |
| updated_at              | timestamp    | YES  |     | NULL                |       |
+-------------------------+--------------+------+-----+---------------------+-------+

10 rows in set (0.001 sec)

| sql_mode | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

is it docker ? No

which distribution are you using? Ubuntu 20.04.4 LTS

what's your processor architecture ? vendor_id : GenuineIntel cpu family : 6 model : 63 model name : Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz

what's your system architecture ? 32 bits ? 64 bits ? 64

which package versions are you using ?

| Vendor  | Package Name   | Installed Version        |
| ------- | -------------- | ------------------------ |
| eveseat | api            | 4.8.0                    |
| eveseat | console        | 4.8.0                    |
| eveseat | eveapi         | 4.16.1                   |
| eveseat | notifications  | 4.3.1                    |
| eveseat | services       | 4.2.0                    |
| eveseat | web            | 4.18.1                   |
| ccp     | eve_online_sde | sde-20220308-TRANQUILITY |

warlof commented 2 years ago

Hi there, can you tell me which MariaDB version are you running ?

@Crypta-Eve can you check if that field shouldn't be a date/time ? I read such things might append when STRICT_TRANS_TABLES is active, but unsure. That's odd nobody else is having this.

eveseat / seat