Author Topic: Installing whosonline (Read 1976 times)

Jumpin Joe · « **on:** February 08, 2016, 04:16:42 PM »

I trying to setup "whos-online" on my site and need to know what I need to add or change to my "Settings.php" script.

Any assistance will be greatly appreciated.

Joe

Jumpin Joe · « **Reply #1 on:** February 08, 2016, 05:14:44 PM »

This is what I have entered

$C['files_path'] = 'home/www/whos-online/'; //full path, always end with a slash
$C['files_url'] = 'http://joesweather.info/whosonline/';//url, always end witha slash

require ($C['files_path'] .'include-whos-online-header.php');
$whos_online_records = update_whos_online();

saratogaWX · « **Reply #2 on:** February 09, 2016, 01:20:46 PM »

Based on running check-fetch-times.php?show=info to find the document root, I'd change the settings to

Code: [Select]

$C['files_path'] = '/home/www/www/whos-online/'; //full path, always end with a slash
$C['files_url'] = 'http://joesweather.info/whos-online/'; //url, always end with a slash

and give that a try.

Jumpin Joe · « **Reply #3 on:** February 09, 2016, 01:52:51 PM »

Ken,

I getting fatal errors with that, as I was before.

Warning: require(home/www/www/whos-online/include-whos-online-header.php): failed to open stream: No such file or directory in /home/joes/www/www/Settings.php on line 163

Warning: require(home/www/www/whos-online/include-whos-online-header.php): failed to open stream: No such file or directory in /home/joes/www/www/Settings.php on line 163

Fatal error: require(): Failed opening required 'home/www/www/whos-online/include-whos-online-header.php' (include_path='.:/usr/local/php55/lib/php') in /home/joes/www/www/Settings.php on line 163

Joe

saratogaWX · « **Reply #4 on:** February 09, 2016, 02:14:03 PM »

You have to put a starting / in front of the file path to indicate it is an absolute path.

$C['files_path'] = '/home/www/www/whos-online/'; //full path, always end with a slash

Jumpin Joe · « **Reply #5 on:** February 09, 2016, 03:37:41 PM »

Still getting the same error

Warning: require(/home/www/www/whos-online/include-whos-online-header.php): failed to open stream: No such file or directory in /home/joes/www/www/Settings.php on line 163

Warning: require(/home/www/www/whos-online/include-whos-online-header.php): failed to open stream: No such file or directory in /home/joes/www/www/Settings.php on line 163

Fatal error: require(): Failed opening required '/home/www/www/whos-online/include-whos-online-header.php' (include_path='.:/usr/local/php55/lib/php') in /home/joes/www/www/Settings.php on line 163

at the start of the Warning: require(/home/www/www/ I do not use/see /home/www/www/ the root to my site is /www/www/ could that be the issue?

Joe

saratogaWX · « **Reply #6 on:** February 09, 2016, 03:53:06 PM »

The clue is in the error messages

Quote

Failed opening required '/home/www/www/whos-online/include-whos-online-header.php' (include_path='.:/usr/local/php55/lib/php') in /home/joes/www/www/Settings.php

So the path needs to be

$C['files_path'] = '/home/joes/www/www/whos-online/'; //full path, always end with a slash

Odd that the document root shows as /home/www/www/ but the PHP message shows it as /home/joes/www/www/

Oh well, each instance can be uniquely configured on the server...

Jumpin Joe · « **Reply #7 on:** February 09, 2016, 04:04:42 PM »

Quote from: saratogaWX on February 09, 2016, 03:53:06 PM

The clue is in the error messages

Quote
Failed opening required '/home/www/www/whos-online/include-whos-online-header.php' (include_path='.:/usr/local/php55/lib/php') in /home/joes/www/www/Settings.php

So the path needs to be

$C['files_path'] = '/home/joes/www/www/whos-online/'; //full path, always end with a slash

Odd that the document root shows as /home/www/www/ but the PHP message shows it as /home/joes/www/www/

Oh well, each instance can be uniquely configured on the server...

That was the answer Ken... No more fatal errors. Now onto making it work.

Thank you!!

Joe

CNYWeather · « **Reply #8 on:** February 09, 2016, 04:14:35 PM »

You've got a mysql error popping up for a second on your site Joe:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/joes/www/www/whos-online/include-whos-online-header.php on line 120

Jumpin Joe · « **Reply #9 on:** February 09, 2016, 04:20:22 PM »

Quote from: CNYWeather on February 09, 2016, 04:14:35 PM

You've got a mysql error popping up for a second on your site Joe:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/joes/www/www/whos-online/include-whos-online-header.php on line 120

Oh boy!!

I have no clue whatsoever as to what that means and what I need to do. I did see a comment in the instructions to install whos-online that it can be difficult to set it up. He wasn't kidding.

Joe

saratogaWX · « **Reply #10 on:** February 09, 2016, 04:29:23 PM »

Now you need to update the scripts from here for the deprecated errata with PHP 5.6, then all should be good.

Ian. · « **Reply #11 on:** February 09, 2016, 04:32:20 PM »

Hi Joe,

I ended up disabling Who's Online script as when I did an wo-update it brought the site down

Had a go at rebuilding the database etc....in the end gave up and downloaded supercounter instead, not really what I wanted to do, but at the end of the day I have my sanity to think about

CNYWeather · « **Reply #12 on:** February 09, 2016, 04:41:55 PM »

Quote from: Jumpin Joe on February 09, 2016, 04:20:22 PM

Quote from: CNYWeather on February 09, 2016, 04:14:35 PM
You've got a mysql error popping up for a second on your site Joe:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/joes/www/www/whos-online/include-whos-online-header.php on line 120

Oh boy!!

I have no clue whatsoever as to what that means and what I need to do. I did see a comment in the instructions to install whos-online that it can be difficult to set it up. He wasn't kidding.

Joe

Well I have no clue either. I was kinda posting it so Ken could see it

Jumpin Joe · « **Reply #13 on:** February 09, 2016, 04:56:37 PM »

Quote from: CNYWeather on February 09, 2016, 04:41:55 PM

Quote from: Jumpin Joe on February 09, 2016, 04:20:22 PM
Quote from: CNYWeather on February 09, 2016, 04:14:35 PM
You've got a mysql error popping up for a second on your site Joe:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/joes/www/www/whos-online/include-whos-online-header.php on line 120

Oh boy!!

I have no clue whatsoever as to what that means and what I need to do. I did see a comment in the instructions to install whos-online that it can be difficult to set it up. He wasn't kidding.

Joe

Well I have no clue either. I was kinda posting it so Ken could see it

Thank you Tony.... it worked.... Ken set me straight again.

You make a real good straight man!!

Joe

Jumpin Joe · « **Reply #14 on:** February 09, 2016, 04:58:56 PM »

Quote from: Ian. on February 09, 2016, 04:32:20 PM

Hi Joe,

I ended up disabling Who's Online script as when I did an wo-update it brought the site down

Had a go at rebuilding the database etc....in the end gave up and downloaded supercounter instead, not really what I wanted to do, but at the end of the day I have my sanity to think about

I hear you Ian ... However, we have some really good people on this forum that are always willing to help.

Joe

Jumpin Joe · « **Reply #15 on:** February 09, 2016, 05:26:27 PM »

Making progress.... fixed a bunch of 404's missing files.

Looks like it's working okay... except I have background color problems and no maps show.

Joe

Jumpin Joe · « **Reply #16 on:** March 03, 2016, 11:06:30 AM »

I am getting closer in making this work, I think!

I am getting this error

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/joes/www/www/include-whos-online-header.php on line 120
Invalid query: Table 'joes_030216.whos_online' doesn't exist142/home/joes/www/www/include-whos-online-header.php

I have download and installed the four files that were updated 9-24-15. Still the same issue.

Any thoughts?

Joe

www.joesweather.info

saratogaWX · « **Reply #17 on:** March 03, 2016, 11:49:41 AM »

That message

Quote

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/joes/www/www/include-whos-online-header.php on line 120
Invalid query: Table 'joes_030216.whos_online' doesn't exist142/home/joes/www/www/include-whos-online-header.php

shows that the 4 updated files are not present on your site -- I'd suggest you upload them again.

Line 120 of include-whos-online-header.php should read

Code: [Select]

	$wo_dbh = ($GLOBALS["___mysqli_ston"] = mysqli_connect($C['dbhost'],  $C['dbuser'],  $C['dbpass']));

and not the older version which reads as

Code: [Select]

	$wo_dbh = mysql_connect($C['dbhost'], $C['dbuser'], $C['dbpass']);

-- it's the latter that indicates the files are not updated on your site.

Best regards,
Ken

Jumpin Joe · « **Reply #18 on:** March 03, 2016, 12:43:49 PM »

Quote from: saratogaWX on March 03, 2016, 11:49:41 AM

That message
Quote
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/joes/www/www/include-whos-online-header.php on line 120
Invalid query: Table 'joes_030216.whos_online' doesn't exist142/home/joes/www/www/include-whos-online-header.php
shows that the 4 updated files are not present on your site -- I'd suggest you upload them again.

Line 120 of include-whos-online-header.php should read
Code: [Select]
$wo_dbh = ($GLOBALS["___mysqli_ston"] = mysqli_connect($C['dbhost'], $C['dbuser'], $C['dbpass'])); and not the older version which reads as
Code: [Select]
$wo_dbh = mysql_connect($C['dbhost'], $C['dbuser'], $C['dbpass']); -- it's the latter that indicates the files are not updated on your site.

Best regards,
Ken

Ken,

Once again.... my fat fingers got me in trouble. I had uploaded them, just not to the right location.

THANK YOU!!!

Now onto the query table issue.

Joe

saratogaWX · « **Reply #19 on:** March 03, 2016, 01:13:28 PM »

You'll likely need to adjust the include-whos-online-settings.php with the updated values for the mySQL database location and credentials.

This area in the code

Code: [Select]

// mysql database settings (you must already have a mysql database)
$C['dbhost'] = 'localhost'; // host
$C['dbname'] = ''; // database name
$C['dbuser'] = ''; // database user
$C['dbpass'] = ''; // database password

Jumpin Joe · « **Reply #20 on:** March 03, 2016, 02:16:52 PM »

Quote from: saratogaWX on March 03, 2016, 01:13:28 PM

You'll likely need to adjust the include-whos-online-settings.php with the updated values for the mySQL database location and credentials.

This area in the code
Code: [Select]
// mysql database settings (you must already have a mysql database) $C['dbhost'] = 'localhost'; // host $C['dbname'] = ''; // database name $C['dbuser'] = ''; // database user $C['dbpass'] = ''; // database password

$\:D/$ Up and running!! $\:D/$

I had to make a change at the database itself.

Thanks Ken for all of your help and patience!

Joe

saratogaWX · « **Reply #21 on:** March 03, 2016, 04:28:44 PM »

You're very welcome, Joe.

Glad you're getting it all sorted out

Best regards,
Ken

News:

Author Topic: Installing whosonline (Read 1976 times)