Hello Daniel,

it's a database foreign key issue. Can it be, that somebody has removed 
entries from the database directly by using SQL?

You can try to stop Zammad, call "zammad run rails r 'Cache.clear'" and 
start Zammad again. But for me it seems to have problems with missing 
database records.


Am Dienstag, 26. September 2017 20:02:39 UTC+2 schrieb Daniel Schain:
> Hello.
> I have a Problem again. We defined new "Objects", updated the Database and 
> restartet Zammad. When I want to edit a User (In this Case: Add the 
> Organisation) and save the changes, this SQL-Error is displayed:
> PG::ForeignKeyViolation: ERROR: insert or update on table "histories" 
> violates foreign key constraint "fk_rails_b522a94d99" DETAIL: Key 
> (history_attribute_id)=(35) is not present in table "history_attributes". : 
> INSERT INTO "histories" ("history_type_id", "history_object_id", 
> "history_attribute_id", "o_id", "id_to", "value_from", "value_to", 
> "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, 
> $6, $7, $8, $9, $10) RETURNING "id"
> A second restart didn't fix this Problem. So, what can I do?
> Greetings from Germany,
> Daniel

Open Source as Download https://zammad.org || Easy to use as SaaS 
You received this message because you are subscribed to the Google Groups 
"zammad-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to zammad-users+unsubscr...@googlegroups.com.
To post to this group, send email to zammad-users@googlegroups.com.
To view this discussion on the web visit 
For more options, visit https://groups.google.com/d/optout.
  • SQL-Error 'Daniel Schain' via zammad-users
    • Re: SQL-Error Martin Edenhofer
    • Re: SQL-Error 'Daniel Schain' via zammad-users

Reply via email to