MyBB Community Forums

In the Admin section of Moderated Posts/Threads I get the following message when trying to validate:

mySQL error: 1146
Table 'db112936466.posts' doesn't exist
Query: SELECT mybb_tid FROM posts WHERE pid='1779'

Fixable???? TY!

admin/moderation.php, find:

$query = $db->query("SELECT ".TABLE_PREFIX."tid FROM posts WHERE pid='$pid'");
			$post = $db->fetch_array($query);
			$query = $db->query("SELECT ".TABLE_PREFIX."fid FROM threads WHERE tid='$thread[tid]'");

and replace with

$query = $db->query("SELECT tid FROM ".TABLE_PREFIX."posts WHERE pid='$pid'");
			$post = $db->fetch_array($query);
			$query = $db->query("SELECT fid FROM ".TABLE_PREFIX."threads WHERE tid='$thread[tid]'");

(".TABLE_PREFIX." was in the wrong place)