Topic: WordPress database error

[Åse]

Hello!

I'm trying to install the 2.05 version of WP-UserOnline (have the 2.04) but get errors:

WordPress database error: [Unknown column 'userid' in 'where clause']
DELETE FROM wp_useronline WHERE userid = '1' OR (timestamp < 1167659745)

WordPress database error: [Column count doesn't match value count at row 1]
INSERT INTO wp_useronline VALUES ('1167660045', '1', 'admin', 'Åse', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; sv-SE; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1', '83.249.xxx.xx', 'V i k t i g . o r g', '%2Fwp-admin%2Fplugins.php', 'member')


  I use WP 2.0.5, have a modified mx4 theme.

Any help is appreciated!
Thank You
http://www.viktig.org/

[GaMerZ]

Deactivate wp-useronline and try activate it again

[Ttech]

What's your MySQL version?

[Åse]

Deactivate wp-useronline and try activate it again

Done so hundreed of times. Version 2.04 works like a charm but not 2.05 or now 2.06

[Åse]

What's your MySQL version?

4.0.27-standard 

Thanks!

[GaMerZ]

Try This.
1. Activate the plugin (ignore the error)
2. Go to phpmyadmin, drop the wp_useronline table.
3. Run this query in phpmyadmin

Code: [Select]

CREATE TABLE `wp_useronline` (
  `timestamp` int(15) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `username` varchar(150) 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`)
);

[Åse]

That did it! Thank you!

[GaMerZ]

no problem

[Ttech]

Glad it works..

[antgoto]

i have same problem with 2.05 or 2.06
mysql version:5.0.22
try to run

Code: [Select]

CREATE TABLE `wp_useronline` (
  `timestamp` int(15) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `username` varchar(150) 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`)
);
then show err msg as attach file


[attachment deleted by admin]

[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',
  UNIQUE KEY `useronline_id` (`timestamp`,`username`,`ip`,`useragent`)
);

[antgoto]

it's work thinks~

[GaMerZ]

yea if u can create it, it will work

[Ttech]

What?

[RoarinRow]

Got it to work thanks.  I just had to insert a 'referral' row in the user's online table and walla!  Thanks!

[Ttech]

Glad it works...