Field 'name' doesn't have a default value (errno 1364) | Django | Page 1

viral tartan May 21, 2023, 2:30 PM

#

Hi, i'm getting an error when running python manage.py migrate. Here is the full error:

MySQLdb.IntegrityError: (1364, 'target: myapp.-.primary: vttablet: rpc error: code = Unknown desc = Field \'name\' doesn\'t have a default value (errno 1364) (sqlstate HY000) (CallerID: ktqd6qz126ncpf0wale9): Sql: "insert into django_content_type(app_label, model) values (:vtg1, :vtg2)", BindVars: {REDACTED}')

My model:

class CustomUser(models.Model):
    username = models.CharField(max_length=50)
    password = models.CharField(max_length=50)
    subdomain = models.CharField(max_length=50)

    def __str__(self):
        return self.username

stark pulsar May 21, 2023, 3:12 PM

#

viral tartan Hi, i'm getting an error when running `python manage.py migrate`. Here is the fu...

What is CustomUser model and are you changing it?

viral tartan May 21, 2023, 3:50 PM

#

@stark pulsar it's my User model and no i'm not changing it, I just switched to using mysql so I need to run the migrate command but i'm getting the error I said above

stark pulsar May 21, 2023, 3:53 PM

#

That doesn't look like an reasonable code for a user model

viral tartan May 21, 2023, 3:54 PM

#

Yeah but i'm using mysql with django for the first time, i'm trying to learn how to use it with mysql

stark pulsar May 21, 2023, 3:55 PM

#

Well, anyway it seems that you are trying to write an empty value to db, so check what are you running

stark pulsar May 21, 2023, 3:56 PM

#

viral tartan Yeah but i'm using mysql with django for the first time, i'm trying to learn how...

Problem is that it doesn't look like it should be used with django

#

Especially 50-long password field is ALARMING

viral tartan May 21, 2023, 3:58 PM

#

stark pulsar Problem is that it doesn't look like it should be used with django

It works with sqlite tho

stark pulsar May 21, 2023, 3:58 PM

#

viral tartan It works with sqlite tho

That's not a problem

#

Even if it works, it may work in way it must not ever work

#

Or, are you really sure it works?

viral tartan May 21, 2023, 3:59 PM

#

yeah i am

viral tartan May 21, 2023, 4:01 PM

#

stark pulsar Well, anyway it seems that you are trying to write an empty value to db, so chec...

Oh, how can I rewrite my model so that it works then?

stark pulsar May 21, 2023, 4:01 PM

#

viral tartan Oh, how can I rewrite my model so that it works then?

Well, error doesn't seem to be linked with that model for a start

#

It's just that your model worries me that you are not doing auth correctly

#

Do you have a full traceback of an error?

viral tartan May 21, 2023, 4:05 PM

#

django.db.utils.IntegrityError: (1364, 'target: lunchautomate.-.primary: vttablet: rpc error: code = Unknown desc = Field \'name\' doesn\'t have a default value (errno 1364) (sqlstate HY000) (CallerID: ktqd6qz126ncpf0wale9): Sql: "insert into django_content_type(app_label, model) values (:vtg1, :vtg2)", BindVars: {REDACTED}')

This is the other part

stark pulsar May 21, 2023, 4:06 PM

#

And nothing above it?

#

It happens on migrate ?

viral tartan May 21, 2023, 4:06 PM

#

yes

stark pulsar May 21, 2023, 4:07 PM

#

What is full console output right after command?

#

If it doesn't go to "Applying migrations" (or smth like that) - you have bigger problems with your code

viral tartan May 21, 2023, 4:09 PM

#

It does go to applying migrations, i'm unable to send a screenshot here for some reason

stark pulsar May 21, 2023, 4:09 PM

#

We don't like screenshots, please copy text

viral tartan May 21, 2023, 4:09 PM

#

Alright

#

This is the output of show tables; in the mysql cli:

lunchautomate/main> show tables;
+----------------------------+
| Tables_in_lunchautomate    |
+----------------------------+
| auth_group                 |
| auth_group_permissions     |
| auth_permission            |
| auth_user                  |
| auth_user_groups           |
| auth_user_user_permissions |
| django_content_type        |
| django_migrations          |
+----------------------------+

#

Not sure if it helps you

#

Isn't there supposed to be some CustomUser table?

stark pulsar May 21, 2023, 4:11 PM

#

Well it only shows that migrations did run to some point

#

but again, I'd like to see output of migrate command from start to the end

viral tartan May 21, 2023, 4:11 PM

#

And this is the output of the migrate command:

Operations to perform:
  Apply all migrations: admin, auth, contenttypes, django_cron, sessions
Running migrations:
  No migrations to apply.
Traceback (most recent call last):
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/django/db/backends/mysql/base.py", line 75, in execute
    return self.cursor.execute(query, args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
          ^^^^^^^^^^^^^^^^^^
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/MySQLdb/connections.py", line 254, in query
    _mysql.connection.query(self, query)
MySQLdb.IntegrityError: (1364, 'target: lunchautomate.-.primary: vttablet: rpc error: code = Unknown desc = Field \'name\' doesn\'t have a default value (errno 1364) (sqlstate HY000) (CallerID: ktqd6qz126ncpf0wale9): Sql: "insert into django_content_type(app_label, model) values (:vtg1, :vtg2)", BindVars: {REDACTED}')

The above exception was the direct cause of the following exception:

#

the end I didnt send because of discord characters limit

viral tartan May 21, 2023, 4:12 PM

#

viral tartan ``` django.db.utils.IntegrityError: (1364, 'target: lunchautomate.-.primary: vtt...

but it's just this

stark pulsar May 21, 2023, 4:13 PM

#

Yeah, this one is more useful

#

well, there are no migrations for you model it seems

viral tartan May 21, 2023, 4:13 PM

#

Also do I understand it correctly that to use mysql with django I need to install mysqlclient with pip and mysql package with my systems package manager?

stark pulsar May 21, 2023, 4:15 PM

#

You need a mysql server running and at least a python client lib. Can't tell any more mysql is not very popular with django

stark pulsar May 21, 2023, 4:15 PM

#

viral tartan And this is the output of the migrate command: ``` Operations to perform: Appl...

Does python manage.py check work?

viral tartan May 21, 2023, 4:15 PM

#

Hmm I see, i'm trying to use mysql because I'm using planetscale

viral tartan May 21, 2023, 4:16 PM

#

stark pulsar Does `python manage.py check` work?

yeah it says: System check identified no issues (0 silenced).

stark pulsar May 21, 2023, 4:17 PM

#

Then I can guess it happens in post-migrate signal,though I don't have proofs

viral tartan May 21, 2023, 4:17 PM

#

I could try deleting all tables in my db and rerun the migrate command

stark pulsar May 21, 2023, 4:18 PM

#

Looks like error may come from MySQL configuration

#

Are you sure your version is compattible with django or python client?

viral tartan May 21, 2023, 4:25 PM

#

how can I know what mysql version I'm running?

viral tartan May 21, 2023, 4:26 PM

#

stark pulsar Are you sure your version is compattible with django or python client?

I'm not sure actually, before I had an error that said something about utf8mb3

#

so I had to change the charset of django sql client to utf8mb4

stark pulsar May 21, 2023, 4:26 PM

#

check your package manager

stark pulsar May 21, 2023, 4:26 PM

#

viral tartan so I had to change the charset of django sql client to `utf8mb4`

bleh, that's one reason I don't want to touch mysql with 5-meter stick

viral tartan May 21, 2023, 4:27 PM

#

It says this: mysql Ver 15.1 Distrib 10.11.2-MariaDB, for Linux (x86_64)

#

oh I don't even have mysql itself installed, but instead mariadb

#

these three:

Packages (3) mariadb-clients-10.11.3-1  mariadb-libs-10.11.3-1
             mariadb-10.11.3-1

stark pulsar May 21, 2023, 4:29 PM

#

mariadb is not mysql

#

Looks like it's a supported version of maria though

viral tartan May 21, 2023, 4:30 PM

#

I don't even know how I have installed mysql wait a sec

#

Yeah i have installed mariadb 10.11.2-2

stark pulsar May 21, 2023, 4:32 PM

#

I don't see any specific notes for maria in docs

#

So ifyou have django >= 3.0 it should work

#

not sure about python client

viral tartan May 21, 2023, 4:35 PM

#

for the python client I have mysqlclient 2.1.1

#

now it's giving me a different error after I had deleted all tables and rerun the migrate command:

Operations to perform:
  Apply all migrations: admin, auth, contenttypes, django_cron, sessions
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial...Traceback (most recent call last):
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/django/db/backends/mysql/base.py", line 75, in execute
    return self.cursor.execute(query, args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
          ^^^^^^^^^^^^^^^^^^
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/home/michal/Desktop/files/coding/python/lunchautomate/venv/lib/python3.11/site-packages/MySQLdb/connections.py", line 254, in query
    _mysql.connection.query(self, query)
MySQLdb.OperationalError: (1105, 'foreign key constraints are not allowed, see https://vitess.io/blog/2021-06-15-online-ddl-why-no-fk/')

hexed knot May 21, 2023, 4:36 PM

#

Your Custom user doesn't have a field like "name". Do you really have this field somewhere? may be on another model?

viral tartan May 21, 2023, 4:36 PM

#

I don't think so, I only have one models.py file

stark pulsar May 21, 2023, 4:37 PM

#

hexed knot Your Custom user doesn't have a field like "name". Do you really have this field...

see error, it's about contenttype table

hexed knot May 21, 2023, 4:39 PM

#

stark pulsar see error, it's about contenttype table

So can we see your content_type table @viral tartan ? and is it in use rn?

viral tartan May 21, 2023, 4:40 PM

#

I have no content_type table that I'm aware of

#

anyways I found this: https://planetscale.com/docs/tutorials/connect-django-app#optional--bring-in-planetscale-custom-database-wrapper

#

I probably need to use their database wrapper

stark pulsar May 21, 2023, 4:42 PM

#

viral tartan This is the output of `show tables;` in the mysql cli: ```sql lunchautomate/main...

It's here, but I don't think it's problem with it

hexed knot May 21, 2023, 4:42 PM

#

Looks like django has a bultin table like it https://docs.djangoproject.com/en/4.2/ref/contrib/contenttypes/#the-contenttype-model

Django Project

Django

The web framework for perfectionists with deadlines.

viral tartan May 21, 2023, 4:42 PM

#

I think the problem is that planetscale doesn't support foreign key constraints

#

I will switch to postgres then

hexed knot May 21, 2023, 5:00 PM

#

viral tartan I think the problem is that planetscale doesn't support foreign key constraints

You are right. https://planetscale.com/docs/tutorials/connect-django-app#disabling-foreign-key-constraints-in-django . They recommend a wrapper but i think it is not a good idea if you don't have to use planetscale.

#Field 'name' doesn't have a default value (errno 1364)