Opened 12 years ago

Closed 9 years 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 11 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 9 years 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 9 years 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

Change Properties
Set your email in Preferences
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.