Opened 4 years ago

Closed 19 months ago

#10632 closed defect (fixed)

Invalid query to update session data on MySQL

Reported by: anonymous Owned by: branson
Priority: normal Component: DirectoryAuthPlugin
Severity: normal Keywords:
Cc: Trac Release:


MySQL complains that "INSERT OR REPLACE" query is invalid. Simple "REPLACE" should suffice.

Attachments (0)

Change History (3)

comment:1 Changed 4 years ago by kyle.james.oconnor@…

Same issue exists for Postgres backend (#11015). I have a patch there that should fix this issue for all backends.

comment:2 Changed 19 months ago by bebbo

In 14830:

refs #12068
refs #11686
refs #11361
refs #11307
refs #11304
refs #10878
refs #10715
refs #10667
refs #10632
refs #10631
refs #11015

various fixes

comment:3 Changed 19 months ago by bebbo

Resolution: fixed
Status: newclosed

all such queries are replaced with to statements # delete # insert

this also works with MariaDB and PostgreSQL

Modify Ticket

as closed The owner will remain branson.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.