ConcourseSuite Support

Support
Corporate
PUBLIC PROFILE

Back to topics

Discuss Administration

Error on create a group of users

You need to be logged in to post messages

Error on create a group of users

2/6/2008 4:13 AM EST

An exception comes out when i try to create a group of users.

"java.sql.SQLException: ERROR: column "entered" is of type timestamp without time zone but expression is of type boolean"

This happen because when is called the method addUser() of UserGroup class, the sql insert statement is not correct, the sql.append(...currentTimestamp..) must be called before to set the statement value.

In this method there are two control about the value of "entered" variable, to solve this bug you need to move the follow else statement:

else
sql.append(DatabaseUtils.getCurrentTimestamp(db) + ", ");
}

to the first control at line 484.

482: if (entered != null)
483: sql.append("?, ");
484: } else
485: sql.append(DatabaseUtils.getCurrentTimestamp(db) + ", ");
486: }


Marco Pancioni

Antica Bottega Digitale

Concoursive Solution Provider