[Sparkz]

Originally Posted by twitch

If I try to delete one of the "statuses" in the admin panel, I get the following database error

Database error in vBulletin 3.5.0:

Invalid SQL:

	SELECT *
	FROM vbug_status
	WHERE vbug_statusid = 12;

MySQL Error  : Table 'clanvdqa_slave.vbug_status' doesn't exist
Error Number : 1146
Date         : Thursday, October 6th 2005 @ 01:18:48 PM
Script       : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=removestatus&vbug_statusid=12
Referrer     : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=modifystatus
IP Address   : 206.174.3.123
Username     : |s2tg|twitch
Classname    : vb_database

The fix here is to find

PHP Code:

    $status = $db->query_first("
    SELECT *
    FROM vbug_status
    WHERE vbug_statusid = " . $vbulletin->GPC['vbug_statusid'] . "
    "); 


and change that to

PHP Code:

    $status = $db->query_first("
    SELECT *
    FROM " . TABLE_PREFIX . "vbug_status
    WHERE vbug_statusid = " . $vbulletin->GPC['vbug_statusid'] . "
    "); 


The code in question is around line 711 in admincp/vbugs_admin.php