[Tickets #4522] NEW: Database error creating vacation filter (vacation_ignorelists column type)

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=4522
-----------------------------------------------------------------------
 Ticket             | 4522
 Created By         | dgehl at inverse.ca
 Summary            | Database error creating vacation filter (vacation_ignorelists column type)
 Queue              | Ingo
 Version            | HEAD
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------


dgehl at inverse.ca (2006-10-13 06:06) wrote:

When trying to create a vacation filter I get the following error message

Oct 13 08:10:25 HORDE [info] [ingo] DB Error: unknown error: INSERT INTO
ingo_vacations (vacation_addresses, vacation_subject, vacation_reason,
vacation_days, vacation_excludes, vacation_ignorelists, vacation_owner)
VALUES ('user at example.com', 'test', 'testing123', 7, '', TRUE,
'user at example.com') [native code=ERROR:  column "vacation_ignorelists" is
of type integer but expression is of type boolean

In the 'CREATE TABLE' statement, we have

vacation_ignorelists INT DEFAULT 1

and in lib/Storage/sql.php (line 330)

(bool)$ob->getVacationIgnorelist()