Page 1 of 3

LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 1:10 am
by semory
Wow, I'm gone for one day and what do you guys do? You guys go gone and crashed the web site :LOL:!
And since Hentai posted the last mchat message, I assume he's the one who broke it :P.
How long was it out lol?


Actually, I needed to repair two table: phpbb_sessions and phpbb_mchat. Everything else was fine. So guess what caused the web site to crash? Yup, the cruddy chatbox lol.

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 1:57 am
by MisterHentai
As soon as I :lick: ed the chatblox, it didn't post up, so I thought I'd refresh and then BAM, forum was bloken!

Not my fault my tentatongue is so powerful! :fyea: :LOL:

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 2:09 am
by semory
Wow, that I better back up the database more often now that we know how to break the Web site lol.

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 2:19 am
by MisterHentai
Maybe the chatbox archiving is starting to strain the whole thing? :lol:

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 6:56 am
by ProtocolX27
:lol: the infamy of the chat box.

Yeah may not be a bad idea to purge that table every so often, and of course backing up every once in a while is good too. :)

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 9:59 am
by semory
sounds like a good idea, will do it today.

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 11:52 am
by semory
ok, i backed up and then purged the chatbox. i have a feeling that since mchat stores the chat text as binary blobs in the database, these binary blobs are what were causing marvin's virus warnings. not sure but let me know if you guys are still getting virus warnings.

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 11:59 am
by MisterHentai
I've still never got a virus warning yet. So must be some other wierd crap or false positives going on.

But yeah, chatbox archive must be taking a strain on the forum due to the amount of crap in there I guess. :?

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 12:03 pm
by semory
actually, there were roughly 30,000+ chat posts, about the same number of forum posts we have. php and mysql should be able to manhandle that easy. we're still considered a "small" forum :D.

Re: LOL, OK, SO WHAT DID YOU GUYS DO?

Posted: Tue Jul 16, 2013 6:24 pm
by thePWA
Lets get rid of the chatbox :D