Auto closing for old pending chats....

[Rejaine]

Hi!!

I have been using the LHC quite successfully for two months, currently using the latest version v2.71. Great product, but I have this little problem.

I have many pending chats (ie: when visitor are transferred to the contact form) hanging for several days. Is there any way to automatically close these old pending chats?

It really does not make sense for the operator to have to accept a chat to an empty room just to close the call, once the visitor has already left the conversation and/or was redirected to the contact form (when no one answered the call)

I have read the documentation in: https://livehelperchat.com/how-to-setup-automatic-chat-s-closing-purging-341a.html

And already configured the "Automatic chat closing" parameter for 60 minutes and create crontab job to run every 10 minutes :

• / 10 * * * * cd / srv / www / htdocs / lhc_web && / usr / bin / php cron.php -s site_admin -c cron / workflow

This works well for old attended chats, but does not close the old pending chats.

Any way to get around this - maybe by cleaning or updating some table in the database, etc.. Or maybe some update in cron.php?

Thanks a lot for any help as I have hundreds of chats pending after 2 months of use and they are giving the much work to close manually :(

[Mike-Benoit]

Yes, we are seeing the same issue, a solution would be great!

[allancarlosvr]

the application LiveHelperChat its so good and powerfull, but i need the same solution for my pending chats.

I'll go to test your solution @Rejaine for the old chats in these two steps:

Automatic closing in web interface;
and, set crontab in my server in every 10 minutes

[allancarlosvr]

@Rejaine and @Mike-Benoit

`USE livechat;

UPDATE livechat.lh_chat
SET status=2
WHERE user_closed_ts <> 0
AND status=0;`

I solved this problem with a cron job...

1 - Create a Query SQL and Save as filename.sql
2 - Create conjob with crontab -e
3 - my cron job execute by 2 in 2 minutes and change status of "Pending chats" for "Closed Chats"
4 - In table livechat.lh_chat have 3 status with integer type: 0 - Pending / 1 - Active Chat / 2 - Closed Chats.
5 - */2 * * * * mysql -u username -ppassword livechat < /opt/scripts/filename.sql
6 All done!

[remdex]

Implemented in 3.00 version. In chat configuration will be option to set how long pending/active/bot chats remains in the same status before they get closed. See https://livehelperchat.com/3.00-various-small-enhancements-515a.html