Error Restoring Backup on Migration

خلل
18

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)