Modify

Opened 4 years ago

Closed 17 months ago

#10632 closed defect (fixed)

Invalid query to update session data on MySQL

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

Description

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 17 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 17 months ago by bebbo

  • Resolution set to fixed
  • Status changed from new to closed

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

this also works with MariaDB and PostgreSQL

Add Comment

Modify Ticket

Action
as closed The owner will remain sandinak.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.