#1009 mod_storage_sql does not iterate through prosodyarchive when user is deleted

Reporter nico
Owner Zash
Stars ★ (1)
  • Priority-Medium
  • Status-Fixed
  • Milestone-0.10
  • Type-Defect
  1. nico on

    What steps will reproduce the problem? 1. enable mam with mod_storage_sql 2. enable client to store message on the server 3. chat with ppl 4. delete your account 5. query the db for your old messages What is the expected output? function driver:purge(username) should iterate through the prosodyarchive db to delete old mam /offline messages from the db storage. What do you see instead? prosodyarchive is not iterated through. What version of the product are you using? On what operating system? prosody latest deb from prosody repo Please provide any additional information below. This is the part that should list the prosody archive https://hg.prosody.im/0.10/file/0.10.0/plugins/mod_storage_sql.lua#l416 Something like local stmt,err = engine:delete("DELETE FROM \"prosodyarchive\" WHERE \"host\"=? AND \"user\"=?", host, username);

  2. Zash on

    Thanks for the report, fixed in https://hg.prosody.im/0.10/rev/34814a908557

    • tags Status-Fixed
  3. Zash on

    • owner Zash
    • tags Milestone-0.10

New comment

Not published. Used for spam prevention and optional update notifications.