Got an error creating the test database: database "" already exists

[Salima Begum]

Hi all,

After writing test cases I run test cases I am getting an error below

```

Python manage.py behave

```

After running the above command I am getting this error.

```
Creating test database for alias 'default'...
Got an error creating the test database: database "test_newDataBase" already exists

Type 'yes' if you would like to try deleting the test database 'test_newDataBase', or 'no' to cancel: yes
Destroying old test database for alias 'default'...
Traceback (most recent call last):
  File "C:\Users\USER 1\PycharmProjects\behaveproject\venv\lib\site-packages\django\db\backends\utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation "trades_trade_table" does not exist
.....
.....
django.db.utils.ProgrammingError: relation "trades_vk_trade_table" does not exist

```

Please help me to resolve this issue.

Thank you

~Salima

[Sebastian Jung]

Hey salima,

This error is strange. Django try to use a Relation in postgresql which doesn't exist.

I have only tip that you cam reset database. I would delete database in postgresql and create it new with psql tool. After this you must reset all migrations:

https://simpleisbetterthancomplex.com/tutorial/2016/07/26/how-to-reset-migrations.html

And after this when you migrate it, then structure is created in new database.

I am sorry i have no idea how yoz can fix relation exception manual.

Regards

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAMSz6b%3DTEv%3DH25L7giQV6w%3DYw6%3D6GJrvh5zPezqQWMger3VNzQ%40mail.gmail.com.

[DJANGO DEVELOPER]

you need to run migrations first and then run the tests. if the issue still persists. let me know

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKGT9mx2sRizWo8Qd%3Dn6yYFKUB1KvjKH%2Bi92Hj_fdoStRYc%3DWg%40mail.gmail.com.

[Salima Begum]

Yes I run migrations still I am seeing the new issue below

```

django.db.utils.ProgrammingError: relation "auth_user" does not exist

```

Thank you 

~Salima

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9pkx0hJ3U_DFCia_UUY-ecieMJ0%2BE3uE75aTziehr1KWSg%40mail.gmail.com.

[Avinash Alanjakar]

Their are lots of pre-bulit apps in django so you need to migrate them first. 

In your case you are using the authentication with migrating their tables with database.

Try to run command in this sequence. This might be solve your problem.

python manage.py migrate

python manage.py makemigrations

python manage.py migrate

Thanks,

Avinash

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAMSz6b%3DZTCYy%2BY1NoRSh9t0S0UcLkwcSb_31SYqzOg95SU%2Bq6Q%40mail.gmail.com.

[Prashanth Patelc]

Check your settings.py once 

Add auth_user='app.UserModel'

Or

1) delete database and migrations

2) create new db

3) python manage.py makemigration

4) python manage.py migrate

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALW8ud2Gv8Hc7qgP9cf7hXoVU1NTe9SFp%3DVFqEL9y_YGPyN70g%40mail.gmail.com.

[DJANGO DEVELOPER]

what version of Django are you using? and how did you make migrations?

Should be like this:

1 - python manage.py makemigrations

2 - python manage.py migrate

are you using custom user model? or django's built in User model?

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAMCU6Cr9gjUGbvcot622Y6zt%2BQmepp2LJuTnpW2kRjPe7O1yyA%40mail.gmail.com.

[Salima Begum]

Hi,

I am using django version 3.2.9 and Yes above you mentioned like that only i am running migrations.

1. python manage.py makemigrations

2. python manage.py migrate

No, I am not using django build in user model. I am using my custom one.

a

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9p%3DN0QN_xCv0e-nUQR9xA29cJ7GCYM44ShiAVaOxMw-qDQ%40mail.gmail.com.