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

[Alessandro Magnolo]

In case you are not aware of this, the following bug was not fixed in 6.0.3.
I submitted it to the bug tracker as #998.

regards
alessandro magnolo

On 11/21/05, Alessandro Magnolo <alessandro.magnolo at gmail.com> wrote:
> 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
>