I get this email every five minutes, any way to stop it...
DELETE FROM `bx_shoutbox_messages` WHERE FROM_UNIXTIME( UNIX_TIMESTAMP() - 1300 ) <= `Date`
I get this email every five minutes, any way to stop it... DELETE FROM `bx_shoutbox_messages` WHERE FROM_UNIXTIME( UNIX_TIMESTAMP() - 1300 ) <= `Date` |
I have the same problem - and just set the cron to once a day at midnight - so I get only one of this messages a day instead of every 5 minutes. |
What is full error message ? This query looks good and there is no error in it. Rules → http://www.boonex.com/terms |
Thats it thats all the email says but it arives every five minutes no matter what I set the job in mysql to. still comes every five minute,no error it clears the shoutbox.... |
AlexT, the following is the content of an automaticly every 5 minutes received email saying: DELETE FROM `bx_shoutbox_messages` WHERE FROM_UNIXTIME( UNIX_TIMESTAMP() - 1300000 ) <= `Date` |
PS: If possible do not write me personally, please try to ask on the forum first |
Alex, you guys may as well just remove the shoutbox from D7. It's really silly that the only way to delete messages, is aoutomatically via cron. It may not be a useless shoutbox, but it's close. Why waste your time on something no one is going to use? My opinions expressed on this site, in no way represent those of Boonex or Boonex employees. |
I wouldn't do that. My instant messenger on my current site has someone chatting in it 24/7..... It's the most used part of my forum. The most important part of a chatbox is that it's available no matter where you are in the site. Also, a delete feature would be nice for the admin but really isn't that big a deal unless your site is filled with unruly members. When a chatroom gets used the old messages fall off the bottom pretty quickly. http://towtalk.net ... Hosted by Zarconia.net! |
For a small payment experts do mod, allowing moderate a
chat. In D6 it is. Do not ask for much, leave it to experts the
opportunity to earn their bread. |
RE: For a small payment experts do mod, allowing moderate a
chat. In D6 it is. Do not ask for much, leave it to experts the
opportunity to earn their bread. Let experts earn their bread doing something that involves customization. Moderation controls on chat systems, shoutboxes, forums, comments, etc. are very basic features, and should not require someone to hire an 'expert' just to get those features. My opinions expressed on this site, in no way represent those of Boonex or Boonex employees. |