vb.org Archive - View Single Post - Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture

#**235** 08-02-2004, 06:03 PM

I have had the excact samt problem. But was a little confused about the post from "Zero Tolerance". Here the hole edited code-section. I hope this can help others:

Quote:

$getthreadids = $DB_site->query("
SELECT " . iif($sortfield == 'voteavg', $votequery) . " threadid, " . TABLE_PREFIX . "user.usergroupid AS usergroupid
FROM " . TABLE_PREFIX . "thread AS thread
$deljoin LEFT JOIN " . TABLE_PREFIX . "user ON " . TABLE_PREFIX . "user.userid = postuserid
WHERE forumid = $foruminfo[forumid]
AND sticky = 0
AND visible = 1
AND usergroupid<>24
$globalignore
$datecut
$limitothers
$delthreadlimit
ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
LIMIT $limitlower, $perpage
");

Quote:

Originally Posted by Zero Tolerance

Someone else has had this error, and im getting it too

Code:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:  
        SELECT  threadid, user.usergroupid AS usergroupid 
        FROM vb3_thread AS thread 
          LEFT JOIN vb3_user ON user.userid = postuserid 
        WHERE forumid = 5 
            AND sticky = 0 
            AND visible = 1 
            AND usergroupid&lt;&gt;17 
             
            AND thread.lastpost &gt;= 1075634033 
             
             
        ORDER BY sticky DESC, thread.lastpost DESC 
        LIMIT 0, 20 
    
mysql error: Unknown table 'user' in field list

Ive redone edits for all files, still didn't work, maybe if you could point out the exact edit that fixes this that might help, but i dont see any ive missed and ive gone through them all

Edit:

I fixed it, in the code i changed user. (2 times) to

PHP Code:


			
" . TABLE_PREFIX . "user.

Seems those with a prefix may have trouble with this

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01009 seconds Memory Usage 1,769KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code (1)bbcode_php (2)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: