Modify

Opened 7 years ago

Closed 7 years ago

#7176 closed defect (fixed)

Problem with ticket / id column - patch

Reported by: anonymous Owned by: François Granade
Priority: normal Component: TicketImportPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

Ticket IDs need to be converted to int, added a patch. The patch also contains a change in fetching users now from the session table instead of collecting owners, reporters, etc.

Attachments (1)

users_and_id_patch.patch (1.7 KB) - added by anonymous 7 years ago.

Download all attachments as: .zip

Change History (5)

Changed 7 years ago by anonymous

Attachment: users_and_id_patch.patch added

comment:1 Changed 7 years ago by rlrj60

The session table also contains some junk cookies for anonymous users. It may slow down the search later. Suggest to qualify the query with the authenticated field for a clean list, e.g.:

295 add_sql_result(db, "SELECT DISTINCT sid FROM session WHERE authenticated > 0", existingusers) 

comment:2 Changed 7 years ago by François Granade

Status: newassigned

comment:3 Changed 7 years ago by François Granade

Patch applied (with modification) in [9726]. Thank you !

comment:4 Changed 7 years ago by François Granade

Resolution: fixed
Status: assignedclosed

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain François Granade.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.