6.0.0-beta1
11/8/25

[#4522] Database error creating vacation filter (vacation_ignorelists column type)
Summary Database error creating vacation filter (vacation_ignorelists column type)
Queue Ingo
Queue Version HEAD
Type Bug
State Resolved
Priority 2. Medium
Owners
Requester dgehl (at) inverse (dot) ca
Created 10/13/2006 (6966 days ago)
Due
Updated 10/13/2006 (6966 days ago)
Assigned
Resolved 10/13/2006 (6966 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
10/13/2006 04:58:38 PM Chuck Hagenbuch Comment #2
State ⇒ Resolved
Reply to this comment
Fixed, thanks.
10/13/2006 01:06:40 PM dgehl (at) inverse (dot) ca Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Database error creating vacation filter (vacation_ignorelists column type)
Queue ⇒ Ingo
Reply to this comment
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@example.com', 
'test', 'testing123', 7, '', TRUE, 'user@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()

Saved Queries