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

[Antonio Core]

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(CmsWorkflowDriver.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(CmsWorkflowDriver.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