user points module problem
kims - May 23, 2007 - 15:58
Hi
I got at problem with the newest userpoint module, i keep getting this error:
user warning: Unknown column 'max_points' in 'field list' query: UPDATE userpoints SET points = 0, max_points = 0, last_update = 1179935563 WHERE uid = 1 in /var/www/virtual/bistandsbums.dk/test/htdocs/includes/database.mysql.inc on line 172.
I'v tried everything to get i to work, but i'm out of good ideaers, so i hope someone in here know what to do.
Kim
Missing a field in the table
It's missing a field in the table. Either something didn't install right or you have upgraded the module without running update.php. If the first, try re-installing. If the second, run it. :)
Michelle
--------------------------------------
My site: http://shellmultimedia.com
hehe i tried both several
hehe i tried both several times, before i made this post ;)
Kim
Do it manually...
Well, I have no clue why the install is failing for you, but here's the SQL to do it manually. Make sure you drop the table first.
CREATE TABLE `userpoints` (
`uid` int(10) NOT NULL default '0',
`points` int(10) NOT NULL default '0',
`max_points` int(10) NOT NULL default '0',
`last_update` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
Michelle
--------------------------------------
My site: http://shellmultimedia.com
that fixed it Michelle,
that fixed it Michelle, thanks for your help.
im