updating Trac database with direct SQL requests

20 views
Skip to first unread message

phep

unread,
Dec 27, 2021, 2:21:57 AM12/27/21
to Trac Users

Hi,

I'd like to update some custom or standard fields in the database of one of my Trac instances using SQL requests. I run this instance on my laptop with tracd and I'm always the only user (I turned this instance into a personal task manager, sort of).

I've had a look at the ticket, ticket_change and ticket_custom tables and I feel comfortable at dealing with the data in those 3 tables.

Yet I wonder if updating the database with SQL requests while tracd is running could have side effects in case there are some locks of any sort, or if this could affect some caching mechanism ?

Thanks in advance,

phep

RjOllos

unread,
Dec 27, 2021, 2:17:56 PM12/27/21
to Trac Users
There is some caching, so your best move would be to stop the server, make the database edits, start the server.

Ryan 
Reply all
Reply to author
Forward
0 new messages