Go Back   vb.org Archive > Community Discussions > Forum and Server Management
Prev Previous Post   Next Post Next
  #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
 

Thread Tools
Display Modes

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 01:03 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03988 seconds
  • Memory Usage 2,354KB
  • 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_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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