View Single Post
  #1  
Old 01-13-2009, 05:01 PM
VGPelega VGPelega is offline
 
Join Date: Jul 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Missing database fields - profilecomment - Need help!

I have read some of the previous posts, and see that you like a lot of information, in order to get the situation right, so let me try and start from the beginning.

Recently my website has been targeted by an amateur using simple scripts to take my website offline. They succeed and as such, forced me to improve the security on my server. This was around 5 weeks ago. Since then, I have not had a security issue, until recently.

Now I have been getting email errors sent to me, and they are growing massively each day (30-60 emails - depending on how many profile comments are made that day I assume)
Quote:
Invalid SQL:
SELECT * FROM xxxxx_profilecomment WHERE profilecommentid = 201;

MySQL Error : Table 'xxxxx_forum.xxxxx_profilecomment' doesn't exist
Error Number : 1146
Request Date : Tuesday, January 13th 2009 @ 06:48:31 AM
Error Date : Tuesday, January 13th 2009 @ 06:48:31 AM
Script : http://www.worldofclans.com/forums/p...ecommentid=201
So I decided to wade into my database, only to find that these tables don't exist. Now the thing that concerns me, is the comments system "works" and shows the comments on the members page. These errors are generated mostly by guests/search bots. I can only think of one solution, and rebuilding the tables, but I didn't remove them, or understand why they are missing.

Is there anyone who could help me rebuild these missing tables, by telling me their structure, so I can add them to the db? If that doesn't work, or if you need more information, please ask.

I hope someone can help me understand how these tables got dropped!
vB Version: 3.7.2
Various Mods installed.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01072 seconds
  • Memory Usage 1,766KB
  • 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_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_onlinestatus
  • (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
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete