حل خطأ MySQL Error : Table 'xxx_vb.pmreceipt' doesnt exist

Abdul Rahim

[ أعضاء فى القلب ]
30 مايو 2011
3,386
23
0
بسم الله الرحمن الرحيم

الخطأ:
كود:
MySQL Error : Table 'xxx_vb.pmreceipt' doesnt exist
Error Number : 1146

الحل:
كود:
CREATE TABLE `pmreceipt` ( 
  `pmid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `touserid` int(10) unsigned NOT NULL default '0', 
  `tousername` varchar(100) NOT NULL default '', 
  `title` varchar(250) NOT NULL default '', 
  `sendtime` int(10) unsigned NOT NULL default '0', 
  `readtime` int(10) unsigned NOT NULL default '0', 
  `denied` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`pmid`), 
  KEY `userid` (`userid`), 
  KEY `touserid` (`touserid`) 
) TYPE=MyISAM;