Plex & cache issues

[The Acer]

I made a mistake of setting my appdata to write to the HDD, instead of prefer cache.

Then my Plex quit working. I realized my mistake and started to reverse my mistake.

I can not get my Plex to work now.

I verified my appdata is on my cache drive, and not anything left on HDDs, 

I restarted my server & plex app

 

Suggestions?

tower-diagnostics-20230417-0939.zip

[Squid]

When starting Plex does it return a specific error?

[The Acer]

on my unraid dashboard page, it says its started.

However, when I go to open webUI, nothing opens

Normally my plex server would also be accessible at this point, in this case, it is not.

In terms of errors, nothing has popped up, but I dont know where to check. the dashboard page says it has "started"

[The Acer]

I found out how to find the log,

this error comes up in the log:

Error: Unable to set up server: sqlite3_statement_backend::prepare: file is not a database for SQL: PRAGMA cache_size=512 (N4soci10soci_errorE)

[The Acer]

Hey, so concluded it was a corruptor database, so I deleted the database so it could rebuild it.

It build the database up, and I am able to connect to the server with my Iphone app,(across the internet) and web browser ( same network tower/port (web GUI), however, it does not using the web app app.plex.tv. It just wont load that server, unable to find it.

Suggestions?

 

 

NVM I got it to worked. Some port forwarding issue.

Resolved, thanks

Edited April 19, 2023 by The Acer