Error Restoring Backup on Migration

The user_profiles table in my old backup really doesn’t contain column card_image_badge_id, so I edited the sql dump, added the new column (but not the profile_background_upload_id and card_background_upload_id that are present in newer schemas) - the CREATE TABLE now looks like this

CREATE TABLE public.user_profiles (
        user_id integer NOT NULL,
        location character varying,
        website character varying,
        bio_raw text,
        bio_cooked text,
        profile_background character varying(255),
        dismissed_banner_key integer,
        bio_cooked_version integer,
        badge_granted_title boolean DEFAULT false,
        card_background character varying(255),
        card_image_badge_id integer,
        views integer DEFAULT 0 NOT NULL
    );

and the restore worked. I get 500 after logging in to the site, but that may be the problem I’ve tried to escape from by starting the new instance in the first place.

1 Like