Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PubSubManager: DELETE FROM ofPubsubItem LEFT JOIN breaks MySQL

Description

Using fresh install of OpenFire 3.9.3 (but the database has been taken from another machine, running pretty recent OF version)

DB server is MariaDB 10

Manual test:

Looks like 7029145857a07bce16b8f1b18ce625d6a1378157 broke this query for MySQL (it needs {{DELETE tablename FROM tablename LEFT JOIN .... }}

Environment

None

Activity

Show:

Daryl Herzmann November 13, 2017 at 2:36 PM

appears to have been fixed here

Daryl Herzmann November 2, 2015 at 5:15 PM

Is this still an issue with Openfire 3.10.2 ?

Fixed

Details

Assignee

Reporter

Labels

Expected Effort

Minimal

Components

Fix versions

Affects versions

Priority

Created March 28, 2015 at 9:31 PM
Updated August 29, 2019 at 2:01 PM
Resolved November 13, 2017 at 2:36 PM