"user_version pragma appears to be broken" basically requires me to update to a non-existing version

My group and I were recording voice lines for a theatre play that is due to be played next week when suddenly audacity crashed and gave us the error;
“Failed to open database file: C:Users\Batosai\Documents\AudRepair\broken.aup3”

Details:
{
“timestamp”: 1701895167,
“event_id”: “2ad9fa389664d145885cbbe241ae5af0”,
“platform”: “native”,
“release”: “audacity@3.4.2”,
“contexts”: {
“os”: {
“type”: “os”,
“name”: “Windows”,
“version”: “10.0.19045”
}
},
“exception”: {
“values”: [
{
“type”: “Error_Opening_Project”,
“value”: “Failed to open database file:\n\n”,
“mechanism”: {
“type”: “runtime_error”,
“handled”: false,
“data”: {
“sqlite3.rc”: “11”,
“sqlite3.context”: “DBConnection::ModeConfig”,
“sqlite3.mode”: “PRAGMA .page_size = 65536;VACUUM;”,
“log”: “04:39:26: DBConnection SetDBError\n\tErrorCode: 11\n\tLastError: Failed to set page size for database \n\tLibraryError: database disk image is malformed\n04:39:26: DBConnection SetError\n\tErrorCode: 11\n\tLastError: Failed to open database file:\n\n\n\tLibraryError: (11): database disk image is malformed\n”
}
}
}
]
}
}

And then so I tried to troubleshoot it by following the forum post by jademan from (Corrupt or Otherwise Broken Audacity Project Recovery) I followed the instructions and ran the commands step by step in cmd.

Microsoft Windows [Version 10.0.19045.3693]
(c) Microsoft Corporation. All rights reserved.

C:\Users\Batosai>cd Downloads

C:\Users\Batosai\Downloads>cd AudRepair2

C:\Users\Batosai\Downloads\AudRepair2>dir
Volume in drive C has no label.
Volume Serial Number is 22D0-C0E9

Directory of C:\Users\Batosai\Downloads\AudRepair2

07/12/2023 01:25 AM .
07/12/2023 01:25 AM …
31/03/2023 06:08 PM 1,452,424 audacity-project-tools.exe
06/12/2023 09:30 PM 1,920,733,184 broken.aup3
31/03/2023 06:08 PM 1,252,232 sqlite3.exe
3 File(s) 1,923,437,840 bytes
2 Dir(s) 251,512,651,776 bytes free

C:\Users\Batosai\Downloads\AudRepair2>audacity-project-tools -drop_autosave broken.aup3
database disk image is malformed

C:\Users\Batosai\Downloads\AudRepair2>audacity-project-tools -recover_db -recover_project broken.aup3
Database is badly broken. Running recovery…
Using ‘sqlite3.exe’ for recovery
Executing query #1858 (PRAGMA writable_schema = off;)…uence’(rowid, ‘name’, ‘seq’) VALUES (1, 'samp)…
Project requires Audacity 5.6.85
user_version pragma appears to be broken…

Notice the last line ^^^ I tried running it in audacity and it gave me this error; “This project was created with a newer version of Audacity. You will need to upgrade to open it.” I’m in ver 3.4.2 btw.

Details:
{
“timestamp”: 1701895768,
“event_id”: “04f1b3cbe77e3b47a04ad7f38832ff18”,
“platform”: “native”,
“release”: “audacity@3.4.2”,
“contexts”: {
“os”: {
“type”: “os”,
“name”: “Windows”,
“version”: “10.0.19045”
}
},
“exception”: {
“values”: [
{
“type”: “Error_Opening_Project”,
“value”: “This project was created with a newer version of Audacity.\n\nYou will need to upgrade to open it.”,
“mechanism”: {
“type”: “runtime_error”,
“handled”: false,
“data”: {
“log”: “04:39:27: Error: Could not parse file "". \nError: Failed to open database file:\n\n\n04:49:27: DBConnection SetError\n\tErrorCode: 0\n\tLastError: This project was created with a newer version of Audacity.\n\nYou will need to upgrade to open it.\n\tLibraryError: \n”
}
}
}
]
}
}

What the hell is Audacity 5.6.85?? pls help.

See: Recover project - Audacity 80.156.6

After repairing your corrupt database, you especially want to keep current backups, particularly in a .WAV file format that you can revert to.

Additionally, I sometimes copy the entire project to a new project by following these four (4) steps:

  1. Ctrl+A = Select All
  2. Ctrl+C = Copy
  3. Ctrl+N = New
  4. Ctrl+V = Paste; and do NOT copy smart clip information, when prompted.

Good luck!

Oh, and don’t run Audacity projects from networked drives.

1 Like

Thank you very much! you’re a life saver!!

This topic was automatically closed after 30 days. New replies are no longer allowed.