Better error messages for schema upgrade

[mixxxbot]

Reported by: daschuer
Date: 2012-03-23T19:48:17Z
Status: Fix Released
Importance: Low
Launchpad Issue: lp963408
Attachments: schema_update_error_msg.patch, schema_update_error_msg2.patch

---

If the schema.xml is outdated, the following error messages appears:

"
Unable to upgrade your database schema to version x.
Your mixxx.db file may be corrupt.
Try renaming it and restarting Mixxx.
"

This is confusing because the mixxx.db is actual in a fine state.

The attached patch against lp:mixxx #⁠2994 gives following message in this case:

Unable to upgrade your database schema to version x
Your <path to schema.xml> file may be outdated.

[mixxxbot]

Commented by: daschuer
Date: 2012-03-23T19:48:17Z
Attachments: schema_update_error_msg.patch

[mixxxbot]

Commented by: esbrandt
Date: 2012-04-06T10:30:16Z

---

Agree, the current error message is not helpful. But is the new one really better? We should provide a solution to the user if possible.

Is there is a helpful wiki/manual page we can link to? If not how would a solution to this error look like?

[mixxxbot]

Commented by: daschuer
Date: 2012-04-06T14:42:06Z

---

Hi jus,

the patch is better because it distinguishes the two cases:

Unable to upgrade your database schema to version x.
Your mixxx.db file may be corrupt.
Try renaming it and restarting Mixxx.

and

Unable to upgrade your database schema to version x
Your schema.xml file may be outdated.

I agree, it would be even better to add a wiki link for both cases.

[mixxxbot]

Commented by: daschuer
Date: 2012-06-11T19:30:13Z
Attachments: schema_update_error_msg2.patch

---

Updated patch with a third case, missing or invalid schema file.

[mixxxbot]

Commented by: rryan
Date: 2012-06-20T22:35:14Z

---

The patch looks good but I'm wary of updating the strings this late on such an important error message. I'd almost rather have a properly translated bad error message than English good error messages. What do you think?

[mixxxbot]

Commented by: daschuer
Date: 2012-06-21T05:35:38Z

---

Hi RJ,

I understand your concerns.
But I am sure there must be only a petty minority of our users which are
not able to figured out what this untranslated error message means.
This error message will usually not appear, but if, than the original
translated message is totally misleading in some cases.

2012/6/21 RJ Ryan <email address hidden>

The patch looks good but I'm wary of updating the strings this late on
such an important error message. I'd almost rather have a properly
translated bad error message than English good error messages. What do
you think?

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/963408

Title:
Better error messages for schema upgrade

Status in Mixxx:
In Progress

Bug description:
If the schema.xml is outdated, the following error messages appears:

"
Unable to upgrade your database schema to version x.
Your mixxx.db file may be corrupt.
Try renaming it and restarting Mixxx.
"

This is confusing because the mixxx.db is actual in a fine state.

The attached patch against lp:mixxx #⁠2994 gives following message in
this case:

Unable to upgrade your database schema to version x
Your file may be outdated.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mixxx/+bug/963408/+subscriptions

[mixxxbot]

Commented by: esbrandt
Date: 2012-06-21T06:05:28Z

---

The goal is to provide assistance to the user in case the error occurs which the current message certainly does not - translated or not. Imo it is better to have a correct error message in english than to have a nicely translated but incorrect error message in the local language. +1 for inclusion in 1.11.

[mixxxbot]

Commented by: rryan
Date: 2012-06-21T17:06:29Z

---

Sounds good to me -- patch committed. Thanks!

[mixxxbot]

Issue closed with status Fix Released.

[sven-simulacrum]

hallo

I am getting this message installing Mixxx 2.4 on Mac OS 10.14.6 Mojave, Intel 2,7 GHz Intel Core i5. I certainly do not understand how to fix it from what is in this thread above.

Unable to upgrade your database schema to version 39
Your mixxxdb.sqlite file may be corrupt.
Try renaming it and restarting Mixxx.
For help with database issues consult:
https://www.mixxx.org/support

[daschuer]

Please post your mixxx.log
https://github.com/mixxxdj/mixxx/wiki/Finding-the-mixxx.log-file

[sven-simulacrum]

mixxx.log

[sven-simulacrum]

Did that work? Apologies, I’m not often on this list. Still having trouble installing…not sure what to do about it.

[daschuer]

That is strange:

Info [Main]: SchemaManager - Upgrading database schema from version 0 to version 32
Info [Main]: SchemaManager - Upgrading to database schema to version 1 : "The base schema for the Mixxx SQLITE database."
Critical [Main]: FwdSqlQuery - Failed to prepare "CREATE TABLE Playlists (\n        id INTEGER primary key,\n        name varchar(48),\n        position INTEGER,\n        hidden INTEGER DEFAULT 0 NOT NULL,\n        date_created datetime,\n        date_modified datetime)" : QSqlError("1", "Unable to execute statement", "table Playlists already exists")
Critical [Main]: SchemaManager - Failed to upgrade database schema from version 0 to version 1

It looks like that the very first attempt of creating a mixxx.dbsqlite fails.

Can you please file a new GitHub issue. I am not a macOS developer hopefully someone else is jumping in.
Can this be a permission issue?

Mixxx should check and report this if the case.

[sven-simulacrum]

Yes this is correct. It fails on the very first attempt. It happened when I was trying to upgrade to the current stable version (2.4.0). Also, I can also no longer re-install an earlier version without getting the same error. Sure I will file a new issue.

[daschuer]

#12894