I managed to get past this error by looking at the fresh install of zammad 5.4 I’m guessing the upgrade scripts didn’t run. i exported the schema for the things the API was complaining about from this fresh install of 5.4 to this upgraded 5.4 and got it so i can log in along with get to the tickets but there are still other things i suspect are not done as it is erroring on adjusting tickets.
I, [2023-03-16T06:14:10.499831#9949-111240] INFO -- : Started POST "/api/v1/taskbar" for 10.0.4.5 at 2023-03-16 06:14:10 +0000
I, [2023-03-16T06:14:10.504682#9949-110720] INFO -- : Started GET "/api/v1/tickets/2346?all=true&auto_assign=true&_=1678947240258" for 10.0.4.5 at 2023-03-16 06:14:10 +0000
I, [2023-03-16T06:14:10.510365#9949-111240] INFO -- : Processing by TaskbarController#create as JSON
I, [2023-03-16T06:14:10.511342#9949-111240] INFO -- : Parameters: {"key"=>"Ticket-2346", "callback"=>"TicketZoom", "params"=>{"ticket_id"=>2346, "overview_id"=>2, "shown"=>true}, "prio"=>2, "notify"=>false, "active"=>true, "id"=>"c-0"}
I, [2023-03-16T06:14:10.513100#9949-110720] INFO -- : Processing by TicketsController#show as JSON
I, [2023-03-16T06:14:10.516178#9949-110720] INFO -- : Parameters: {"all"=>"true", "auto_assign"=>"true", "_"=>"1678947240258", "id"=>"2346"}
E, [2023-03-16T06:14:10.528163#9949-111240] ERROR -- : undefined method `app' for #<Taskbar id: nil, user_id: 4, last_contact: nil, client_id: nil, key: "Ticket-2346", callback: "TicketZoom", state: {}, preferences: {}, params: {"ticket_id"=>2346, "overview_id"=>2, "shown"=>true}, prio: 2, notify: false, active: true, created_at: nil, updated_at: nil> (NoMethodError)
CREATE TABLE public.public_links (
id integer NOT NULL,
link character varying(500) NOT NULL,
title character varying(200) NOT NULL,
description character varying(200),
screen character varying[] NOT NULL,
new_tab boolean DEFAULT true NOT NULL,
prio integer NOT NULL,
updated_by_id integer NOT NULL,
created_by_id integer NOT NULL,
created_at timestamp(3) without time zone NOT NULL,
updated_at timestamp(3) without time zone NOT NULL
);
ALTER TABLE public.public_links OWNER TO zammad;
--
-- Name: public_links_id_seq; Type: SEQUENCE; Schema: public; Owner: zammad
--
CREATE SEQUENCE public.public_links_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.public_links_id_seq OWNER TO zammad;
--
-- Name: public_links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zammad
--
ALTER SEQUENCE public.public_links_id_seq OWNED BY public.public_links.id;
--
-- Name: public_links id; Type: DEFAULT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.public_links ALTER COLUMN id SET DEFAULT nextval('public.public_links_id_seq'::regclass);
--
-- Name: public_links public_links_pkey; Type: CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.public_links
ADD CONSTRAINT public_links_pkey PRIMARY KEY (id);
--
-- Name: index_public_links_on_link; Type: INDEX; Schema: public; Owner: zammad
--
CREATE UNIQUE INDEX index_public_links_on_link ON public.public_links USING btree (link);
--
-- Name: public_links fk_rails_3033635a3a; Type: FK CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.public_links
ADD CONSTRAINT fk_rails_3033635a3a FOREIGN KEY (updated_by_id) REFERENCES public.users(id);
--
-- Name: public_links fk_rails_350fadd8cc; Type: FK CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.public_links
ADD CONSTRAINT fk_rails_350fadd8cc FOREIGN KEY (created_by_id) REFERENCES public.users(id);
CREATE TABLE public.user_overview_sortings (
id integer NOT NULL,
user_id integer NOT NULL,
overview_id integer NOT NULL,
prio integer NOT NULL,
updated_by_id integer NOT NULL,
created_by_id integer NOT NULL,
created_at timestamp(3) without time zone NOT NULL,
updated_at timestamp(3) without time zone NOT NULL
);
ALTER TABLE public.user_overview_sortings OWNER TO zammad;
--
-- Name: user_overview_sortings_id_seq; Type: SEQUENCE; Schema: public; Owner: zammad
--
CREATE SEQUENCE public.user_overview_sortings_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.user_overview_sortings_id_seq OWNER TO zammad;
--
-- Name: user_overview_sortings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zammad
--
ALTER SEQUENCE public.user_overview_sortings_id_seq OWNED BY public.user_overview_sortings.id;
--
-- Name: user_overview_sortings id; Type: DEFAULT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.user_overview_sortings ALTER COLUMN id SET DEFAULT nextval('public.user_overview_sortings_id_seq'::regclass);
--
-- Name: user_overview_sortings user_overview_sortings_pkey; Type: CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.user_overview_sortings
ADD CONSTRAINT user_overview_sortings_pkey PRIMARY KEY (id);
--
-- Name: index_user_overview_sortings_on_overview_id; Type: INDEX; Schema: public; Owner: zammad
--
CREATE INDEX index_user_overview_sortings_on_overview_id ON public.user_overview_sortings USING btree (overview_id);
--
-- Name: index_user_overview_sortings_on_user_id; Type: INDEX; Schema: public; Owner: zammad
--
CREATE INDEX index_user_overview_sortings_on_user_id ON public.user_overview_sortings USING btree (user_id);
--
-- Name: user_overview_sortings fk_rails_07211fbc85; Type: FK CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.user_overview_sortings
ADD CONSTRAINT fk_rails_07211fbc85 FOREIGN KEY (user_id) REFERENCES public.users(id);
--
-- Name: user_overview_sortings fk_rails_16d8008529; Type: FK CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.user_overview_sortings
ADD CONSTRAINT fk_rails_16d8008529 FOREIGN KEY (created_by_id) REFERENCES public.users(id);
--
-- Name: user_overview_sortings fk_rails_2eaee08c60; Type: FK CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.user_overview_sortings
ADD CONSTRAINT fk_rails_2eaee08c60 FOREIGN KEY (updated_by_id) REFERENCES public.users(id);
ALTER TABLE taskbars rename table taskbars1;
CREATE TABLE public.taskbars (
id integer NOT NULL,
user_id integer NOT NULL,
last_contact timestamp(3) without time zone NOT NULL,
key character varying(100) NOT NULL,
callback character varying(100) NOT NULL,
state text,
preferences text,
params character varying(2000),
prio integer NOT NULL,
notify boolean DEFAULT false NOT NULL,
active boolean DEFAULT false NOT NULL,
app character varying DEFAULT 'desktop'::character varying NOT NULL,
created_at timestamp(3) without time zone NOT NULL,
updated_at timestamp(3) without time zone NOT NULL
);
ALTER TABLE public.taskbars OWNER TO zammad;
--
-- Name: taskbars_id_seq; Type: SEQUENCE; Schema: public; Owner: zammad
--
CREATE SEQUENCE public.taskbars_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.taskbars_id_seq OWNER TO zammad;
--
-- Name: taskbars_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zammad
--
ALTER SEQUENCE public.taskbars_id_seq OWNED BY public.taskbars.id;
--
-- Name: taskbars id; Type: DEFAULT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.taskbars ALTER COLUMN id SET DEFAULT nextval('public.taskbars_id_seq'::regclass);
--
-- Name: taskbars taskbars_pkey; Type: CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.taskbars
ADD CONSTRAINT taskbars_pkey PRIMARY KEY (id);
--
-- Name: index_taskbars_on_key; Type: INDEX; Schema: public; Owner: zammad
--
CREATE INDEX index_taskbars_on_key ON public.taskbars USING btree (key);
--
-- Name: index_taskbars_on_user_id; Type: INDEX; Schema: public; Owner: zammad
--
CREATE INDEX index_taskbars_on_user_id ON public.taskbars USING btree (user_id);
--
-- Name: taskbars fk_rails_f3c54fdb6d; Type: FK CONSTRAINT; Schema: public; Owner: zammad
--
ALTER TABLE ONLY public.taskbars
ADD CONSTRAINT fk_rails_f3c54fdb6d FOREIGN KEY (user_id) REFERENCES public.users(id);
