[hotma1l]

Database error in vBulletin 3.5.5:

Invalid SQL:
SELECT userid FROM post where threadid = AND userid = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND userid = 1' at line 1
Error Number : 1064
Date : Wednesday, September 13th 2006 @ 03:42:36 PM
Script : http://www.xxxx.com/vb/admincp/misc....=30005&pp=5000
Referrer : http://www.xxxx.com/vb/admincp/
IP Address :
Username :
Classname : vB_Database

I get that when updating rebuild post cache

I found out it's from the extra tools product. It works fine but when i enable the hid hack to show it in the toolbar i get the error while rebuilding the post cache.

here is the part in the hack file where i think the problem is from

PHP Code:

// [hide] 
           if ($vbulletin->options['allowedhide']) 
           { 
                function handle_hide(&$parser, $param, $option) 
                { 
                     global $vbulletin; 

                     $posted = $vbulletin->db->query_first("SELECT userid FROM " . TABLE_PREFIX . "post where threadid = " . $vbulletin->GPC['threadid'] . "  AND userid = " . $vbulletin->userinfo['userid'] . ""); 

                     if($vbulletin->GPC['threadid']  AND $vbulletin->userinfo['userid'] != $posted['userid'] AND can_moderate($forumid, 'canremoveposts') == false OR $vbulletin->userinfo['userid'] == 0) 
                     { 
                         return "<img src='images/hide.gif' border='0' alt='hidden' /><br />"; 
                     } 
                     else 
                     { 
                         return "<img src='images/uhhide.gif' border='0' alt='unhidden' /><br />$param"; 
                     } 
                } 
                $tag_list['no_option']['hide'] = array 
                ( 
                     'callback' => 'handle_external', 
                     'external_callback' => 'handle_hide', 
                     'strip_empty' => true, 
                ); 
           } 
           else 
           { 
               $tag_list['no_option']['hide'] = array 
               ( 
                   'html' => '%1$s', 
                   'strip_empty' => true, 
               ); 
           } 
} 


Can someone find where the problem is ?

Thank You