[opencms-dev] task create error: invalid input syntax for typebigint (postgresql)

[Jack Bakker]

Thx.  

Jack 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Antonio Core
> Sent: Sunday, April 17, 2005 7:06 AM
> To: The OpenCms mailing list
> Subject: Re: [opencms-dev] task create error: invalid input 
> syntax for typebigint (postgresql)
> 
> 
> Hi Jack,
> 
> The error occurs due to the wrong type of 'COMENT' column. 
> Please, execute these commands on your pg database in order 
> to resolve that.
> 
> ALTER TABLE CMS_TASKLOG RENAME COLUMN COMENT TO COMENT_TMP; 
> ALTER TABLE CMS_TASKLOG ADD COLUMN COMENT text; update 
> CMS_TASKLOG set COMENT =COMENT_TMP; 
> commit;
> Alter table CMS_TASKLOG DROP COLUMN COMENT_TMP;
> 
> I'm preparing the patches to be applied to OpenCms source 
> code in order to resolve that problem during installation 
> time. I'll post these asap.
> 
> I hope that will help you.
> 
> Ciao
> 
> Anto
> 
> 
> 
> 
> On Fri, 2005-04-15 at 14:40 -0400, Jack Bakker wrote:
> > opencms6b1
> > postgresql 7.4.7
> > 
> > 
> > ---
> > 'admin' creation of a task, assigning to a 'user' the 
> following error 
> > occurs
> > 
> > 
> > 
> > ---
> > from opencms.log:
> > 
> > WARN [m.opencms.workplace.CmsTaskNew: 181] Could not create task
> > org.opencms.db.CmsSqlException: 
> > [org.opencms.db.postgresql.CmsWorkflowDriver] where: 
> > 
> org.opencms.db.generic.CmsWorkflowDriver.writeTaskLog(CmsWorkflowDrive
> > r.java
> > :632), why: org.postgresql.util.PSQLException: ERROR: 
> invalid input syntax
> > for type bigint: "For Group: Users
> > Task Agent: First Last (username)
> > a task send test #2, #1 failed"
> > query: INSERT INTO CMS_TASKLOG 
> (ID,TASKREF,USERREF,STARTTIME,COMENT,TYPE)
> > VALUES (13,51,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','2005-04-15
> > 14:41:20.194000-04','For Group: Users
> > Task Agent: First Last (username)
> > a task send test #2, #1 failed',100) [Code 301 - SQL Exception]
> > Root cause was: org.postgresql.util.PSQLException: ERROR: 
> invalid input
> > syntax for type bigint: "For Group: Users
> > Task Agent: First Last (username)
> > a task send test #2, #1 failed"
> > 
> >         at 
> > 
> org.opencms.db.generic.CmsWorkflowDriver.writeTaskLog(CmsWorkflowDrive
> > r.java
> > :634)
> >         at
> > 
> org.opencms.db.CmsDriverManager.writeTaskLog(CmsDriverManager.
> java:7602)
> > 
> > Jack
> > 
> > 
> > 
> > 
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the 
> list, please 
> > visit http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, 
> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
>