Yes, the absolute path to plexWatch.db. Is recently watched showing anything? Which webserver are you using?
Can you also check your browsers console if you get any errors?
Yes, the absolute path to plexWatch.db. Is recently watched showing anything? Which webserver are you using?
Never mind...I enabled php_sqlite3.dll, but not php_pdo_sqlite.dll. That did the trick. May want to mention in your install notes what PHP modules need to be enabled. Otherwise, looks awesome so far.
Never mind...I enabled php_sqlite3.dll, but not php_pdo_sqlite.dll. That did the trick. May want to mention in your install notes what PHP modules need to be enabled. Otherwise, looks awesome so far.
That should be enabled by default but thanks I'll add it.
Glad you like it! Hope it continues to be awesome
Hi, was wondering if someone here might be able to help me get PlexWWWatch working. I'm still very green to Linux so I most likely failed to install something :). First off, I know for sure that PlexWatch is working as I can query the CLI and get data out of the DB. It took me a while to figure out how to get PlexWWWatch working. I used these steps to get Apache2 installed with PHP5. Then realized it only installed 5.3 and 5.4 or greater was needed so I followed these steps to upgrade PHP 5.3 to 5.5. Once I got PlexWWWatch enabled in Apache2 I browsed to the site and it loaded and I saw my recently added content but nothing for Watched. I can query the plexWatched.db VIA the CLI and get results so I know data should be displayed but it isn't. When I browse to public/backend/watched.php I get []. I checked the settings page and confirmed it's pointing to the correct default location of the plexWatched.db file. I have confirmed permissions on the settings folder were set to 777. When I look at the Apache2 error log I see this:
[Tue May 13 12:03:57.882426 2014] [:error] [pid 478] [client 10.10.10.25:35906] PHP Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /home/plex/PlexWWWatch/plex-watch/PlexWatch.php:12
Stack trace:
#0 /home/plex/PlexWWWatch/plex-watch/PlexWatch.php(12): PDO->__construct('sqlite:/opt/ple...')
#1 /home/plex/PlexWWWatch/PlexWWWatch.php(89): PlexWatch->__construct('/opt/plexWatch/...', false)
#2 /home/plex/PlexWWWatch/PlexWWWatch.php(104): PlexWWWatch->plexWatch()
#3 /home/plex/PlexWWWatch/public/backend/statistics.php(6): PlexWWWatch->statistics()
#4 {main}
thrown in /home/plex/PlexWWWatch/plex-watch/PlexWatch.php on line 12, referer: http://myserver.com/public/
I tried adding a trailing '/' to the plexWatched.db path but that didn't work. I tried commenting out the lines you mentioned in the public/backend/watched.php file but no change. Using Chrome's debug console I get an error going to the stats page "500 (Internal Server Error)" when getting the public/backend/statistics.php file. But that is all I can figure out :|
Can anyone help shed some light on this issue? I would love a front end to that DB and this looks really cool! Thanks!
Can you verify that you have installed php_pdo_sqlite?
I just ran 'sudo apt-get install php5-sqlite' and it installed as a new package. I restarted Apache and refreshed the page but nothing changed. Is there something else I have to restart or perhaps another piece is missing. The Apache error logs showing the same error as before.
Can you create a php file and insert:
<?php phpinfo(); ?>
and check which pdos that are enabled
I got it!!! Thanks so much Gyran for leading me down the right paths. I think the issue was resolved by installing that additional package but the way I was restarting Apache wasn't picking up on it. Once I ran sudo apache2ctl restart and refreshed the phpinfo page is when I saw the PDO get picked up. Refreshed PlexWWWatch and voila! Thanks again!
Perfect! Hope PlexWWWatch works great for you!
Hi -- just started using this and like it a lot. Is PlexWWWatch still being actively developed on?
Gyran, are you thinking about changing the colors of the statistics charts? Black on dark grey is not very clear. What about light grey?
Thanks.
I wouldn't say it's actively developed, I'm currently doing my master thesis and I don't have that much spare time but hopefully that will change once I'm done (in a couple of weeks). I have some things that are partially ready and soon ready to be released.
@radar: That's something I can start to think about.
Thanks.
Thank You !! this is just perfect ! :D
Glad you like it @smosse!
I pushed some updates to GitHub, watched statistics for shows and seasons and the color in the charts is now white.
Grab it at https://github.com/Gyran/PlexWWWatch
And as always, feedback and suggestions are always welcome!
does someone have a detailed instruction on how to set this up? its kind of confusing. I currently have plexwatchweb but, want to try this. i use xampp as the server to use it outside my network im not sure what else i need and how togo about setting it up.
Kudos on this. It works very well. Two things hung me up
1) The version of php had to be higher than what i had
2) Same as xtreme22886, I needed to install php5-sqlite
Once those things were resolved it looks fantastic. No more logging in to the console to run the --watching --watched.
I recon it might not be that hard to implement a watching section would it?
(pasted from plexwatch thread as desperation sets in, apologies for cross posting but this looks so good and it may well be me doing something blindingly dumb)
....paste...
I seem to be 90% of the way there now. (PMS on Centos 6)
1. Cron works and generates /opt/plexWatch/plexWatch.db
2. manual call with --stats seems to report the correct information
3. tried both plexwatchWWW and plexwatch/web but neither seem to be able to hook up to the db file,
in plexwatch/web I get the message "Failed to access plexWatch database. Please check your settings." despite having the correct path in there
Apache error logs show the following (slight variation on the same thing when each script tries to access the db file I think.)
PHP Fatal error: Call to a member function execute() on a non-object (when accessing plexwatchwww)
PHP Warning: SQLite3::query(): Unable to prepare statement: 26, file is encrypted or is not a database (when accessing plexwatchweb)
If I delete the plexWatch.db file (turning cron off) and manually start it the initial message is
Upgrading the plexWatch from 0 to 0.3.1 -- (Forcing Backup) and the db file is generated afresh however still neither seem to recognise it.
The path in the settings is correct and the persmissions have been tried at all level
Any advice would be greatly appreciated as the whole thing looks fantastic.
Good work, cant wait to solve my own issues, probably something I am doing wrong.
Regards
PsyMan
Anybody else seeing issues with posters loading? It seems to be related to 401 Unauthorised coming from the Plex server, happened a few versions ago of the PMS.
Anybody else seeing issues with posters loading? It seems to be related to 401 Unauthorised coming from the Plex server, happened a few versions ago of the PMS.
Do you have Plex Home enabled? That is most likely your problem.
