Bug Database Error in Admincp on Searching Treadrating Members

[chatty]

Hi there,

easy to reproduce the bug :

click on Thread Rating Management and type a Username to search for.

Yo got this error :

Database error in vBulletin 4.2.2:

Invalid SQL:

            SELECT 
                userid 
            FROM vb_users 
            WHERE 
                username = 'BoneHead1211';

MySQL Error   : Table '*.vb_users' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, May 6th 2014 @ 08:10:36 AM
Error Date    : Tuesday, May 6th 2014 @ 08:10:37 AM
Script        : http://***/admincp/trating.php?do=tratings
Referrer      : http://***/admincp/trating.php?do=tratings
IP Address    : *.*.*.*
Username      : BoneHead1211
Classname     : vB_Database
MySQL Version : 5.5.35-0 *-*

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 459
#2 vB_Database->query_read() called in [path]/dbtech/thread_ratings/actions/admin/tratings.php on line 149
#3 include_once([path]/dbtech/thread_ratings/actions/admin/tratings.php) called in [path]/admincp/trating.php on line 67

The Tablename is vb_user not vb_users

Fix :
open up /dbtech/thread_ratings/actions/admin/tratings.php
Find Line 146 and change from

FROM " . TABLE_PREFIX . "users

to

FROM " . TABLE_PREFIX . "user

And all works fine

 

[Fillip H.]

Fixed, thank you

 

[chatty]

@ your Service Sir