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

[Alexander Kandzior]

> Subject: [opencms-dev] Re: BUG deleting user in OpenCms 6.0.2 
> withPostgreSQL 8.0.3
> 
> In case you are not aware of this, the following bug was not 
> fixed in 6.0.3.

We do need volunteeurs for the maintainance of the PosgreSQL implementation
for OpenCms. 

Antonio, the original contrubutor, is to much stuck in his work right now to
maintain the PostgeSQL DB driver constantly. 

If anyone is interested in helping out with this (PostgreSQL experience is
obviously required!), please let me know...

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of 
> Alessandro Magnolo
> Sent: Thursday, December 01, 2005 10:24 AM
> To: The OpenCms mailing list
> Subject: [opencms-dev] Re: BUG deleting user in OpenCms 6.0.2 
> withPostgreSQL 8.0.3
> 
> 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,C
> > 
> MS_OFFLINE_STRUCTURE.RESOURCE_PATH,CMS_OFFLINE_STRUCTURE.STRUCTURE_STA
> > 
> TE,CMS_OFFLINE_STRUCTURE.DATE_RELEASED,CMS_OFFLINE_STRUCTURE.DATE_EXPI
> > 
> RED,CMS_OFFLINE_RESOURCES.RESOURCE_ID,CMS_OFFLINE_RESOURCES.RESOURCE_T
> > 
> YPE,CMS_OFFLINE_RESOURCES.RESOURCE_FLAGS,CMS_OFFLINE_RESOURCES.RESOURC
> > 
> E_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_RESO
> > URCES.SIBLING_COUNT
> > FROM CMS_OFFLINE_ACCESSCONTROL,
> > CMS_OFFLINE_STRUCTURE,CMS_OFFLINE_RESOURCES WHERE 
> > 
> CMS_OFFLINE_ACCESSCONTROL.PRINCIPAL_ID='993709c3-5a77-11da-987
> 9-3b8330c1a7c0'
> > AND 
> > 
> CMS_OFFLINE_ACCESSCONTROL.RESOURCE_ID=CMS_OFFLINE_RESOURCES.RESOURCE_I
> > D AND 
> > CMS_OFFLINE_STRUCTURE.RESOURCE_ID=CMS_OFFLINE_RESOURCES.RESOURCE_ID
> > ORDER BY CMS_OFFLINE_STRUCTURE.RESOURCE_PATH ASC
> >
> >
> > regards,
> > Alessandro Magnolo
> >
> 
> 
> _______________________________________________
> 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
> 
>