Installing on macOS db error won't load page

matajuro

After running the setup command: dotnet FileFlows.Server.dll I get these errors and it won't load in a browser.

Error: One or more errors occurred. (SQLite Error 1: 'no such table: DbObject'.)
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task1.GetResultCore(Boolean waitCompletionNotification) at System.Threading.Tasks.Task1.get_Result()
at FileFlows.Server.Program.PrepareDatabase() in /src/Server/Program.cs:line 261
at FileFlows.Server.Program.Main(String[] args) in /src/Server/Program.cs:line 106
Error -> Error: One or more errors occurred. (SQLite Error 1: 'no such table: DbObject'.)
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task1.GetResultCore(Boolean waitCompletionNotification) at System.Threading.Tasks.Task1.get_Result()
at FileFlows.Server.Program.PrepareDatabase() in /src/Server/Program.cs:line 261
at FileFlows.Server.Program.Main(String[] args) in /src/Server/Program.cs:line 106
2022-12-15 12:48:53.865 [ERRR] -> Error: One or more errors occurred. (SQLite Error 1: 'no such table: DbObject'.)
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task1.GetResultCore(Boolean waitCompletionNotification) at System.Threading.Tasks.Task1.get_Result()
at FileFlows.Server.Program.PrepareDatabase() in /src/Server/Program.cs:line 261
at FileFlows.Server.Program.Main(String[] args) in /src/Server/Program.cs:line 106

reven

Try stopping FileFlows and deleting the FileFlows.sqlite db file. Looks like it didnt create it successfully the first time.

matajuro

reven Okay I'm new to this how do I stop it? I don't see file flows in activity monitor. And where is the db located?

reven

assuming you started from the command line, just stop it from the command line.
The FileFlows.sqlite file is in the data directory off the main fileflows directory, wherever you put it.

matajuro

So stop it with the kill command or is there a different way to kill it?

reven

just ctrl + c.

Though i suppose on a mac its likely cmd + c. (Sorry been a decade since I've used a mac)

matajuro

I figured it out Gatekeeper was blocking parts of it from running because sit wasn't signed by apple. Once I went into CLI and ran sudo spctl --master-disable to turn off gatekeeper it ran an is now working fine.