• Forum
  • Doc
  • Screenshots
  • Download
  • Donate
  • Contributors
  • Contact
  • Follow @phpfreechat
  • DEMO
  • Board index ‹ Version 1.x branch ‹ General Support (v1.x)
  • Change font size
  • FAQ
  • Register
  • Login

Chat History in MySql - Removes Data

Moderators: OldWolf, re*s.t.a.r.s.*2

Post a reply
3 posts • Page 1 of 1

Postby raxit4u2 » Sat Jul 16, 2011 7:42 am

Hi Friends,

I am facing the problem related to data saved.

I use PHPFreeChat Method to Mysql.. so it will save chat history in to database.

But if i look into database than i can find only last day's records and all previous day's data has been removed.

Did it remove data from mysql table automatically ?

Is there any way to keep all records in mysql table ?

Hope someone have idea about the same.

Thanks in advance.
raxit4u2
New member
 
Posts: 2
Joined: Sat Jul 16, 2011 7:38 am
Top

Postby TazChris » Thu Aug 04, 2011 4:34 pm

I noticed this issue to, so I just created a trigger on the table for inserts that copies it over to a chat_history table, not the most ideal solution, but it worked for us.

Chris
TazChris
New member
 
Posts: 1
Joined: Thu Aug 04, 2011 4:32 pm
Top

Postby raxit4u2 » Fri Aug 05, 2011 3:45 am

Thanks.

Can you please send me that trigger code?
raxit4u2
New member
 
Posts: 2
Joined: Sat Jul 16, 2011 7:38 am
Top


Post a reply
3 posts • Page 1 of 1

Return to General Support (v1.x)

Who is online

Users browsing this forum: No registered users and 39 guests

  • Board index
  • The team • Delete all board cookies • All times are UTC + 1 hour
Powered by phpBB® Forum Software © phpBB Group
Sign in
Wrong credentials
Sign up I forgot my password
.
jeu-gratuit.net | more partners
Fork me on GitHub