السلام عليكم , بصراحة واجهة مشكلة مع احد الأخوان لكن ما ادري وش به! استرجعت الجدول لكن ما نفع اببببببببد..
كود PHP:
Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT COUNT(*)
FROM tag AS tag
JOIN tagcontent AS tagcontent ON (tag.tagid = tagcontent.tagid)
WHERE tagcontent.contenttypeid = 2
AND tagcontent.contentid = 89;
MySQL Error : Table 'mmecom_forums.tagcontent' doesn't exist
Error Number : 1146
Request Date : Monday, June 28th 2010 @ 12:45:20 PM
Error Date : Monday, June 28th 2010 @ 12:45:20 PM
Script : http://forums.mme.com/newthread.php?do=postthread&f=50
Referrer : http://forums.mme.com/newthread.php?do=newthread&f=50
IP Address : 1x8.xx8.xx4.xx8
Username : Alsajee
Classname : vB_Database
MySQL Version : 5.0.90-community
كود PHP:
CREATE TABLE `tagcontent` (
`tagid` int(10) unsigned NOT NULL default '0',
`contenttypeid` int(10) unsigned NOT NULL,
`contentid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`,`contenttypeid`,`contentid`),
KEY `id_type_user` (`contentid`,`contenttypeid`,`userid`),
KEY `user` (`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;