[edeab220]

Anyone know why I'm getting this error?

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE user SET shouts=shouts+1 WHERE userid='3'
mysql error: Unknown column 'shouts' in 'field list'

mysql error number: 1054

I used the query Zachery gave me over at geekydesigns while installing, which was this:

CREATE TABLE shoutbox_posts (
`shoutid` BIGINT (255) UNSIGNED AUTO_INCREMENT, 
`text` TEXT, 
`userid` BIGINT (255) UNSIGNED DEFAULT '0', 
`username` VARCHAR (255) DEFAULT '0', 
`ip` VARCHAR (25) DEFAULT '0', 
`time` BIGINT (20) UNSIGNED DEFAULT '0', 
`edittime` BIGINT (20) UNSIGNED DEFAULT '0', 
`edituser` VARCHAR (255) DEFAULT '0', 
`deleted` TINYINT(1) UNSIGNED DEFAULT '0', 
PRIMARY KEY(`shoutid`))

I had to use it because my host upgraded to MySQL 4.1.1.

Can anyone figure it out? Thanks! Many of the people of my site want the shoutbox back...