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

[rockerz]

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

 

[k_hunter]

Do you have any database backup? Try importing today_vb.attachment table.

 

[rockerz]

we have the total back up, but its a single file