MySQL Error : Table 'xxx_vb.adminmessage' doesnt exist

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

رمز الخطأ

MySQL Error : Table 'xxx_vb.adminmessage' doesnt exist

الحل

DROP TABLE IF EXISTS adminmessage;
CREATE TABLE `adminmessage` (
`adminmessageid` int(10) unsigned NOT NULL auto_increment,
`varname` varchar(250) NOT NULL default '',
`dismissable` smallint(5) unsigned NOT NULL default '0',
`script` varchar(50) NOT NULL default '',
`action` varchar(20) NOT NULL default '',
`execurl` mediumtext NOT NULL,
`method` enum('get','post') NOT NULL default 'post',
`dateline` int(10) unsigned NOT NULL default '0',
`status` enum('undone','done','dismissed') NOT NULL default 'undone',
`statususerid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`adminmessageid`),
KEY `script_action` (`script`,`action`),
KEY `varname` (`varname`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

ثم قم بزراعة هذا الامر في قاعدة البيانات
ALTER TABLE `user` ADD `warnings` INT(10) UNSIGNED DEFAULT '0' NOT NULL;