search

nstlaurent / DoomLauncher

Doom Launcher is a doom launching utility and database for custom wads and pk3s
GNU General Public License v3.0
225 stars 19 forks source link

Doom Launcher giving SQL logic error #259

Closed Turbine2k5 closed 2 years ago

Turbine2k5 commented 2 years ago

DL throwing SQL issue upon startup. Screenshot and Details of error provided.

DL Issue DL issue.txt

nstlaurent commented 2 years ago

Download ReleaseBuild\DoomLauncher_3.6.0.0.zip from this build: https://ci.appveyor.com/project/hobomaster22/doomlauncher/builds/44396202

Overwrite DoomLauncher.exe from the zip and it should be good.

Do you know what version you were updating from? The section that broke was pushed for a version that is almost 2 years old.

Turbine2k5 commented 2 years ago

I did download 3.6.0.0 via the update function from a past version of DL. I tried repairing it with the 3.6.0 release from the repo, but I still get this error.

Turbine2k5 commented 2 years ago

Went ahead and copied all files from the zip. Now I'm receiving a new error: dl issue DL issue.txt

nstlaurent commented 2 years ago

The issue may go away if you restart the app. Since the updated was interrupted it may still be an issue. If it is manually go to the folder and make sure these files are deleted: SQLite.Interop.dll, SQLite.Interop.dll.bak, 7z.dll

Turbine2k5 commented 2 years ago

Deleted those files in both the main directory, as well as the x64 and x86 directories. Now I get this:

System.UnauthorizedAccessException: Access to the path is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileInfo.MoveTo(String destFileName) at DoomLauncher.MainForm.InitFileCheck(String initFile, String file, Boolean directory) at DoomLauncher.MainForm.VerifyDatabase()

nstlaurent commented 2 years ago

Check if there is a file named DoomLauncher.sqlite and delete it. Not sure why it wouldn't have access to clear this out this file. Also check for a folder named GameFiles with an underscore as well. Hopefully that should be it.

Turbine2k5 commented 2 years ago

Deleted DoomLauncher.sqlite and there was no folder called GameFiles. Now I get an error box that says "Initialization failure. Could not find DoomLauncher database.

nstlaurent commented 2 years ago

There should be a folder named Backup. Copy the latest file and put it in the main DoomLauncher directory and rename it to DoomLauncher.sqlite

Turbine2k5 commented 2 years ago

I do not have a folder called Backup.

nstlaurent commented 2 years ago

Forgot you ran the installer. It would be in this folder path: C:\Users\your_username\AppData\Roaming\DoomLauncher

It's the same procedure, just copy and rename in that directory instead.

Turbine2k5 commented 2 years ago

DL Issue DL issue.txt

nstlaurent commented 2 years ago

Running the latest installer should clear this up. https://github.com/nstlaurent/DoomLauncher/releases/download/3.6.1/DoomLauncher_3.6.1.0_install.zip

SirKnightTG commented 2 years ago

I'm seeing the same issue as in the original post with the 3.6.1.0 installer.

nstlaurent commented 2 years ago

Make sure you have a GameFiles directory and DoomLauncher.sqlite file in this location: C:\Users\your_username\AppData\Roaming\DoomLauncher

Delete these files/folders if they exist in the program files location: C:\Program Files (x86)\Doom Launcher

GameFiles DoomLauncher.sqlite DoomLauncher_.sqlite

Turbine2k5 commented 2 years ago

I still receive the Archived column error.

nstlaurent commented 2 years ago

I finally nailed down all the problems updating from this old version. Run the updated installer here and you should be all set. https://github.com/nstlaurent/DoomLauncher/releases/download/3.6.2/DoomLauncher_3.6.2.0_install.zip

Turbine2k5 commented 2 years ago

Program started and ran with no issues. Thank you for the help.