Lester Chan's Forums
21 November 2008, 23:10 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Become a fan of Lester Chan's WordPress Plugins in Facebook.
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: WordPress database error  (Read 6858 times)
0 Members and 1 Guest are viewing this topic.
Åse
Guest
« Topic Start: 01 January 2007, 12:21 »

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/
Logged
GaMerZ
lesterchan.net
Administrator
*****
Offline Offline

Posts: 7,923



View Profile WWW
« Reply #1: 01 January 2007, 16:49 »

Deactivate wp-useronline and try activate it again
Logged


++ lesterchan.net - Lester Chan's Website

I DO NOT provide support for any modifications of any plugin to meet your needs/requirements, unless it is a paid job and I have the time to do it due to the large number of request.
Ttech
Official Support
Administrator
*****
Offline Offline

Posts: 4,294



View Profile WWW
« Reply #2: 01 January 2007, 21:19 »

What's your MySQL version? Smiley
Logged

Learning and Helping one day at a time.




DevNode.org Operator - The IRC network for Programers
Åse
Guest
« Reply #3: 02 January 2007, 08:39 »

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
Logged
Åse
Guest
« Reply #4: 02 January 2007, 08:39 »

What's your MySQL version? Smiley
4.0.27-standard 

Thanks!
Logged
GaMerZ
lesterchan.net
Administrator
*****
Offline Offline

Posts: 7,923



View Profile WWW
« Reply #5: 02 January 2007, 09:59 »

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:
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`)
);
Logged


++ lesterchan.net - Lester Chan's Website

I DO NOT provide support for any modifications of any plugin to meet your needs/requirements, unless it is a paid job and I have the time to do it due to the large number of request.
Åse
Guest
« Reply #6: 02 January 2007, 10:52 »

That did it! Thank you!
Logged
GaMerZ
lesterchan.net
Administrator
*****
Offline Offline

Posts: 7,923



View Profile WWW
« Reply #7: 02 January 2007, 15:50 »

no problem
Logged


++ lesterchan.net - Lester Chan's Website

I DO NOT provide support for any modifications of any plugin to meet your needs/requirements, unless it is a paid job and I have the time to do it due to the large number of request.
Ttech
Official Support
Administrator
*****
Offline Offline

Posts: 4,294



View Profile WWW
« Reply #8: 02 January 2007, 17:37 »

Glad it works.. Smiley
Logged

Learning and Helping one day at a time.




DevNode.org Operator - The IRC network for Programers
antgoto
Guest
« Reply #9: 22 January 2007, 16:36 »

i have same problem with 2.05 or 2.06
mysql version:5.0.22
try to run
Code:
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]
Logged
GaMerZ
lesterchan.net
Administrator
*****
Offline Offline

Posts: 7,923



View Profile WWW
« Reply #10: 22 January 2007, 19:02 »

Try This:
Code:
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`)
);
Logged


++ lesterchan.net - Lester Chan's Website

I DO NOT provide support for any modifications of any plugin to meet your needs/requirements, unless it is a paid job and I have the time to do it due to the large number of request.
antgoto
Guest
« Reply #11: 23 January 2007, 11:53 »

it's work thinks~ Cheesy
Logged
GaMerZ
lesterchan.net
Administrator
*****
Offline Offline

Posts: 7,923



View Profile WWW
« Reply #12: 23 January 2007, 12:54 »

yea if u can create it, it will work
Logged


++ lesterchan.net - Lester Chan's Website

I DO NOT provide support for any modifications of any plugin to meet your needs/requirements, unless it is a paid job and I have the time to do it due to the large number of request.
Ttech
Official Support
Administrator
*****
Offline Offline

Posts: 4,294



View Profile WWW
« Reply #13: 23 January 2007, 23:46 »

What?
Logged

Learning and Helping one day at a time.




DevNode.org Operator - The IRC network for Programers
RoarinRow
Newbie
*
Offline Offline

Posts: 9


View Profile
« Reply #14: 18 June 2007, 22:31 »

Got it to work thanks.  I just had to insert a 'referral' row in the user's online table and walla!  Thanks!
Logged
Ttech
Official Support
Administrator
*****
Offline Offline

Posts: 4,294



View Profile WWW
« Reply #15: 30 June 2007, 19:10 »

Glad it works... Smiley
Logged

Learning and Helping one day at a time.




DevNode.org Operator - The IRC network for Programers
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.06 seconds with 24 queries.