How can I fix the following error?
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT c.conversationid AS conversationid, c.username AS fromusername, c.title AS title, 1 AS isconversation, c.last_message_dateline AS sortdateline
FROM bmf_conversations_participant p
INNER JOIN bmf_conversations_conversation c ON (c.conversationid = p.conversationid)
INNER JOIN bmf_conversations_message m ON (m.messageid = c.last_message_id)
WHERE
p.userid = 3
AND c.last_message_userid != 3
AND c.last_message_dateline > p.dateline_lastread
AND p.dateline_deleted < m.dateline
ORDER BY c.last_message_dateline DESC
LIMIT 1;
MySQL Error : Table 'vbmulti.bmf_conversations_participant' doesn't exist
Error Number : 1146
|