Not every sqlite installation has the SQLITE_ENABLE_UPDATE_DELETE_LIMIT flag compiled in, so the DELETE statement isnt working: in archive_store:delete() OS: Archlinux Prosody Version: 0.11.2 LUA Version: 5.2.4 sqlite: 3.28.0 May 10 14:45:10 sql debug SQL transaction begin [function(mod_storage_sql.lua:237)] May 10 14:45:10 sql debug SQL transaction success [function(mod_storage_sql.lua:237)] May 10 14:45:10 sql debug SQL transaction begin [function(mod_storage_sql.lua:378)] May 10 14:45:10 sql debug Error in SQL transaction: /usr/lib/prosody/util/sql.lua:163: Error preparing statement handle: near "ORDER": syntax error stack traceback: /usr/lib/prosody/util/sql.lua:163: in function </usr/lib/prosody/util/sql.lua:158> (...tail calls...) [C]: in function 'xpcall' /usr/lib/prosody/util/sql.lua:206: in function '_transaction' /usr/lib/prosody/util/sql.lua:221: in function 'transaction' /usr/lib/prosody/modules/mod_storage_sql.lua:378: in function 'delete' /usr/lib/prosody/modules/mod_pubsub/pubsub.lib.lua:835: in function 'set' /usr/lib/prosody/util/pubsub.lua:548: in function 'publish' /usr/lib/prosody/modules/mod_pubsub/pubsub.lib.lua:589: in function 'handler' /usr/lib/prosody/modules/mod_pubsub/pubsub.lib.lua:291: in function </usr/lib/prosody/modules/mod_pubsub/pubsub.lib.lua:278> (...tail calls...) /usr/lib/prosody/util/events.lua:79: in function </usr/lib/prosody/util/events.lua:75> (...tail calls...) /usr/lib/prosody/modules/mod_iq.lua:38: in function '?' /usr/lib/prosody/util/events.lua:79: in function </usr/lib/prosody/util/events.lua:75> (...tail calls...) /usr/lib/prosody/core/stanza_router.lua:180: in function 'core_post_stanza' /usr/lib/prosody/core/stanza_router.lua:127: in function 'dispatch_stanza' /usr/lib/prosody/modules/mod_bosh.lua:305: in function 'func' /usr/lib/prosody/util/async.lua:127: in function </usr/lib/prosody/util/async.lua:125>

Thanks for the report. Requirement for this option documented in https://hg.prosody.im/site/rev/5baddff75039

• owner Zash
• tags Component-Docs Status-Fixed

Fallback to nested query added in https://hg.prosody.im/trunk/rev/acf4a7bfb6aa

• tags Component-Docs Milestone-0.11