Topic: Problems getting WP-UserOnline working. Please help!! (Read 14626 times)

Rhinofart · « **on:** 15 March 2007, 00:18 »

Hello. I downloaded the latest version of the plug in, and I am trying to install it on Wordpress 2.1.1 but I keep getting this error:
WordPress database error: [Table 'wordpress.wp_useronline' doesn't exist]
DELETE FROM WP_useronline WHERE userid = '2' OR (timestamp < 1173888665)

WordPress database error: [Table 'wordpress.wp_useronline' doesn't exist]
INSERT INTO wp_useronline VALUES ('1173888965', '2', 'Rhinofart', 'Rhinofart', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; WOW64; .NET CLR 2.0.50727; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 3.0.04506.30)', '64.180.155.151', 'CompuCorGP', '%2Fwordpress%2Fwp-admin%2Fplugins.php%3Factivate%3Dtrue', 'member')

WordPress database error: [Table 'wordpress.wp_useronline' doesn't exist]
SELECT COUNT(*) FROM wp_useronline

My site url is www.compucorgp.com

Can you please point me in the right direction? I am heading home for the day but please send me an email ggalon@compucorgp.com as I can check my webmail periodicaly to see if anyone has responded to me.

Thanks again.

Ttech · « **Reply #1 on:** 15 March 2007, 00:19 »

What version of MySQL?

GaMerZ · « **Reply #2 on:** 15 March 2007, 00:35 »

make sure you have upgrade-functions.php in your wp-admin folder

Ttech · « **Reply #3 on:** 15 March 2007, 00:36 »

how do I keep forgetting that?

Rhinofart · « **Reply #4 on:** 16 March 2007, 23:23 »

5.0.27-community-nt is my Version of MySQL. The whole install was initially done with the Xampp package as I have virtually no experience with MySQL, PHP and such. I have updated the other file in the WP-Admin folder as well.

Rhinofart · « **Reply #5 on:** 16 March 2007, 23:31 »

I have been playing arround with it a bit today trying to get it to work, but now I am getting this error:
WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp_useronline ( timestamp int(15) NOT NULL default '0', userid int(10) NOT NULL default '0', username varchar(50) NOT NULL default '', displayname varchar(255) NOT NULL default '', useragent varchar(255) NOT NULL default '', ip varchar(40) NOT NULL default '', location varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', type enum('member','guest','bot') NOT NULL default 'guest', UNIQUE KEY useronline_id (timestamp,username,ip,useragent)) ENGINE=MyISAM;

Warning: Cannot modify header information - headers already sent by (output started at D:\webhost\xampp\htdocs\wordpress\wp-includes\wp-db.php:121) in D:\webhost\xampp\htdocs\wordpress\wp-includes\pluggable.php on line 275

Ttech · « **Reply #6 on:** 16 March 2007, 23:46 »

do you have the upgrade-functions.php?

GaMerZ · « **Reply #7 on:** 17 March 2007, 07:57 »

Try running this query:

Code: [Select]

CREATE TABLE `wp_useronline` (
  `timestamp` int(15) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `displayname` varchar(255) NOT NULL default '',
  `useragent` varchar(255) NOT NULL default '',
  `ip` varchar(40) NOT NULL default '',
  `location` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `type` enum('member','guest','bot') NOT NULL default 'guest',
  UNIQUE KEY `useronline_id` (`timestamp`,`username`,`ip`,`useragent`)
)

Sabo · « **Reply #8 on:** 18 March 2007, 17:24 »

Ok, I had the same problem as Rhinofart, but just running the query it didn´t helped me.

GaMerZ explain me step by step:

1. First activate the plugin. (it will give you the error)
2. Run the query. (refresh the page and the error will be gone)

That´s it.

Ttech · « **Reply #9 on:** 19 March 2007, 01:53 »

Hmm...

Rhinofart · « **Reply #10 on:** 19 March 2007, 15:21 »

I ran the querry that you gave and this is the output I got:

Error
SQL query:

CREATE TABLE `wp_useronline` (

`timestamp` int( 15 ) NOT NULL default '0',
`userid` int( 10 ) NOT NULL default '0',
`username` varchar( 20 ) NOT NULL default '',
`displayname` varchar( 255 ) NOT NULL default '',
`useragent` varchar( 255 ) NOT NULL default '',
`ip` varchar( 40 ) NOT NULL default '',
`location` varchar( 255 ) NOT NULL default '',
`url` varchar( 255 ) NOT NULL default '',
`type` enum( 'member', 'guest', 'bot' ) NOT NULL default 'guest',
UNIQUE KEY `useronline_id` ( `timestamp` , `username` , `ip` , `useragent` )
)

MySQL said:

#1050 - Table 'wp_useronline' already exists

I have upgraded the php files you stated earlier. I will try what Sabo listed and post back the results then

Rhinofart · « **Reply #11 on:** 19 March 2007, 15:24 »

Error
SQL query:

ErrorSQL query : CREATE TABLE `wp_useronline` (

`timestamp` int( 15 ) NOT NULL default '0',
`userid` int( 10 ) NOT NULL default '0',
`username` varchar( 20 ) NOT NULL default '',
`displayname` varchar( 255 ) NOT NULL default '',
`useragent` varchar( 255 ) NOT NULL default '',
`ip` varchar( 40 ) NOT NULL default '',
`location` varchar( 255 ) NOT NULL default '',
`url` varchar( 255 ) NOT NULL default '',
`type` enum( 'member', 'guest', 'bot' ) NOT NULL default 'guest',
UNIQUE KEY `useronline_id` ( `timestamp` , `username` , `ip` , `useragent` )
)MySQL said :

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 'Error
SQL query:

CREATE TABLE `wp_useronline` (

`timestamp` int( 15 ) NO' at line 1

That is the error I get now. I activated the plugin. Closed the browser down, opened it up again and the same error as before. Went into MyPHPAdmin and entered the query and above is the error I got then. I may be just dumb, but could you please let me know step by step how to configure your plugin? IE Should I update the php files (can you also list the files that need updating) Very much appreciated for all your help.

Rhinofart · « **Reply #12 on:** 19 March 2007, 15:44 »

IT'S WORKING!!!!
I ran this script from one of the other messages here in the forums:
CREATE TABLE `wp_useronline` (
`timestamp` int(15) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`displayname` varchar(255) NOT NULL default '',
`useragent` varchar(255) NOT NULL default '',
`ip` varchar(40) NOT NULL default '',
`location` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`type` enum('member','guest','bot') NOT NULL default 'guest',
UNIQUE KEY `useronline_id` (`timestamp`,`username`,`ip`,`useragent`)
);

and everything appears to be working perfectly. Thank you all for your help. Next to tackle countries online, and your info. I saw them somewhere in the forums. Man! This sure is the best way to learn something new isn't it!! Again thank you all, and once I get smart enough with all of this I'll be lending a hand as well as I can. Anyone have any ISA problems? Just let me know

GaMerZ · « **Reply #13 on:** 19 March 2007, 17:04 »

lol thank you for your contributions, can i know what is ISA?

Rhinofart · « **Reply #14 on:** 19 March 2007, 17:17 »

Stands for Internet Security and Acceleration Server. I do have one quick question though. I'm not sure it's 100% working now. I have the users online counter show up, but when I click on it it takes me to a page that says can not be found. I did create a page under wordpress called useronline but is there anything else I need to do? Is the plugin supposed to show you stat information about users when you click on it?

GaMerZ · « **Reply #15 on:** 19 March 2007, 17:26 »

did u add [page_useronline] to the page content?

Rhinofart · « **Reply #16 on:** 20 March 2007, 20:03 »

Yes. I got it all working. Thanks again for all your help, and inspirations for stuff to add to my site to make it a little more appealing to the mass public. LOL Keep up the fantastic work guys!

GaMerZ · « **Reply #17 on:** 21 March 2007, 00:14 »

thanks for the compliments =D

Ttech · « **Reply #18 on:** 21 March 2007, 22:12 »

Glad it works...

atrais · « **Reply #19 on:** 14 April 2007, 08:51 »

Quote from: GaMerZ on 19 March 2007, 17:04

lol thank you for your contributions, can i know what is ISA?

I had also problems with too large index so I tried that paste of sql, and it worked.

I think its when mysql is setup with UTF-8. Oh well.

I just wanted to say that I have a lot of fun setting up your plugins, they are great work of programming and the support here is fantastic.

When I added my Online-page in wordpress, Google-bot came instantly and checked out the page, it was so funny.

Thank you!
Øyvind (http://hoysater.net/oyvind/)

News:

Author Topic: Problems getting WP-UserOnline working. Please help!! (Read 14626 times)