[ROL-274] Postgres expects boolean value in queries, not '1'

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.8.1
• Fix Version/s: 0.9.9
• Component/s: Data Model & JPA Backend
• Environment: Debian unstable, Jetty, Postgres, IBM Java 1.4.1
• Assignee: David Johnson
• Reporter: Steve Smith
• Created: 19/Nov/03 04:00
• Updated: 29/Jan/04 04:23
• Resolved: 29/Jan/04 04:23

Description

Location:
org.roller.business.hibernate.RefererManagerImpl.getDaysPopularWebsites

Line 184 contains "... and u.userenabled=1"
This is illegal under postresql as it expects a boolean value, not an integer. Changing the line to "... and u.userenabled=true" fixes the problem and should work in any reasonable database.