#1359 Sqlite3 archive_store:delete error in prepared statement

Reporter georg
Owner Zash
Created
Updated
Stars ★ (1)
Tags
  • Milestone-0.11
  • Status-Fixed
  • Priority-Medium
  • Type-Defect
  1. georg on

    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>

  2. Zash on

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

    Changes
    • owner Zash
    • tags Component-Docs Status-Fixed
  3. Zash on

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

    Changes
    • tags Component-Docs Milestone-0.11

New comment

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