In MySQL migrations are not working

[taruns-ghrix]

Bug Report

Description

When i'm trying to makemigrations using MySQL then it's giving the 1824 error

Steps to Reproduce

1. Created virtual environment
2. Installed the requirement.txt
3. Run the python manage.py makemigrations (First time all tables are not created then i run this command)
4. python manage.py makemigrations base
5. python manage.py migrate

Screenshots

[If applicable, provide screenshots illustrating the issue.]

Environment

• Django Version: Django==4.2.11
• Python Version: Python version, 3.10
• Operating System: Ubuntu 22.04
• MySQL Version Version - 8.0.40

Additional Information

[Any other relevant information, logs, error messages, or context that might help in understanding and fixing the issue.]

Labels

Bug

Priority

[High.]

@horilla-opensource

[horilla-opensource]

Hi @taruns-ghrix ,

If possible, please use PostgreSQL as we are moving Horilla completely to PostgreSQL database with improved performance and additional features for futures.

For the above mentioned issue, our development team will look into this and give you an update.

With Regards,
Team Horilla