You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Problem:
Character blueprints endpoint failing due to Integrity constraint violation: 1062 Duplicate entry
This looks to be due to the blueprint item_id already existing in the database but under a different character.
I checked the blueprint that has been throwing one of the errors and it was a blueprint that I had contracted between characters.
Guessing it is trying to add the blueprint into the database before removing it from the previous character.
Expected:
Blueprints job succeeds and updates all characters blueprints
Logs / Screenshots / Proof:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1036646390848' for key 'PRIMARY' in /var/www/seat/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112
Version Info:
Docker install.
+--------------------+---------------+----------------+
| Package Name | Local Version | Latest Version |
+--------------------+---------------+----------------+
| SeAT API | 4.6.0 | 4.6.0 |
| SeAT Console | 4.8.0 | 4.8.0 |
| SeAT Eve API | 4.13.1 | 4.13.1 |
| SeAT Notifications | 4.3.1 | 4.3.1 |
| SeAT Services | 4.2.0 | 4.2.0 |
| SeAT Web | 4.14.1 | 4.14.2 |
+--------------------+---------------+----------------+
The text was updated successfully, but these errors were encountered:
warlof
added a commit
to warlof/eveseat-eveapi
that referenced
this issue
Aug 31, 2021
Problem:
Character blueprints endpoint failing due to Integrity constraint violation: 1062 Duplicate entry
This looks to be due to the blueprint item_id already existing in the database but under a different character.
I checked the blueprint that has been throwing one of the errors and it was a blueprint that I had contracted between characters.
Guessing it is trying to add the blueprint into the database before removing it from the previous character.
Expected:
Blueprints job succeeds and updates all characters blueprints
Logs / Screenshots / Proof:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1036646390848' for key 'PRIMARY' in /var/www/seat/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112
Version Info:
Docker install.
+--------------------+---------------+----------------+
| Package Name | Local Version | Latest Version |
+--------------------+---------------+----------------+
| SeAT API | 4.6.0 | 4.6.0 |
| SeAT Console | 4.8.0 | 4.8.0 |
| SeAT Eve API | 4.13.1 | 4.13.1 |
| SeAT Notifications | 4.3.1 | 4.3.1 |
| SeAT Services | 4.2.0 | 4.2.0 |
| SeAT Web | 4.14.1 | 4.14.2 |
+--------------------+---------------+----------------+
The text was updated successfully, but these errors were encountered: