An issue has been identified for Moxie Channels customers who are licensed for Email only (not Chat).
Agents may not be able to save any options from the Agent Client Options dialog or the dialog box may not close when attempting to save any options changes. This issue is due to a Chat feature added in versions 9.3 and 9.4 that was expecting a certain property to exist in the database.
Adding this property manually to the database will resolve issue until a product fix is made in a future release.
Important Notes:
-
The SQL statement below will update the property table for any agent that has attempted to save options.
-
If agents are added after this statement is executed, you must rerun the statement after these agents attempt to save options.
-
All agents with the issue must be logged off while running the SQL statements.
-
Channels services do not need to be stopped to run the SQL statement. However, stopping Channel Service will guarantee all agents are logged off.
The following SQL statement will add a required property ('MultipleChatEntry' = TRUE) to the UserProperties table in the main Channels database for all accounts that ever logged in and attempted to change any Options.
The follow SQL statement will change your production database. This should be executed by a qualified database administrator.
On main database, for the UserProperties table:
DECLARE @ID INT DECLARE ownerid CURSOR FOR SELECT DISTINCT ownerID
FROM UserProperties
WHERE ownerID NOT IN
(SELECT ownerID
FROM UserProperties
WHERE PropName = 'MultipleChatEntry') OPEN ownerid FETCH next
FROM ownerid
INTO @ID WHILE @@FETCH_STATUS = 0 BEGIN
INSERT
INTO UserProperties
VALUES (@ID, 0, 'MultipleChatEntry', 'TRUE') FETCH NEXT
FROM ownerid
INTO @ID END CLOSE ownerid DEALLOCATE ownerID
This should add an entry for each user account (shown as OwnerID in the table) called 'MultipleChatEntry' with the value set to TRUE.
If you have additional questions, please contact our Support team at 877-373-7848 (option 2) or via email at Support@gomoxie.com.