MySQL Error: Unknown column 'album.moderation' in 'field list'

[خ ــادم الإسلام]

رمز الخطا

HTML clipboard Database error in vBulletin 3.8.5: Invalid SQL: SELECT album.*, picture.pictureid, picture.extension, picture.idhash, album.moderation, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height FROM album AS album LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0) WHERE album.userid = 4308 AND album.state IN ('public', 'private', 'profile') AND album.visible > 0 ORDER BY album.lastpicturedate DESC LIMIT 2; MySQL Error : Unknown column 'album.moderation' in 'field list'
Error Number :1054 ,
الحل

ازرع الامر
DROP TABLE `album` ;ومن ثم الامر

CREATE TABLE `album` (
`albumid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`createdate` int(10) unsigned NOT NULL default '0',
`lastpicturedate` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '0',
`moderation` int(10) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`description` mediumtext,
`state` enum('public','private','profile') NOT NULL default 'public',
`coverpictureid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`albumid`),
KEY `userid` (`userid`,`lastpicturedate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;