[opencms-dev] openCms 5 - properties vanish on the way from offline to online project

[Andras Balogh]

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
>
>
>  
>