custom_field_custom_fieldset missing primary key #10892
Labels
Comments
snipe
added a commit
that referenced
this issue
Apr 5, 2022
…m_fields_pivot Fixed #10892 - MySQL 8 compatibilty requires primary key
|
Thanks for the quick patch! |
# for free
to join this conversation on GitHub.
Already have an account?
# to comment
Debug mode
Describe the bug
The
custom_field_custom_fieldsettable is missing the primary key.This causes problems on MySQL v8, in particular on cloud hosted databases like Digital Ocean which requires the primary key for replication & data integrity.
Please add a primary key to this table to resolve this issue (all other tables appear to be okay).
Thank you,
Reproduction steps
...
Expected behavior
The primary key should be added to prevent replication & data integry issues on clustered setups
Screenshots
No response
Snipe-IT Version
v5.4.1 build 6746 (g3e22dce11)
Operating System
SnipeIT Docker Image
Web Server
NGINX
PHP Version
7.3
Operating System
No response
Browser
No response
Version
No response
Device
No response
Operating System
No response
Browser
No response
Version
No response
Error messages
No response
Additional context
No response
The text was updated successfully, but these errors were encountered: