Topic: Problems with WordPress 2.6.1

[pep]

I just upload to the new version of Wordpress 2.6.1 and the usersonline plugin doesn't work. I don't get any error, just I get 0 users connected all the time.

Any idea about that?

Thanks!

[GaMerZ]

Try the default theme with no other plugins activated

[pep]

It doesn't works  I also tried to uninstall and install again the plugin but I get the same... 0 users connected all the time (in the public page and admin area too).

[GaMerZ]

Can u check if the table wp_useronline is created?

[pep]

Is not created. There is one called wp_users, but not wp_useronline

[GaMerZ]

That explains why. I think you are still using MYSQL 4.0 which is quite oudated.

Run this query in phpmyadmin:

Code: [Select]

CREATE TABLE IF NOT EXISTS `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',
  `referral` varchar(255) NOT NULL default '',
  UNIQUE KEY `useronline_id` (`timestamp`,`username`,`ip`,`useragent`)


[pep]

Yes, version 4.1.22

When I do a Query with your code in the phpmyadmin I get this error: You have to choose at least one column to display

[GaMerZ]

Try this:

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',
  `referral` varchar(255) NOT NULL default '',
  UNIQUE KEY `useronline_id` (`timestamp`,`username`,`ip`,`useragent`)

[pep]

My host company just update the mySQL to version 5 but I still get 0 users online all the time, and the table wp_useronline is never created.

Any suggestion? 

[GaMerZ]

Deactivate and activate the plugin again. If it still does not work, run the query i pasted above.

[pep]

I did it and I get this error in the new server with MySQL 5.0.41

Code: [Select]

SQL query:

CREATE TABLE IF NOT EXISTS `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',
`referral` varchar( 255 ) NOT NULL default '',
UNIQUE KEY `useronline_id` ( `timestamp` , `username` , `ip` , `useragent` )

MySQL said: Documentation
#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 '' at line 12


[GaMerZ]

Your host upgraded to MYSQL 5, but is your host running on it?

Try this query:

Code: [Select]

-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 27, 2008 at 01:35 PM
-- Server version: 5.0.37
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `gamerz_wordpress`
--

-- --------------------------------------------------------

--
-- Table structure for table `wp_useronline`
--

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',
  `referral` varchar(255) NOT NULL default '',
  UNIQUE KEY `useronline_id` (`timestamp`,`username`,`ip`,`useragent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[pep]

Now it works. Thanks buddy, you're the man! 

[Keogh]

Hi, I'm new to this excellent forum! And i have been using the WP-UserOnline plugin since start! But now I'm suffering the same problem, it shows 0 Users Online, and i run this script in MySQL:
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',
  `referral` varchar(255) NOT NULL default '',
  UNIQUE KEY `useronline_id` (`timestamp`,`username`,`ip`,`useragent`)

And it created the DB correctly no error messages, but still it wont work on my blog, i gave it @ www.nelson.to/weblog Please help me!

Thanks again for a nice plugin and a nice forum.

/Keogh.

[GaMerZ]

Your wp-useronline is like ages ago. Upgrade it and READ THE readme.html

[Keogh]

Ok I'll do that! Thanks for a blazing fast reply!

[Keogh]

Hehe... I'm HAPPY!  To you! And thanks works like it suppose to!