delete chat from fastpath refers to jlaSession table instead of fpSession table (new name)
Description
Reported by customer:
When trying to delete a previous chat from the fast path tab... it appears to be successful but the record does not delete... this is due to you code trying to delete from jlaSession (the old name) instead of fpSession. This should be a very quick fix.
Problem:
chat-summary.jsp, line 76:
pstmt = con.prepareStatement("delete from jlaSession where sessionID=?");
Change "delete from jlaSession where sessionID=?" to "delete from fpSession where sessionID=?"
Additional customer comment: It looks like you may also need to delete records from fpSessionMetadata and possibly fpSessionProp.
Environment
None
Activity
Show:
Daniel Hacquebord April 16, 2007 at 11:51 PM
I believe that records from the the following should be deleted:
fpSession fpSessionMetadata fpSessionProp (is this table used?) fpAgentSession
Reported by customer:
When trying to delete a previous chat from the fast path tab... it
appears to be successful but the record does not delete... this is due
to you code trying to delete from jlaSession (the old name) instead of
fpSession. This should be a very quick fix.
Problem:
chat-summary.jsp, line 76:
pstmt = con.prepareStatement("delete from jlaSession where sessionID=?");
Change "delete from jlaSession where sessionID=?" to "delete from
fpSession where sessionID=?"
Additional customer comment:
It looks like you may also need to delete records from fpSessionMetadata
and possibly fpSessionProp.