Unable to dump: Failed to dump database: no such column: email_notifications_preference

[Ghardo]

Hello,
i want to backup my gitea data but i get always this error:

Failed to dump database: no such column: email_notifications_preference
git@tools:~$ gitea dump -c /etc/gitea/app.ini
2020/02/10 14:21:35 ...dules/setting/git.go:91:newGit() [I] Git Version: 2.11.0
Failed to dump database: no such column: email_notifications_preference

I have updated my gitea version from 1.9.2

git@tools:~$ gitea -v
Gitea version 1.11.0+rc2-24-g9169b3945 built with GNU Make 4.1, go1.13.7 : bindata, sqlite, sqlite_unlock_notify

• Gitea version (or commit ref): gitea-1.11-linux-arm-6
• Git version: 2.11.0
• Operating system: Raspbian GNU/Linux 9 (stretch) (lite version)
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • MSSQL
  • SQLite

[Ghardo]

ok i fixed my problem with the migrate option but the sql contains no data only the structure

[guillep2k]

I think you attempted to dump your database using a 1.10.0+ (edit: actually 1.11.0+rc2) executable before executing the upgrade process, since that column was added in #7813 and did not exist in 1.9.2.

You need to dump your database only with your current version, and then upgrade.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. I am here to help clear issues left open even if solved or waiting for more insight. This issue will be closed if no further activity occurs during the next 2 weeks. If the issue is still valid just add a comment to keep it alive. Thank you for your contributions.

[stale]

This issue has been automatically closed because of inactivity. You can re-open it if needed.