[opencms-dev] BUG deleting user in OpenCms 6.0.2 with PostgreSQL 8.0.3

[Alessandro Magnolo]

I get an error whenever I try to delete a user using the
Administration interface.
The SQL query has an incorrect syntax where it says
"CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT" (a
missing "as" or "," between the two words?)

I'm using OpenCms 6.0.2 and PostgreSQL 8.0.3 on linux. This error does
not occur in OpenCms 6.0.0.

Here is the error message:

An SQL error occurred when executing the following query: SELECT
DISTINCT CMS_OFFLINE_STRUCTURE.STRUCTURE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_PATH,CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE,CMS_OFFLINE_STRUCTURE.DATE_RELEASED,CMS_OFFLINE_STRUCTURE.DATE_EXPIRED,CMS_OFFLINE_RESOURCES.RESOURCE_ID,CMS_OFFLINE_RESOURCES.RESOURCE_TYPE,CMS_OFFLINE_RESOURCES.RESOURCE_FLAGS,CMS_OFFLINE_RESOURCES.RESOURCE_STATE,CMS_OFFLINE_RESOURCES.DATE_CREATED,CMS_OFFLINE_RESOURCES.DATE_LASTMODIFIED,CMS_OFFLINE_RESOURCES.USER_CREATED,CMS_OFFLINE_RESOURCES.USER_LASTMODIFIED,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT,CMS_OFFLINE_RESOURCES.RESOURCE_SIZE,CMS_OFFLINE_RESOURCES.SIBLING_COUNT
FROM CMS_OFFLINE_ACCESSCONTROL,
CMS_OFFLINE_STRUCTURE,CMS_OFFLINE_RESOURCES WHERE
CMS_OFFLINE_ACCESSCONTROL.PRINCIPAL_ID='993709c3-5a77-11da-9879-3b8330c1a7c0'
AND CMS_OFFLINE_ACCESSCONTROL.RESOURCE_ID=CMS_OFFLINE_RESOURCES.RESOURCE_ID
AND CMS_OFFLINE_STRUCTURE.RESOURCE_ID=CMS_OFFLINE_RESOURCES.RESOURCE_ID
ORDER BY CMS_OFFLINE_STRUCTURE.RESOURCE_PATH ASC


regards,
Alessandro Magnolo