حل مشكله visitormessage' doesn't exist

ENG MUHAMED

[ADMIN]
طاقم الإدارة
25 فبراير 2008
10,079
43
48
support-ar.net

الخطأ

PHP:
<!--
Database error in vBulletin 3.6.7:

Invalid SQL:

        INSERT INTO visitormessage
            (userid, postuserid, postusername, dateline, state, pagetext)
        VALUES
            ('336','1','*****','1225067238','visible',' \r\nvb@***.com\r\n****hotmail.com');

MySQL Error  : Table '***_vb.visitormessage' doesn't exist
Error Number : 1146
Date         : Monday, October 27th 2008 @ 04:27:19 AM
Script       : http://www.***.com/vb/register.php?do=addmember
Referrer     : http://www.***.com/vb/register.php?do=register
IP Address   : 41.233.30.197
Username     : تجربه
Classname    : vB_Database
الحل


ازرع الامر التالى فى قاعده البيانات


PHP:
CREATE TABLE `visitormessage` (
  `vmid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `state` enum('visible','moderation','deleted') NOT NULL default 'visible',
  `title` varchar(255) NOT NULL default '',
  `pagetext` mediumtext,
  `ipaddress` int(10) unsigned NOT NULL default '0',
  `allowsmilie` smallint(5) unsigned NOT NULL default '0',
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  `messageread` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`vmid`),
  KEY `postuserid` (`postuserid`,`userid`,`state`),
  KEY `userid` (`userid`,`dateline`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;