I have big issue as I asked for help in anothere post but on my server its only one site, the mest busy one and we have a lot of message. I think maybe its to many and making problem with my site?Were can I delete this? I guess in DB but any area? I have no clue but i getting desprate as site keep go down and up a lot.
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
were can I delete old message in bulk? | Forum
Team ross
Nov 20 '15
Do the search on the forum, please this topic has already been discussed. Keyword, would probably be conversation
Christer
Nov 20 '15
Thanks Ross I did, search for word message no luck but wrod conversation worked better but Iam in panic as my site keep going down and every minuts is lost money,not sure this helps thanks
Abbey
Nov 22 '15
I doubt this is your issue, if your site keeps going down talk to your hosting, they can help pin point exactly where the issue is
Leader Patricia Zorrilla
Nov 22 '15
Go to http://www.onlineconversion.com/unix_time.htm
get a date in unix format, eg August 1, 2015
Sat, 01 Aug 2015 00:00:00 GMT -=> 1438387200Go to phpMyAdmin
Run these SQL:
DELETE FROM `ow_mailbox_message` WHERE `timeStamp` < 1438387200
DELETE FROM `ow_mailbox_conversation` WHERE `createStamp` < 1438387200
Go to FTP yousite.com/ow_userfiles/plugins/mailbox/attachments
Select and delete files previous at August 1, 2015
Sure it's not perfect but I have not found a better way to do it, it works.If someone finds a better way to say it, please.
The Forum post is edited by Patricia Zorrilla Nov 22 '15
