Forum Answered VisitorMessage Database Error
 

How do I fix this issue?

Quote:
Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT hash.userid, user.username
FROM visitormessage_hash AS hash
LEFT JOIN user AS user USING (userid)
WHERE hash.postuserid = 1 AND
hash.dupehash = 'b3ab831e355a08e91e2cf46ea550530f' AND
hash.dateline > 1358059454;

MySQL Error : Table 'gwzone_vbulletin.visitormessage_hash' doesn't exist
Error Number : 1146
Request Date : Sunday, January 13th 2013 @ 12:49:14 AM
Error Date : Sunday, January 13th 2013 @ 12:49:14 AM
Script : http://www.gamingwarzone.net/visitor...php?do=message
Referrer : http://www.gamingwarzone.net/members/generallee.html
IP Address : 99.14.178.37
Username : Maester
Classname : vB_Database
MySQL Version : 5.5.23-55


Tried dropping the VisitorMessage Table and Reinstalling with this

Quote:
CREATE TABLE visitormessage (
vmid INT UNSIGNED NOT NULL auto_increment,
userid INT UNSIGNED NOT NULL DEFAULT '0',
postuserid INT UNSIGNED NOT NULL DEFAULT '0',
postusername VARCHAR(100) NOT NULL DEFAULT '',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
state ENUM('visible','moderation','deleted') NOT NULL default 'visible',
title VARCHAR(255) NOT NULL DEFAULT '',
pagetext MEDIUMTEXT,
ipaddress INT UNSIGNED NOT NULL DEFAULT '0',
allowsmilie SMALLINT UNSIGNED NOT NULL DEFAULT '0',
reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
messageread SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (vmid),
KEY postuserid (postuserid, userid, state),
KEY userid (userid, dateline, state)
);

- - - Updated - - -

Nvm I figured it out

Quote:
"CREATE TABLE " . TABLE_PREFIX . "visitormessage_hash
(
postuserid INT UNSIGNED NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL DEFAULT '0',
dupehash VARCHAR(32) NOT NULL DEFAULT '',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
KEY postuserid (postuserid, dupehash),
KEY dateline (dateline)
)