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

Jack Bakker jbakker at iable.ca
Fri Apr 15 20:40:47 CEST 2005


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





More information about the opencms-dev mailing list