Actual: need to salvage the .migrate file when updating #495

Closed
opened 2025-11-20 04:49:13 -05:00 by saavagebueno · 0 comments
Owner

Originally created by @bourquep on GitHub (Feb 8, 2025).

Have you read and understood the above guidelines?

yes

📜 What is the name of the script you are using?

Actual Budget

📂 What was the exact command used to execute the script?

bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/actualbudget.sh)"

📝 Provide a clear and concise description of the issue.

After updating Actual Budget from v25.1.0 to v25.2.1 by running this script in the Actual Budget LXC:

bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/actualbudget.sh)"

Actual server won't start because of this error when running sqlite migrations: SqliteError: no such column: password.

According to this issue comment, it is because the .migrate file was not persisted.

I believe the update script should bring back the .migrate file from the backup, like is being done for the `.env file.

⚙️ What settings are you using?

  • Default Settings
  • Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

🔄 Steps to reproduce the issue.

  1. Install Actual Budget version 25.1.0 using the community script, using the default settings
  2. Upgrade to version 25.2.1 using the community script

Paste the full error output (if available).

SqliteError: no such column: password

🖼️ Additional context (optional).

No response

Originally created by @bourquep on GitHub (Feb 8, 2025). ### ✅ Have you read and understood the above guidelines? yes ### 📜 What is the name of the script you are using? Actual Budget ### 📂 What was the exact command used to execute the script? bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/actualbudget.sh)" ### 📝 Provide a clear and concise description of the issue. After updating Actual Budget from v25.1.0 to v25.2.1 by running this script in the Actual Budget LXC: `bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/actualbudget.sh)"` Actual server won't start because of this error when running sqlite migrations: `SqliteError: no such column: password`. According to [this issue comment](https://github.com/actualbudget/actual-server/issues/521#issuecomment-2526333329), it is because the `.migrate` file was not persisted. I believe the update script should bring back the `.migrate` file from the backup, like is [being done](https://github.com/community-scripts/ProxmoxVE/blob/main/ct/actualbudget.sh#L50) for the `.env file. ### ⚙️ What settings are you using? - [x] Default Settings - [ ] Advanced Settings ### 🖥️ Which Linux distribution are you using? Debian 12 ### 🔄 Steps to reproduce the issue. 1. Install Actual Budget version 25.1.0 using the community script, using the default settings 2. Upgrade to version 25.2.1 using the community script ### ❌ Paste the full error output (if available). ``` SqliteError: no such column: password ``` ### 🖼️ Additional context (optional). _No response_
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: SVI/ProxmoxVE#495