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/254ceb68-338c-4729-af6d-26cab2365b13n%40googlegroups.com.
