AW: [opencms-dev] openCms 5 - properties vanish on the wayfromoffline to online project

[Hans-Peter Meister]

thx a lot for your help, but somehow it did not work.
I have installed the patch but the point still is that
the properties vanish.

1. I can create and publish the page using the standard properties
like NavText, Title and so on.

2. But after adding aditional properties, at a certain point -
up to now it even seems non-deterministic - most properties
get lost and I seem to get a random selection of half or less
of my properties left.

I am just getting crazy about that. I will set up the whole project
in my IDE and try to debug it step by step.

Has anybody ever had similar experiences?

Greetings from cold Brandenburg


> -----Ursprüngliche Nachricht-----
> Von: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org]Im Auftrag von Olli Aro
> Gesendet: Dienstag, 15. Februar 2005 15:41
> An: opencms-dev at opencms.org
> Betreff: FW: [opencms-dev] openCms 5 - properties vanish on the
> wayfromoffline to online project
>
>
> 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.clicks
> andlinks.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


_______________________________________________
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