What would be a cause for lost personal canned responses, where are they kept (inside an individual’s Spark directory or on the Openfire server), and how can they be restored?
They are saved in the database, so the cause could be database corruption maybe. When i add new Canned responses category and response via Admin Console i see these inserts in my embedded-db:
/C4/INSERT INTO FPWORKGROUPPROP VALUES(1,‘jive.macro1’,’\u000a \u000a \u000a \u000a \u000a \u000a greiti atsakymai\u000a \u000a \u000a Parent Category\u000a’)
/C5/DELETE FROM FPWORKGROUPPROP WHERE OWNERID=1 AND NAME=‘jive.macro1’
/C6/INSERT INTO FPWORKGROUPPROP VALUES(1,‘jive.macro1’,’\u000a \u000a \u000a \u000a \u000a \u000a test greitas\u000a taip reikia daryti\u000a 0\u000a \u000a \u000a \u000a greiti atsakymai\u000a \u000a \u000a Parent Category\u000a’)