Edgewall Software

Opened 9 years ago

Last modified 8 years ago

#12209 closed defect

Cannot save notify_subscription in PostgreSQL — at Initial Version

Reported by: Franz Mayer <franz.mayer@…> Owned by:
Priority: normal Milestone: 1.2
Component: notification Version: 1.1.6
Severity: major Keywords: postgresql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

When trying to save subscriptions in notification preference panel I am getting an error:

Trac detected an internal error:

ProgrammingError: operator does not exist: integer = boolean
LINE 2: ...                   WHERE sid='framay' AND authenticated=true
                                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

trac.log shows the full SQL:

2015-09-21 15:16:45,165 Trac[build\bdist.win32\egg\trac\db\util] DEBUG: SQL:                     SELECT id, distribu
tor, class FROM notify_subscription
                    WHERE sid=%s AND authenticated=%s
2015-09-21 15:16:45,165 Trac[build\bdist.win32\egg\trac\db\util] DEBUG: args: (u'framay', True)

I am using PostgreSQL, where the column authenticated is of type integer, thus above SQL is not correct, also the insert statement later in the method Subscription.replace_all.

Change History (0)

Note: See TracTickets for help on using tickets.