sheltermanager

Open full view…

"costpertreatment" column missing for database restore?

jrich1
Wed, 25 May 2022 15:11:19 GMT

Hi all, I've taken a SQL dump from our hosted site that I'm trying to restore to a local machine, but the restore eventually fails with <ERROR: column "costpertreatment" of relation "animalmedical" does not exist> and then rolls back all changes. Has anyone encountered this and has a fix? I do notice that our live site is 46u, but the download available from the website reports itself as 45, I'm not sure if that particular column only appeared in 46u? Or maybe there's something I need to enable via the web interface on my local copy before attempting the restore? I'm running Postgres on the local machine, which I believe I saw somewhere is what the hosted sites use? Thanks!

robinrt
Wed, 25 May 2022 15:19:24 GMT

Yes, it was added in the current release that is not out yet. Either upgrade your local version of the software from github, or you could manually add that column for now to make the error go away: ``` ALTER TABLE animalmedical ADD CostPerTreatment INTEGER; ```

jrich1
Wed, 25 May 2022 16:59:41 GMT

Thanks! Altering the table did the trick (for anyone else in this situation, the same needs to be done for the 'medicalprofile' table).