Ask Questions and Find Answers
Important:
Ask is now read-only. You can review any existing questions and answers, but not add anything new.
But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:
discuss.liferay.com
RE: Incomplete DB upgrade from 7.3 GA4 to GA6 - how to correct?
I started a project with 7.3 GA4 and at some point upgraded to GA6. Now I'm having some staging problems related to missing column on table. Comparing the DB from the upgraded project to a db from a clean install of GA6 there are some differences, like one table missing, at least.
Is there any way to force a db model verification? The db is postgres.
Problem solved by hand. Compared the two schemas and added the missing tables and columns.
Maybe it can help someone:
ALTER TABLE appbuilderappdatarecordlink ADD (
groupid bigint,
appbuilderappversionid bigint
);
CREATE TABLE appbuilderappversion (
uuid_ character varying(75),
appbuilderappversionid bigint NOT NULL,
groupid bigint,
companyid bigint,
userid bigint,
username character varying(75),
createdate timestamp without time zone,
modifieddate timestamp without time zone,
appbuilderappid bigint,
ddlrecordsetid bigint,
ddmstructureid bigint,
ddmstructurelayoutid bigint,
version character varying(75)
);
ALTER TABLE public.appbuilderappversion OWNER TO liferay;
ALTER TABLE ONLY appbuilderappversion
ADD CONSTRAINT appbuilderappversion_pkey PRIMARY KEY (appbuilderappversionid);