|

»

[Tickets #8700] type cast needed for event_recurtype for postgresql-8.3.8

View: New views

7 Messages — Rating Filter: Alert me

	[Tickets #8700] type cast needed for event_recurtype for postgresql-8.3.8 by bugs-14 :: Rate this Message: Reply (Restricted by the Administrator) \| Reply to Author \| View Threaded \| Show Only this Message DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: http://bugs.horde.org/ticket/8700 ------------------------------------------------------------------------------ Ticket \| 8700 Created By \| michael.menge@... Summary \| type cast needed for event_recurtype for \| postgresql-8.3.8 Queue \| Kronolith Version \| 2.3.2 Type \| Bug State \| Unconfirmed Priority \| 1. Low Milestone \| Patch \| Owners \| +New Attachment \| event_recurtype.patch ------------------------------------------------------------------------------ michael.menge@... (2009-11-11 09:00) wrote: Nov 11 13:58:41 HORDE [error] [kronolith] DB Error: unknown error: SELECT event_id, event_uid, event_description, event_location, event_private, event_status, event_attendees, event_keywords, event_title, event_category, event_recurcount, event_recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_start, event_end, event_alarm, event_modified, event_exceptions, event_creator_id FROM kronolith_events WHERE calendar_id = 'xxxxx' AND ((event_end > '2009-11-01 00:00:00' AND event_start < '2009-12-08 00:00:00') OR (event_recurenddate >= '2009-11-01 00:00:00' AND event_start <= '2009-12-08 00:00:00' AND event_recurtype <> 0)) [nativecode=ERROR: operator does not exist: character varying <> integer bei Zeichen 578 TIP: No operator matches the given name and argument type(s). You might need to add explicit type casts.] [pid 4590 on line 331 of "horde-3.3.5/kronolith-h3-2.3.2/lib/Driver/sql.php"] -- You are subscribed to this list as: lists@... To unsubscribe, mail: bugs-unsubscribe@...
	[Tickets #8700] Re: type cast needed for event_recurtype for postgresql-8.3.8 by bugs-14 :: Rate this Message: Reply (Restricted by the Administrator) \| Reply to Author \| View Threaded \| Show Only this Message DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: http://bugs.horde.org/ticket/8700 ------------------------------------------------------------------------------ Ticket \| 8700 Updated By \| Chuck Hagenbuch <chuck@...> Summary \| type cast needed for event_recurtype for \| postgresql-8.3.8 Queue \| Kronolith Version \| 2.3.2 Type \| Bug -State \| Unconfirmed +State \| Assigned Priority \| 1. Low Milestone \| Patch \| -Owners \| +Owners \| Jan Schneider ------------------------------------------------------------------------------ -- You are subscribed to this list as: lists@... To unsubscribe, mail: bugs-unsubscribe@...
	[Tickets #8700] Re: type cast needed for event_recurtype for postgresql-8.3.8 by bugs-14 :: Rate this Message: Reply (Restricted by the Administrator) \| Reply to Author \| View Threaded \| Show Only this Message DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: http://bugs.horde.org/ticket/8700 ------------------------------------------------------------------------------ Ticket \| 8700 Updated By \| Jan Schneider <jan@...> Summary \| type cast needed for event_recurtype for \| postgresql-8.3.8 Queue \| Kronolith Version \| 2.3.2 Type \| Bug -State \| Assigned +State \| Feedback Priority \| 1. Low Milestone \| Patch \| Owners \| Jan Schneider ------------------------------------------------------------------------------ Jan Schneider <jan@...> (2009-11-12 06:54) wrote: This doesn't make sense, this is an integer column. -- You are subscribed to this list as: lists@... To unsubscribe, mail: bugs-unsubscribe@...
	[Tickets #8700] Re: type cast needed for event_recurtype for postgresql-8.3.8 by bugs-14 :: Rate this Message: Reply (Restricted by the Administrator) \| Reply to Author \| View Threaded \| Show Only this Message DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: http://bugs.horde.org/ticket/8700 ------------------------------------------------------------------------------ Ticket \| 8700 Updated By \| michael.menge@... Summary \| type cast needed for event_recurtype for \| postgresql-8.3.8 Queue \| Kronolith Version \| 2.3.2 Type \| Bug State \| Feedback Priority \| 1. Low Milestone \| Patch \| Owners \| Jan Schneider ------------------------------------------------------------------------------ michael.menge@... (2009-11-12 07:41) wrote: Here is the Table defenition, Tabelle »public.kronolith_events« Spalte \| Typ \| Attribute ---------------------+-----------------------------+-------------------- event_id \| character varying(32) \| not null event_uid \| character varying(255) \| not null calendar_id \| character varying(255) \| not null event_creator_id \| character varying(255) \| not null event_description \| text \| event_location \| text \| event_status \| integer \| default 0 event_attendees \| text \| event_keywords \| text \| event_exceptions \| text \| event_title \| character varying(255) \| event_category \| character varying(80) \| event_recurtype \| character varying(11) \| default 0 event_recurinterval \| character varying(11) \| event_recurdays \| character varying(11) \| event_recurenddate \| timestamp without time zone \| event_start \| timestamp without time zone \| event_end \| timestamp without time zone \| event_alarm \| integer \| default 0 event_modified \| integer \| not null event_private \| integer \| not null default 0 event_recurcount \| integer \| Indexe: »kronolith_events_pkey« PRIMARY KEY, btree (event_id) »kronolith_calendar_idx« btree (calendar_id) »kronolith_uid_idx« btree (event_uid) an Alter Table to change the type of event_recurtype to integer failed alter table kronolith_events alter column event_recurtype type integer ; ERROR: column "event_recurtype" cannot be cast to type "pg_catalog.int4" Tracking this down showed that the type was changed http://cvs.horde.org/h/chora/diff.php/kronolith/scripts/sql/kronolith.pgsql.sql?r1=1.5&r2=1.6 There is a upgrade script to fix this for mysql but not for postgres -- You are subscribed to this list as: lists@... To unsubscribe, mail: bugs-unsubscribe@...
	[Tickets #8700] Re: type cast needed for event_recurtype for postgresql-8.3.8 by bugs-14 :: Rate this Message: Reply (Restricted by the Administrator) \| Reply to Author \| View Threaded \| Show Only this Message DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: http://bugs.horde.org/ticket/8700 ------------------------------------------------------------------------------ Ticket \| 8700 Updated By \| Jan Schneider <jan@...> Summary \| type cast needed for event_recurtype for \| postgresql-8.3.8 Queue \| Kronolith Version \| 2.3.2 Type \| Bug State \| Feedback Priority \| 1. Low Milestone \| Patch \| Owners \| Jan Schneider ------------------------------------------------------------------------------ Jan Schneider <jan@...> (2009-11-12 07:56) wrote: Try this script. -- You are subscribed to this list as: lists@... To unsubscribe, mail: bugs-unsubscribe@...
	[Tickets #8700] Re: type cast needed for event_recurtype for postgresql-8.3.8 by bugs-14 :: Rate this Message: Reply (Restricted by the Administrator) \| Reply to Author \| View Threaded \| Show Only this Message DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: http://bugs.horde.org/ticket/8700 ------------------------------------------------------------------------------ Ticket \| 8700 Updated By \| michael.menge@... Summary \| type cast needed for event_recurtype for \| postgresql-8.3.8 Queue \| Kronolith Version \| 2.3.2 Type \| Bug State \| Feedback Priority \| 1. Low Milestone \| Patch \| Owners \| Jan Schneider ------------------------------------------------------------------------------ michael.menge@... (2009-11-12 08:10) wrote: works fine -- You are subscribed to this list as: lists@... To unsubscribe, mail: bugs-unsubscribe@...
	[Tickets #8700] Re: type cast needed for event_recurtype for postgresql-8.3.8 by bugs-14 :: Rate this Message: Reply (Restricted by the Administrator) \| Reply to Author \| View Threaded \| Show Only this Message DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: http://bugs.horde.org/ticket/8700 ------------------------------------------------------------------------------ Ticket \| 8700 Updated By \| Jan Schneider <jan@...> Summary \| type cast needed for event_recurtype for \| postgresql-8.3.8 Queue \| Kronolith Version \| 2.3.2 Type \| Bug -State \| Feedback +State \| Resolved Priority \| 1. Low Milestone \| Patch \| Owners \| Jan Schneider ------------------------------------------------------------------------------ -- You are subscribed to this list as: lists@... To unsubscribe, mail: bugs-unsubscribe@...