After running the 'trac-admin $ env ticketlog sync' command, the ticket_revision table is still empty. When creating a new ticket, the ticket_revision table is always empty. Weird ...
Le mercredi 23 juin 2021 à 14:07:30 UTC+2, Hervé B. a écrit : > Hello, > With version 1.4.3, there is a new table that appears in the database: > *ticket_revision*. > > With version 1.0.11 here is the SQL query in the trac.log file: > 2021-06-23 11: 34: 21,476 Trac [util] DEBUG: SQL: > SELECT p.value, v.rev, v.author, v.time, v.message > FROM revision v > LEFT JOIN repository p > ON v.repos = p.id AND p.name = 'name' > WHERE message LIKE% s > > 2021-06-23 11: 34: 21,476 Trac [util] DEBUG: args: ['% # 1207%'] > 2021-06-23 11: 34: 21,514 Trac [util] DEBUG: prefetch: 6 rows > > The result is 6 lines and the parameter '% # 1207%' > > With version 1.4.3 here is the SQL query in the trac.log file: > > 2021-06-23 13: 54: 47,360 Trac [util] DEBUG: SQL: > SELECT p.value, r.rev, r.author, r.time, r.message > FROM ticket_revision AS tr > LEFT JOIN revision AS r > ON r.repos = tr.repos AND r.rev = tr.rev > LEFT JOIN repository AS p > ON p.id = tr.repos AND p.name = 'name' > WHERE tr.ticket =% s > > 2021-06-23 13: 54: 47,360 Trac [util] DEBUG: args: (1207,) > 2021-06-23 13: 54: 47,360 Trac [util] DEBUG: prefetch: 0 rows > > The result is 0 lines and the parameter 1207, > > By passing the SQL query select * from ticket_revision, the table is empty. > > We see that the table is empty. What did we miss in the migration? > Le mercredi 23 juin 2021 à 04:42:01 UTC+2, RjOllos a écrit : > >> On Tuesday, June 22, 2021 at 7:35:19 AM UTC-7 Hervé B. wrote: >> >>> Hello, >>> I still have my problem. I don't see any changeset. >>> >>> Do you have an idea to investigate? >>> >> >> Suggest doing as Jun suggested and checking the logs for: >> >> https://trac-hacks.org/browser/tracticketchangelogplugin/1.2/ticketlog/web_ui.py?rev=18033&marks=78#L63 >> >> On Wednesday, June 16, 2021 at 5:26:46 PM UTC-7 Jun Omae wrote: >> Hi, >> >> >> You could check logged messages in trac.log with DEBUG level and >> browser console. >> >> https://trac.edgewall.org/wiki/TracTroubleshooting#ChecktheLogs >> https://trac.edgewall.org/wiki/TracTroubleshooting#ChecktheBrowserConsole >> > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/5baf2aff-be14-437f-92be-e69fab32bafen%40googlegroups.com.
