Database error: 1146(Table 'today_vb.attachment' doesn't exist)

[torrentrockerz]

Database error in vBulletin 3.7.5:

Invalid SQL:

SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;

MySQL Error : Table 'today_vb.attachment' doesn't exist
Error Number : 1146

iam getting this error when i tried to open an thread with attachment, else all other threads without attachment are opening..

how to resolve this

Iam using Vb 3.7.5 version

[Marco van Herwaarden]

Can you check with a tool like phpMyAdmin if the table really does not exist. If so, was there anything done to your database that can cause this table to be deleted? Are there any more tables missing?

[torrentrockerz]

no. only the following table was missing...

[Marco van Herwaarden]

Then you have 2 options:

- Restore a backup from before the table was deleted.
- Recreate the table (empty):
[sql]CREATE TABLE `attachment` (
`attachmentid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`thumbnail_dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`filedata` mediumblob,
`visible` smallint(5) unsigned NOT NULL default '0',
`counter` int(10) unsigned NOT NULL default '0',
`filesize` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`filehash` char(32) NOT NULL default '',
`posthash` char(32) NOT NULL default '',
`thumbnail` mediumblob,
`thumbnail_filesize` int(10) unsigned NOT NULL default '0',
`extension` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
PRIMARY KEY (`attachmentid`),
KEY `filesize` (`filesize`),
KEY `filehash` (`filehash`),
KEY `userid` (`userid`),
KEY `posthash` (`posthash`,`userid`),
KEY `postid` (`postid`),
KEY `visible` (`visible`)
)[/sql]