Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Django] deactivated strict_trans_tables break Django/Mysql setup #1698

Open
nerdoc opened this issue Dec 22, 2023 · 0 comments
Open

[Django] deactivated strict_trans_tables break Django/Mysql setup #1698

nerdoc opened this issue Dec 22, 2023 · 0 comments
Labels
enhancement changes to a guide that is working fine. ✨Goodie for three PRs

Comments

@nerdoc
Copy link
Contributor

nerdoc commented Dec 22, 2023

A Django setup seems to need strict_trans_tables in mysql. So if you setup Django on an Uberspace 7, and start the server, you get a warning.

you can prevent this by adding the sql_mode: traditional to the database options in your django setup:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'OPTIONS': {
            'sql_mode': 'traditional',  # tolerate deactivated strict_trans_tables
        }
    }
}

Uberspace should add that to the Django setup guide in Uberspace lab.

@SalocinHB SalocinHB changed the title deactivated strict_trans_tables break Django/Mysql setup [Django] deactivated strict_trans_tables break Django/Mysql setup Dec 27, 2023
@SalocinHB SalocinHB added the enhancement changes to a guide that is working fine. ✨Goodie for three PRs label Dec 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement changes to a guide that is working fine. ✨Goodie for three PRs
Projects
None yet
Development

No branches or pull requests

2 participants