EMERGENCY--Site won't let me post!!!!!! Pleaes help!!!!!!

[NanoSector]

1.    WYSIWYG Quick Reply    2.1     [ Uninstall ] [ List Files ] [ Delete ]
2.   SMFShop    3.1.6.1     [ Uninstall ] [ List Files ] [ Delete ]
3.   Global Headers Footers    2.0     [ Uninstall ] [ List Files ] [ Delete ]
4.   Sitemap    2.1.2     [ Uninstall ] [ List Files ] [ Delete ]
5.   Bookmarks    2.3     [ Uninstall ] [ List Files ] [ Delete ]
6.   Spoiler Tag    0.7.2     [ Uninstall ] [ List Files ] [ Delete ]
8.   Default Avatar    2.1    [ List Files ] [ Delete ]
9.   SMF Multi Quote    1.1.2     [ Uninstall ] [ List Files ] [ Delete ]
10.   Post Template Mod    0.1.3     [ Uninstall ] [ List Files ] [ Delete ]
12.   Switch Permissions    1.0     [ Uninstall ] [ List Files ] [ Delete ]
13.   Member Awards    2.2.1     [ Uninstall ] [ List Files ] [ Delete ]
15.   SubAccounts Mod    1.0.1     [ List Files ] [ Delete ]
16.   Double Post Stopper    1.1     [ Uninstall ] [ List Files ] [ Delete ]
20.   SMF Staff Page    1.7     [ Uninstall ] [ List Files ] [ Delete ]
21.   SimpleSEF    1.1    [ List Files ] [ Delete ]
22.   Subaccount Shop    1.0     [ Uninstall ] [ List Files ] [ Delete ]
24.   YouTube BBCode    2.6     [ Uninstall ] [ List Files ] [ Delete ]
25.   SimpleAds    1.0.1     [ Uninstall ] [ List Files ] [ Delete ]
26.   Install & Uninstall Mods Quickly    1.3     [ Uninstall ] [ List Files ] [ Delete ]
28.   SMF Member Color Link (SMF 2.0 RC4)    1.0     [ List Files ] [ Delete ]
29.   Justify BBCode    2.3.1     [ Uninstall ] [ List Files ] [ Delete ]
30.   Ultimate Profile    0.9.1     [ Uninstall ] [ List Files ] [ Delete ]

Right, filtered mods that aren't installed.

I see SimpleSEF. Is that one installed?

[kat]

I believe it's been uninstalled, coz it was causing BIG problems. Quite how well it's been removed, though, I don't know.

[NanoSector]

I believe it's been uninstalled, coz it was causing BIG problems. Quite how well it's been removed, though, I don't know.

That's why I asked

Anyway, I took a look at the mysql errors.
[Thu Jan 12 15:08:17 2012] [error] [client 99.247.210.177] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/warrior/public_html/Sources/Subs-Db-mysql.php on line 329, referer: http://warriorcatsrpg.com/unreadreplies/
And LOTS of "mysql_real_escape_string()" errors.

I don't think you like my suggestion, and I don't either, but my guess is to just start testing with fresh files.
Heck, setting up a test forum doesn't mind anyway.

Take a backup of your files as they are now.
Then, take a breath, download the Large Upgrade package, unzip, upload it (without the upgrade files) and test that for a few days. Just fresh. Nothing installed. Only data.

[Illori]

i think for errors like that either her host or coreisp should take a look at the server configuration and see what may be needed to be changed.

[LiroyvH]

Oh i'm analyzing the logs already.
Actually, that access_log you see is not the real one. The real one is 4.1GB in size.

[kat]

4.1 GIG!!!

[Storman™]

I pop out for a while, come back, and you guys are in total website rebuild mode lol 

Good to see it getting sorted - cheers 

[wynnyelle]

Thanks guys. You rock.

Seems like we're just sitting down having a few cold ones over this. Actually, we already have a test site, or..two of them. The idea is yes, to get the whole thing recoded and import the tables. That's the goal. What makes it hard is how much extra stuff's been engineered into the site, and I use the word engineered lightly. The code work done was of varying quality, mostly good quality, but not done all together so it was sort of patchwork.

The biggest issues seem to come from the coloured names, a popular feature on our site; those will need a recode.

i was informed that last night's down time was due to a DDOS attack. That'd be IMO a pretty straightforward problem and solution, and Ihad to ask though, if that's what it was, why was only posting disabled for most of it and that the site was othewise loading normally, most of the time?

[NanoSector]

My guess is that either the httpd server or the MySQL server couldn't handle everything happening.
Most likely the MySQL server already had lots of load on it and couldn't cope with the posting anymore.
Just my guess though, it's possible I'm wrong all the way around

[wynnyelle]

That would make sense except it was the lowest traffic time of the day. About 5 am on my time. Very few members were on.

[NanoSector]

That would make sense except it was the lowest traffic time of the day. About 5 am on my time. Very few members were on.

I dunno then. Maybe something else was going on at that time of the day.

[wynnyelle]

We're looking into it. So far we still don't know.