الخطأ
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 ;