VGPelega
01-13-2009, 05:01 PM
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)
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/profilecomment.php?do=viewcomment&postcount=3&profilecommentid=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.
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)
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/profilecomment.php?do=viewcomment&postcount=3&profilecommentid=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.