Wiping the chat

[Christian Grimes]

Hi, one of my friends recently posted some pictures to our chat and it i guess overloaded the chatbox and it crashed and now the page crashes every time you go to the chat. We need to reset the chat or wipe the log on it to fix the problem but we aren't sure on how to do that. Anyone know how to do that? Or have other ways of fixing it?

[Bobby Russ]

Go to your database and find the AJAX_Chat_messages table.  You can truncate it or remove a few messages.  I also set up a cron job to auto-purge messages older than 6 months to make the table more manageable.

On Sat, Dec 26, 2015 at 3:15 PM, Christian Grimes <christia...@gmail.com> wrote:

Hi, one of my friends recently posted some pictures to our chat and it i guess overloaded the chatbox and it crashed and now the page crashes every time you go to the chat. We need to reset the chat or wipe the log on it to fix the problem but we aren't sure on how to do that. Anyone know how to do that? Or have other ways of fixing it?

--
You received this message because you are subscribed to the Google Groups "AJAX-chat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ajax-chat+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

-----
"Dance as if no one were watching,
 Sing as if no one were listening,
 Live everyday as if it were your last,
 and love as if you've never been hurt."
 - Irish Proverb

[Christian Grimes]

It's on freeforums so we don't have that many options. I'm also relaying between you and my admin so bare with me. He says freeforums is really simplistic and wants to know if there are any in-chat commands he can use.

[Bobby Russ]

Admins can delete a message by selecting the "X" on the line.  However, if the system is crashing because of an image, I'm not sure you'll be able to view the logs too well.  The best bet is on the backend (the Database).

[Christian Grimes]

whats a database?

[Bobby Russ]

The Database is what holds your chat messages.  Since this is being used with a forum, it is most likely in the forum database, but it is one of the configuration settings in the config.php.  Your admin should know where or how to access it.

[Christian Grimes]

"Admin here- I seem to have gotten rid of the .gif messages, but people are still having issues with the chat itself crashing on them and killing the webpage. From the database I can see people logging in and out, but that's all. No one is able to make a lasting connection to the chat before getting crashed."

[Bobby Russ]

If you remove all the messages, then there should be no additional issues unless there is more issues than just the messages.

[Christian Grimes]

He wants to know how he can remove three years of chat messages without doing it manually. There may be some more messages left there, but if he trys to load them up in the database it just crashes

[Bobby Russ]

If it's a MySQL Database, he can type the following in a MySQL Window:

truncate AJAX_Chat_Messages;

On Sat, Dec 26, 2015 at 4:08 PM, Christian Grimes <christia...@gmail.com> wrote:

He wants to know how he can remove three years of chat messages without doing it manually

[Christian Grimes]

it's not

[Christian Grimes]

it's working now

[Bobby Russ]

Glad to hear.  :)

--

You received this message because you are subscribed to the Google Groups "AJAX-chat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ajax-chat+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.