FW: [opencms-dev] openCms 5 - properties vanish on the way fromoffline to online project

[Olli Aro]

As far as I know this is still an issue with 5.01 as
well, but we have created a patch as OpenCMS module,
which can be downloaded from
http://www.clicksandlinks.com/opencms/opencms/downloads/com.clicksandlinks.roundabout.cms.sqlfixes_0.1.zip

Regards,

Olli

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of
Andras Balogh
Sent: 15 February 2005 08:09
To: The OpenCms mailing list
Subject: Re: [opencms-dev] openCms 5 - properties
vanish on the way fromoffline to online project

Hello,

    This is a bug in OpenCMS 5 i think that was fixed
in OpenCMS 5.0.1.
What is happening that your custom properties are
defined in 2 tables:
CMS_PROPERTYDEF
and
CMS_ONLINE_PROPERTYDEF
Now what happens is that "PROPERTYDEF_ID" column has
one value in 
CMS_PROPERTYDEF table
and another in CMS_ONLINE_PROPERTYDEF for your custom
properties. Make 
sure that
in CMS_ONLINE_PROPERTYDEF is the same value for this
column as in the 
other table.
    After this you should publish again the files (by
forceing a change 
on them or touch) and all should be fine.
Please note that for me this worked, but you should
make a backup of 
your DB BEFORE making any changes
directly in the DB so you can restore if something
really get messed up.

Best regards,
Andras Balogh.


Hans-Peter Meister wrote:

>Hi there,
>
>...hope somebody can help
>
>openCms 5 offers the possibility to define custim
properties for
>file types - so it does also for "Pages".
>
>So I did define some which would be extremely useful
for our project,
>such as
"author","source","medium_name",medium_type","sub_title".
>In fact we are doing some kind of media/press-archive
for a
>non-profit-organization.
>
>The strange thing about that is that these properties
can well be defined
>and show in the
>offline-project, but most of them do no show up in
the online-project.
>
>Looking at the database (using mySQL)
>
>reveals that a
>
>SELECT CMS_PROPERTIES.*
>FROM CMS_PROPERTIES, CMS_RESOURCES
>WHERE CMS_PROPERTIES.RESOURCE_ID =
CMS_RESOURCES.RESOURCE_ID AND
>CMS_RESOURCES.RESOURCE_NAME =
>'/default/vfs/de/gesellsch/spurensuche/some_text.html'
>
>returns 13 properties whereas
>
>SELECT CMS_ONLINE_PROPERTIES. *
>FROM CMS_ONLINE_PROPERTIES, CMS_ONLINE_RESOURCES
>WHERE CMS_ONLINE_PROPERTIES.RESOURCE_ID =
CMS_ONLINE_RESOURCES.RESOURCE_ID
>AND CMS_ONLINE_RESOURCES.RESOURCE_NAME =
>'/default/vfs/de/gesellsch/spurensuche/some_text.html'
>
>returns only 6 of them. The selection of attributes
which are shown seems to
>be
>by accident and I cannot see any system in that.
>I have tried any measure I could figure out from
within the CMS to get these
>attributes published - but nothing happens.
>
>I even tried to generate the properties by using SQL
directly on the
>database, but even these
>new generated properties do not appear in the online
project.
>
>Does anybody have a hint what to do about that??
>
>Thanks for any help in advance
>
>Hans-Peter Meister
>
>
>  
>



	
	
		
___________________________________________________________ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com