No Proactive Invitations or Canned Messages

Creativologist · 2018-05-06 23:01:09

Updated to 2.93, then to 2.95

I have NO Proactive Invitations of canned messages. I had a bunch of them. They ARE showing up in the database and I can send a canned message from chat, but there is nothing listed LiveHelpChat configuration.

Please help

Vin

Last edited by Creativologist (2018-05-06 23:07:44)

PeopleInside · 2018-05-07 08:22:44

Hi Creativologist,
thank you for your message!

From your description seems something in the upgrade process went wrong.
I suggest to resume the backup than update again.

Pleas see the FAQ:
https://forum.livehelperchat.com/viewtopic.php?id=2193

In any case if there are corrupted backup I cannot help. You have to solve by yourself or consider commercial support.

Creativologist · 2018-05-07 22:19:25

Restore from 30 days ago did not resolve.

This is not making much sense. Everything else works, and the tables and data ARE IN THE DATABASE. It just shows empty when I go to site_admin/chat/cannedmsg or site_admin/abstract/list/ProactiveChatInvitation

PeopleInside · 2018-05-08 06:23:56

If the restoring is not working means two think:

your backup is not full so you do not backup / retored folder and database
the issue was also present 30 day aho

In any case i am unable to help with database corruption.

Creativologist · 2018-05-08 18:05:06

The database is NOT corrupt. I have stated twice that the data IS THERE.

PeopleInside · 2018-05-08 18:17:51

Great!

Creativologist · 2018-05-08 18:36:32

Not great. Is does NOT appear in the canned message screen. That is what I cannot figure out.

I have 19 canned messages in the database.

For sake of testing, I create a new canned message. Now only that one appears, and now I have 20 in the database. I cannot figure out why 19 messages are not showing on the canned messages screen. The canned messages also appear in dropbox on a live chat, so they do exist.

I may have to delete the 19 and just start creating them new again.

Creativologist · 2018-05-08 18:39:11

The problem sees to lie in "GLOBAL"

Creativologist · 2018-05-08 18:49:30

Can you tell me if this sql looks correct or if there is a field missing?

CREATE TABLE IF NOT EXISTS `lh_canned_msg` (
`id` int(11) NOT NULL,
`msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`position` int(11) NOT NULL,
`department_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`delay` int(11) NOT NULL,
`auto_send` tinyint(1) NOT NULL,
`fallback_msg` text COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`explain` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`attr_int_1` int(11) NOT NULL,
`attr_int_2` int(11) NOT NULL,
`attr_int_3` int(11) NOT NULL,
`languages` text COLLATE utf8mb4_unicode_ci NOT NULL,
`additional_data` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

PeopleInside · 2018-05-08 19:00:14

Again, sorry. I cannot provide database support.
If you want there is commercial support or in any case you can read here:
https://forum.livehelperchat.com/viewtopic.php?id=2255

I think to already suggested what i Can for fix your issue.

Creativologist · 2018-05-08 20:37:15

When I select NEW CANNED MESSAGE , I have 2 departments. Sales and Support.

The dropdown can select SALES or SUPPORT. There is no "ANY".

Why?

PeopleInside · 2018-05-08 20:38:39

Try to assign the admin profile to all department and see if now you are able to see the missed canned message.
You can do it by opening the profile on LHC and assign all department box... than go again on canned replies.

Last edited by PeopleInside (2018-05-08 20:39:30)

Creativologist · 2018-05-08 22:49:31

that worked.

Thank you very much

PeopleInside · 2018-05-09 08:58:27

Glad to hear that, thank you for the feedback!

Announcement

#1 2018-05-06 23:01:09

No Proactive Invitations or Canned Messages

#2 2018-05-07 08:22:44

Re: No Proactive Invitations or Canned Messages

#3 2018-05-07 22:19:25

Re: No Proactive Invitations or Canned Messages

#4 2018-05-08 06:23:56

Re: No Proactive Invitations or Canned Messages

#5 2018-05-08 18:05:06

Re: No Proactive Invitations or Canned Messages

#6 2018-05-08 18:17:51

Re: No Proactive Invitations or Canned Messages

#7 2018-05-08 18:36:32

Re: No Proactive Invitations or Canned Messages

#8 2018-05-08 18:39:11

Re: No Proactive Invitations or Canned Messages

#9 2018-05-08 18:49:30

Re: No Proactive Invitations or Canned Messages

#10 2018-05-08 19:00:14

Re: No Proactive Invitations or Canned Messages

#11 2018-05-08 20:37:15

Re: No Proactive Invitations or Canned Messages

#12 2018-05-08 20:38:39

Re: No Proactive Invitations or Canned Messages

#13 2018-05-08 22:49:31

Re: No Proactive Invitations or Canned Messages

#14 2018-05-09 08:58:27

Re: No Proactive Invitations or Canned Messages

Board footer