Error deleting a subcommunity

13 views
Skip to first unread message

Night Librarian

unread,
Apr 19, 2022, 11:42:34 PM4/19/22
to DSpace Technical Support
Greetings,

My colleague accidentally created a sub-community in our DSpace 4 and wants to delete it, but when he clicks on "Delete Community", he has the following error:

org.postgresql.util.PSQLException: ERROR: constraint "com2com_child_fk" does not exist

How could it be fixed?

The community2community table has 47 rows and looks like this:

Snag_255a96d3.png

Additional information about the table:

-- Table: public.community2community
-- DROP TABLE public.community2community;
CREATE TABLE public.community2community
(
  id integer NOT NULL,
  parent_comm_id integer,
  child_comm_id integer,
  CONSTRAINT community2community_pkey PRIMARY KEY (id),
  CONSTRAINT community2community_parent_comm_id_fkey FOREIGN KEY (parent_comm_id)
      REFERENCES public.community (community_id) MATCH Unknown
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.community2community
  OWNER TO postgres;
==========================================

CREATE TABLE public.community2community (
    id integer NOT NULL,
    parent_comm_id integer,
    child_comm_id integer
);

ALTER TABLE public.community2community OWNER TO postgres;
--
-- TOC entry 206 (class 1259 OID 16451)
-- Name: community2community_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.community2community_seq
    START WITH 42
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
Reply all
Reply to author
Forward
0 new messages