Server Version#: 1.15.2.793-782228f99
Player Version#: N/A
got prompted to upgrade to the latest 1.15.2.x release today, but after I did so, Plex was thoroughly broken. tried restarting a bunch of times, but the web interface on port 32400 just returns a 500 error. looking at “/var/log/plex/Plex Media Server.log”, seems like the sqlite database is messed up, or not properly upgraded:
Mar 19, 2019 15:32:04.546 [0x7fb7527fc700] ERROR - SQLITE3:(nil), 1, no such column: devices.platform in "select devices.id as ‘devices_id’, devices.identifier as ‘devices_identifier’, devices.name as ‘devices_name’, devices.created_at as ‘devices_created_at’, devices.updated_a
Mar 19, 2019 15:32:04.546 [0x7fb7527fc700] ERROR - Soci Exception handled: sqlite3_statement_backend::prepare: no such column: devices.platform for SQL: select devices.id as ‘devices_id’, devices.identifier as ‘devices_identifier’, devices.name as ‘devices_name’, devices.created_at as ‘devices_created_at’, devices.updated_at as ‘devices_updated_at’, devices.platform as ‘devices_platform’ from devices where identifier=?
Upgraded today and now I’m having an issue where I cannot click on anything from the dashboard. It shows that there are two “items” running but when I click on the “2” to see what it is, I get a “No Soup For You” screen!
Yep upgraded today to 1.15.1.791 (it popped up on the top of my server, and there are no more current updates) and bam no more remote access within the house on my tvs, or mobile devices. I tried the troubleshooting, resetting the router, the pc, checked the firewall, and all other recommended connections including the NAT and it is all functioning correctly. I have had the plex remote servers working for months up until this most recent update.
ok, so I downloaded to the latest release in their apt repo (1.14.1.5488), and now it works fine again, with the original database files. so I’d recommend just downloading this package, as it seems to be a completely broken update.
Same problem here with the loss of Remote Access as soon as I updated to 1.15.1.791 this afternoon. Remote Access had been running perfectly for probably the last 2 years. Now can’t get it to stay green for more than a couple of seconds. Nothing has changed here. The Relay seems to work in its absence but would sure like to get Remote Access back! Any suggestions from anyone who can get it back working please let us know.
Can you please explain to us how to exactly downgrade from the latest update? I’ve never had to do that before, but with the broken Remote Access now, I’m wanting to do that. I’m just not sure how as PMS does it all within itself to upgrade, so I’m not sure how to manually downgrade.
Same problem here on Ubuntu 18.04. Upgraded with this package: plexmediaserver_1.15.1.791-8bec0f76c_amd64.deb
Now getting server connection refused when accessing locally. Access from other local devices no longer works.
I tried installing a previously downloaded package: plexmediaserver_1.14.1.5488-cc260c476_amd64.deb and am still receiving the same error. Service status shows everything is working correctly and I see nothing out of the ordinary in the logs. This seems like a permission issue but I have no idea what to change. Any help would be greatly appreciated.
Running Ubuntu 18.04.2 LTS here. Same situation of colleagues … appeared alert for manual upgrade, I downloaded .deb for version 1.15.1.791-8bec0f76c. Download done, package installed and WOW!
Nothing else works …
extremely frustrating.
With the “systemctl status plexmediaserver” I see that the server is active / running.
But strangely, with “sudo netstat -lnpt | grep Plex” I get absolutely nothing.
Ran the removal line that you posted in your last reply and installed 1.14 again, still no luck. I’ve uploaded the logs as requested. Thank you in advance for taking a look at this.
Thanks for the help, but I need to go to sleep. I had a long day and tomorrow will be another long journey. As soon as I can get free to see this, I’ll come back here.
