vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Big DB Problem Error 1146 (https://vborg.vbsupport.ru/showthread.php?t=68873)

Davez 08-30-2004 02:04 PM
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=0, user.usergroupid, displaygroupid) 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.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
        WHERE user.userid = 1 
     
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.

rake 08-30-2004 02:07 PM
You didn't uninstall the hack properly, and now vbulletin is trying to query a table in the database that doesn't exist. Retrace your steps and do the uninstall again. Basically, you need to remove anything that has to do with the useraward table from the above query, but there might be other references in other files.

Davez 08-30-2004 04:08 PM
Sorry, but i can´t follow you.
Where i have to remove this ? I checked my phpmyadmin, and seems that all looks for the table useraward .. and the table don´t exist anymore .. now i wanted to know where i have to change the useraward request.

I am not good with sql , and it would be fine, if someone can help me to fix this error, because i want my board back ;(

Many thanks

Reeve of shinra 08-30-2004 04:17 PM
You undid the database part of the hack, but you need to delete the edits you made to the php files and templates.

Davez 08-30-2004 04:31 PM
Many thanks !
I changed the files , now works .. i hope all works fine without any errors
/;


All times are GMT. The time now is 06:15 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.01189 seconds
  • Memory Usage 1,735KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete