insert or update on table "csv_import_importtemplate" violates foreign key constraint #27

New issue

Closed

opened 2021-10-20 10:31:33 +02:00 by debdolph · 8 comments

debdolph commented 2021-10-20 10:31:33 +02:00 (Migrated from edugit.org)

Copy link

django.db.utils.IntegrityError: insert or update on table "csv_import_importtemplate" violates foreign key constraint "csv_import_importtemplate_site_id_a631dfb1_fk_django_site_id" DETAIL: Key (site_id)=(1) is not present in table "django_site".

`django.db.utils.IntegrityError: insert or update on table "csv_import_importtemplate" violates foreign key constraint "csv_import_importtemplate_site_id_a631dfb1_fk_django_site_id" DETAIL: Key (site_id)=(1) is not present in table "django_site".`

nik commented 2021-10-20 11:16:08 +02:00 (Migrated from edugit.org)

Copy link

assigned to @hansegucker

assigned to @hansegucker

hansegucker commented 2021-10-20 20:58:48 +02:00 (Migrated from edugit.org)

Copy link

Can you please show me the contents of your django_site table?

Can you please show me the contents of your `django_site` table?

hansegucker commented 2021-10-26 17:01:53 +02:00 (Migrated from edugit.org)

Copy link

@debdolph ?

@debdolph ?

hansegucker commented 2021-10-31 17:11:22 +01:00 (Migrated from edugit.org)

Copy link

created merge request !131 to address this issue

created merge request !131 to address this issue

hansegucker commented 2021-10-31 17:11:25 +01:00 (Migrated from edugit.org)

Copy link

mentioned in merge request !131

mentioned in merge request !131

hansegucker commented 2021-11-29 20:40:41 +01:00 (Migrated from edugit.org)

Copy link

@debdolph Can you please add a full traceback?

@debdolph Can you please add a full traceback?

hansegucker commented 2021-12-10 17:01:53 +01:00 (Migrated from edugit.org)

Copy link

assigned to @debdolph and unassigned @hansegucker

assigned to @debdolph and unassigned @hansegucker

debdolph commented 2021-12-19 21:36:03 +01:00 (Migrated from edugit.org)

Copy link

Hmm… sadly i am unable to reproduce the error…

Hmm… sadly i am unable to reproduce the error…

debdolph (Migrated from edugit.org) closed this issue 2021-12-19 22:54:06 +01:00

Sign in to join this conversation.

No Branch/Tag specified

Branches Tags

master

weblate

weblate-frontend

renovate/numpy-2.x

renovate/pandas-3.x

check/update-builddeps-package-json

66-adapt-to-places

62-add-generic-default-template-for-room

improved-and-export

csv-export

stable/3.0

release/2.0

feature/more-generic-field-types

feature/general-csv-importer

5.0.0

5.0.0b0

4.0.0.post1

4.0.0.post0

4.0.0

3.0.2

3.0.1

3.0

3.0b0

2.3.1

2.3

2.2.1

2.2

2.1

2.0.post0

2.0

2.0rc2

2.0rc1

2.0b1

2.0b0

1.0a3

1.0a2

1.0a1

1.0a0

Labels

Clear labels   

Security

  

TeX

Needs LaTeX template

  

auto-update

  

board

done

  

board

ready

  

board

todo

  

check

delete-eslint-rc-js

  

check

update-builddeps-package-json

  

check

update-eslint-rc-js

  

check

update-gitignore

  

check

update-merge-request-template

  

check

update-prettier-ignore

  

check

update-pyproject-toml

  

check

update-renovate-json

  

check

update-tox-ini

  

part

backend

Backend (view code, models, logic, etc.)

  

part

ci

  

part

docs

Issue or addition to the documentation

  

part

frontend

Frontend (templates, etc.)

  

part

i18n

Translation or internationalisation issue

  

part

non-technical

Non-technical (policy, maintenance, etc.) issue or discussion

  

part

packaging

Issue concerning the packaging of AlekSIS and components

  

prio

1

Priority High

  

prio

2

Priority Medium

  

prio

3

Priority Low

  

release-mr-5.x

  

size

large

  

size

medium

  

size

small

  

source

customer

Requested by a customer or affiliated user

  

source

customer::fsmw

  

source

customer::fss

  

source

customer::teckids

  

source

downstream

Issue or merge request from other projects using AlekSIS or parts of it

  

type

breaking

  

type

bug

Bug

  

type

feature

New feature

  

type

refactoring

  

workflow

blocked

Issue is blocked by another issue

  

workflow

confirmed

The bug is reproducible and will be fixed

  

workflow

current-todo

  

workflow

discussing

Needs to be discussed before implementation

  

workflow

new-app

Requires new AlekSIS app, which has to be created

  

workflow

wontfix

The bug is not reproducible or the feature was decided against

No labels

Security

TeX

auto-update

board

done

board

ready

board

todo

check

delete-eslint-rc-js

check

update-builddeps-package-json

check

update-eslint-rc-js

check

update-gitignore

check

update-merge-request-template

check

update-prettier-ignore

check

update-pyproject-toml

check

update-renovate-json

check

update-tox-ini

part

backend

part

ci

part

docs

part

frontend

part

i18n

part

non-technical

part

packaging

prio

1

prio

2

prio

3

release-mr-5.x

size

large

size

medium

size

small

source

customer

source

customer::fsmw

source

customer::fss

source

customer::teckids

source

downstream

type

breaking

type

bug

type

feature

type

refactoring

workflow

blocked

workflow

confirmed

workflow

current-todo

workflow

discussing

workflow

new-app

workflow

wontfix

Milestone

Clear milestone

No items

No milestone

Projects

Clear projects

No items

No project

Assignees

Clear assignees

No assignees

1 participant

Notifications

Subscribe

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

aleksis/AlekSIS-App-CSVImport#27

No description provided.