Getting a typeError error in django project

Question

I created a virtual environment for my new project, installed django and started the new project. However, whenever i run a line of code with manage.py i get this long error.

PS D:\My stuff\Website development\Isow website\isow> python manage.py makemigrations
No changes detected
Traceback (most recent call last):
  File "manage.py", line 22, in <module>
    main()
  File "manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "C:\Users\rahma\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line
    utility.execute()
  File "C:\Users\rahma\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", line 375, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Users\rahma\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", line 336, in run_from_argv
    connections.close_all()
  File "C:\Users\rahma\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.py", line 224, in close_all
    connection.close()
  File "C:\Users\rahma\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\sqlite3\base.py", line 248, in close
    if not self.is_in_memory_db():
  File "C:\Users\rahma\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\sqlite3\base.py", line 367, in is_in_memory_db
    return self.creation.is_in_memory_db(self.settings_dict['NAME'])
  File "C:\Users\rahma\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\sqlite3\creation.py", line 12, in is_in_memory_db
    return database_name == ':memory:' or 'mode=memory' in database_name
TypeError: argument of type 'WindowsPath' is not iterable

Database Entry:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

Your settings.py; what does the DATABASES entry look like? — deceze
– deceze ♦, Commented Aug 17, 2020 at 8:21
@deceze I edited my post and added the Database entry in my settings.py — Abdulrahman
– Abdulrahman, Commented Aug 17, 2020 at 8:33
Does this answer your question? return database_name == ':memory:' or 'mode=memory' in database_name TypeError: argument of type 'WindowsPath' is not iterable — Tomerikoo
– Tomerikoo, Commented Nov 11, 2021 at 12:12

iklinac · Accepted Answer · 2020-08-17 12:01:52Z

5

It does seem NAME is being converted to pathlib.Path (WindowsPath) object instead of string which then cannot be used in Django in same way as os.path expects strings (Not 100% sure as did not investigate in depth)

So casting in string would be appropriate

'NAME': str(os.path.join(BASE_DIR, "db.sqlite3"))

edited Aug 17, 2020 at 12:01

answered Aug 17, 2020 at 11:33

iklinac

15.8k5 gold badges32 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ralf Over a year ago

See my answer to a similar question with a possible explanation of the issue. The issue seems to be fixed in newer Django versions.

fcdt · Accepted Answer · 2020-10-05 18:14:23Z

2

Make sure you really execute your command in the venv (you should see (venv))

If you are then as @iklinac said, this should fixe your issue:

'NAME': str(os.path.join(BASE_DIR, "db.sqlite3"))

edited Oct 5, 2020 at 18:14

fcdt

2,5215 gold badges17 silver badges27 bronze badges

answered Oct 5, 2020 at 17:48

XanderInDev

212 bronze badges

Comments

rs_punia · Accepted Answer · 2021-07-31 19:11:20Z

0

Also, for Django>=3.1, the path module is included in place of the os module. Therefore, use:

'NAME': str(BASE_DIR / 'db.sqlite3')

So, DB sqlite3 settings will look like this in settings.py.

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.sqlite3',
    'NAME': str(BASE_DIR / 'db.sqlite3')
    }
}

answered Jul 31, 2021 at 19:11

rs_punia

4492 gold badges6 silver badges17 bronze badges

Comments

Community · Accepted Answer · 2024-10-31 09:29:18Z

0

It's not obvious, but when creating a new project, if the 'static' folder is created and you have such a variable STATICFILES_DIRS = (BASE_DIR / 'static',). Don't forget to put a comma at the end. If you do not put a comma, this will cause this error. Perhaps there will be some similar variable.

edited Oct 31, 2024 at 9:29

CommunityBot

11 silver badge

answered Oct 26, 2024 at 10:14

egor

12 bronze badges

2 Comments

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

egor Over a year ago

This is due to the fact that a tuple must be passed. And a tuple with one element looks exactly like this (BASE_DIR / "static",)

Collectives™ on Stack Overflow

Getting a typeError error in django project

4 Answers 4

1 Comment

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related