Comments you submit will be routed for moderation. If you have an account, please log in first.
Modify

Ticket #3822 (closed defect: fixed)

Opened 5 years ago

Last modified 5 years ago

Postgres Compatibility Issues

Reported by: steven.studniarz@… Owned by: jdsiiro
Priority: normal Milestone:
Component: TracTicketModerator Version: TracTicketModerator 0.2
Keywords: Cc:

Description

I have had a few issues with using TracTicketModerator? with a Postgres database.

First of all, I had an issue where an SQL query was being generated and double quotes were used. The issue was on line 259 on web_ui.py (the 'status="%s"' bit). This was a trivial change.

A more daunting error appears to be the use of "old" as a column name in the moderator_tickets table. "OLD" is a reserved keyword in Postgres (and as such won't allow a moderator to view the page to approve/deny a pending ticket). I'd recommend the column name be changed to something else, but the changes to be made didn't seem to be completely trivial.

Thanks!

Attachments

Change History

comment:1 Changed 5 years ago by jdsiiro

Thanks! The correction to line 259 was committed to trunk in r1914.

I will work on changing the old column name and hopefully push out a new release with a couple other features in the next week or so.

comment:2 Changed 5 years ago by jdsiiro

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

The "old" column has been renamed to "orig" in r1951.

Existing installations will require an environment upgrade.

View

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
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.