<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE>@font-face {
font-family: Wingdings;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
P.sub {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
LI.sub {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
DIV.sub {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff
size=2>Olli,</FONT></SPAN></DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff size=2>We've
hit this problem too. I think it is due to doing database imports. We have no
code fix, but we have a set of SQL statements that we have regularly used to get
around this problem.</FONT></SPAN></DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff size=2>Check
whether any property definitions have incorrect IDs by executing the following
SQL:</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=822514720-24082004><FONT face="Courier New" color=#0000ff
size=2>SELECT <BR> OFFL.PROPERTYDEF_NAME,<BR> ONL.PROPERTYDEF_ID
ONL_ID,<BR> OFFL.PROPERTYDEF_ID OFFL_ID<BR>FROM <BR> CMS_PROPERTYDEF
OFFL,<BR> CMS_ONLINE_PROPERTYDEF ONL<BR>WHERE <BR>
OFFL.PROPERTYDEF_NAME = ONL.PROPERTYDEF_NAME AND<BR> OFFL.RESOURCE_TYPE =
ONL.RESOURCE_TYPE AND<BR> OFFL.PROPERTYDEF_ID <>
ONL.PROPERTYDEF_ID</FONT></SPAN></DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff size=2><BR>If
any property definitions are listed with different IDs in online and offline
mode, the ID of the online definition must be updated. </DIV>
<DIV><BR>If a definition has <offl_id> as its offline ID and
<onl_id> as its online ID, follow these steps:</DIV>
<DIV> </DIV>
<DIV>Check the Online ID is not in use</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New">select * from CMS_ONLINE_PROPERTYDEF where
PROPERTYDEF_ID = <offl_id></FONT></DIV>
<DIV> </DIV>
<DIV>If this returns an empty set, then continue with the next statement.
Otherwise, the existing property with this ID is also incorrect and needs to be
fixed first.</DIV>
<DIV> </DIV>
<DIV>Update the Online Property Definition ID </DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New">update CMS_ONLINE_PROPERTYDEF set PROPERTYDEF_ID =
<offl_id> where PROPERTYDEF_ID = <onl_id></FONT></DIV>
<DIV> </DIV>
<DIV>After each fix, run the top SQL to ensure everything is correct.</DIV>
<DIV> </DIV>
<DIV>Commit the changes, if any.<BR></FONT></SPAN></DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff
size=2>Finally, check that the sequences are not affected:</FONT></SPAN></DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=822514720-24082004><FONT face="Courier New" color=#0000ff
size=2>SELECT </FONT></SPAN><SPAN class=822514720-24082004><FONT
face="Courier New" color=#0000ff
size=2>TABLE_KEY,ID<BR>FROM CMS_SYSTEMID<BR>WHERE TABLE_KEY =
'CMS_PROPERTYDEF' OR TABLE_KEY = 'CMS_ONLINE_PROPERTYDEF'</FONT></SPAN></DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=822514720-24082004><FONT face=Arial color=#0000ff size=2>After
running the fixes, I always make sure that the IDs in the above table are at
least as high as the highest used ID, which you can get
from:</FONT></SPAN></DIV>
<DIV><SPAN class=822514720-24082004><SPAN lang=EN-NZ
style="FONT-SIZE: 11pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'MS Mincho'; mso-bidi-font-size: 12.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-NZ; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN
lang=EN-NZ
style="FONT-SIZE: 11pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'MS Mincho'; mso-bidi-font-size: 12.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-NZ; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT face="Courier New"
color=#0000ff size=2>SELECT MAX(PROPERTYDEF_ID) FROM
CMS_PROPERTYDEF; <BR>SELECT MAX(PROPERTYDEF_ID) FROM
CMS_ONLINE_PROPERTYDEF;<BR></FONT></SPAN></P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff size=2>I believe you
need to restart the Tomcat server for the new values in the System ID table to
kick in (I believe it caches these values). However, the system IDs have
usually been okay for me and didn't require updating. Sometimes you need to
republish the content after doing these fixes, although a restart may fix
this.</FONT></SPAN></FONT></SPAN></P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></SPAN> </P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff size=2>I have found that
once you get this problem, it is likely to happen each time a new property
definition is created.</FONT></SPAN></FONT></SPAN></P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></SPAN> </P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff size=2>Please let me
know if this helps, or if you have any
questions.</FONT></SPAN></FONT></SPAN></P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></SPAN> </P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff
size=2>Reagrds,</FONT></SPAN></FONT></SPAN></P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></SPAN> </P>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT><SPAN
class=822514720-24082004><FONT face=Arial color=#0000ff size=2>Brett
Beaumont</FONT></SPAN></P></FONT></SPAN>
<P class=MsoPlainText dir=ltr style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-NZ
style="mso-fareast-font-family: 'MS Mincho'"><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </P></SPAN></SPAN></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]<B>On
Behalf Of </B>Olli Aro<BR><B>Sent:</B> Wednesday, 25 August 2004 5:04
a.m.<BR><B>To:</B> Opencms-Dev<BR><B>Subject:</B> [opencms-dev] Fix for bug id
28 for version 5.0.0<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi
all,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am currently implementing a
large site based on OpenCMS version 5.0.0 and have experienced the bug where
the property definition ids are out of sync (<A
href="http://www.opencms.org/bugzilla/show_bug.cgi?id=28">http://www.opencms.org/bugzilla/show_bug.cgi?id=28</A>).
Could someone advice me how to patch this for version 5.0.0? All our is
developed for version 5.0.0 and we have a lot of content in the cms already so
a version upgrade is not an option</SPAN></FONT><FONT face=Wingdings
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Wingdings">L</SPAN></FONT><FONT
face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Olli<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=sub style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN lang=EN-GB
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV><BR>
<P><FONT size=2>---<BR>Outgoing mail is certified Virus Free.<BR>Checked by
AVG anti-virus system (http://www.grisoft.com).<BR>Version: 6.0.737 / Virus
Database: 491 - Release Date:
11/08/2004<BR></FONT></P></BLOCKQUOTE></BODY></HTML>