whos online

[hayskswx]

What is the easiest way to install the who's online script?

[Bunty]

I gather it's complex to install?   I've never tried myself.

[hayskswx]

True. It's over my head

[saratogaWX]

Mike's Who's Online script is more difficult to install only because it uses a SQL database for it's storage .. none of the other scripts for personal weather websites use SQL services, so can be installed with only PHP code to worry about.

Setting up a SQL database is somewhat complicated, and varies depending on your webhoster.  I'd suggest that you not try it until you've checked out what your hoster offers for SQL database useage and whether they allow something that has a semi-realtime aspect (high traffic websites might exceed the terms/conditions of SQL database usage for minimal hosting arrangements).

[Moose Whisperer]

Yep,

I actually got as far as creating a SQL database on my web hosting server following the installation instructions. But as soon as I hit this step:

Step 1)
Create a mysql database on your web server.
Because many web hosts use different types of control panels, there are different ways.
Usually your web host will have a FAQ or help guide to show you how to add a database.
After you add your database, create the tables with whos-online.sql.txt
If you use phpMyAdmin you can select your new database,
then paste the contents of whos-online.sql.txt into the SQL statement entry form.
The whos-online.sql.txt file is located in the readme-files folder.

...I hit an all-stop. I have absolutely no idea how to do this. I found the whos-online.sql.txt form he is referring to, but there doesn't seem to be any corresponding place for it in the phpMyAdmin thingy. I have a feeling this is one of those steps that would be a no brainer to a database geek. But for a mere mortal like myself, it might as well be written in Chinese!

[capeweather]

If you have phpmyadmin, you select your database, go to the import tool and browse for whos-online.sql.txt on your pc. Hit the Go button and it will create the tables for you inside the database you created.

[Moose Whisperer]

Wow, that actually worked! Thanks!

I was getting confused, my first read of the instructions looked like the phpMyAdmin was saying it required a zip file, not that it was optional.

However, that only got me a little ways. Now I get error messages about not being able to connect with the database. It looks like the password is wrong, but I have double checked the user name and password many times, even used the password generator and cut and pasted and still no luck. The only thing I can think is maybe I am using the wrong syntax somewhere in the include-whos-online-settings.php file. For example, is the localhost field the full URL to my website? My database tacks on some extra stuff to the user names I create (xxx_username), do I include that too? Is there more than one place in the file that the username and password needs to be entered?

I've tried all possible combinations with no luck. I've just gone back to disabling the whole script to get my webpage to load.

[Moose Whisperer]

OK, I got it working. So apparently you enter the user_name, db_name, and password, but you leave localhost as localhost.

Yeah, I knew that!    

http://www.ak-image.com/weather/dwWho.php

[sacreyweather]

Hi Folks,

Been attempting to install this script again, but keep running into an error with the MySQL import.  I receive the following error:

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 23

My host has this version of MySQL: 5.5.27.  I have no clue as to what to change or how to make this work.

Any assistance is appreciated,

John

[sacreyweather]

I got it figured out.  There have been some major changes in the way the DB engine is called.  Changed a couple of lines and off it goes.

John

For those who may run into this.  Look for:

TYPE=MyISAM

change to:

ENGINE=MyISAM