Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-30-2004, 02:04 PM
Davez's Avatar
Davez Davez is offline
 
Join Date: Nov 2001
Location: Italy
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Big DB Problem Error 1146

Hello all.

I got a big problem. I uninstalled a Hack , and after it i got this problem , i can?t enter in my board, and i can?t enter in the admincp.
Everywhere i got a Database problem.

PHP Code:
Database error in vBulletin 3.0.1

Invalid SQL
        
SELECT 
        userfield
.*, useraward.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate
        IF(
displaygroupid=0user.usergroupiddisplaygroupid) AS displaygroupid
            
language.phrasegroup_holiday AS phrasegroup_holiday
            
language.phrasegroup_global AS phrasegroup_global
            
language.options AS lang_options
            
language.languagecode AS lang_code
            
language.charset AS lang_charset
            
language.locale AS lang_locale
            
language.imagesoverride AS lang_imagesoverride
            
language.dateoverride AS lang_dateoverride
            
language.timeoverride AS lang_timeoverride
            
language.registereddateoverride AS lang_registereddateoverride
            
language.calformat1override AS lang_calformat1override
            
language.calformat2override AS lang_calformat2override
            
language.logdateoverride AS lang_logdateoverride
            
language.decimalsep AS lang_decimalsep
            
language.thousandsep AS lang_thousandsep 
        FROM user 
AS user 
        INNER JOIN userfield 
AS userfield ON (user.userid userfield.userid
        
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid user.userid
        
LEFT JOIN useraward AS useraward ON (useraward.userid user.useridINNER JOIN language AS language ON (language.languageid = IF(user.languageid 01user.languageid)) 
        
WHERE user.userid 
     
mysql error
Table 'dffcars_vBulletin.useraward' doesn't exist 

mysql error number: 1146 
Please can someone help me ? I have no idea what i can do.

Many thanks for help.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:27 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04791 seconds
  • Memory Usage 2,387KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete