<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p.sub, li.sub, div.sub
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle20
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:Arial;
color:red;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'>Thanks Brett,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'>This helped me to repair the database.
However my modules use the property feature a lot, so need to patch this
somehow. I will keep you up to date on how I get along. Since this is fixed for
newer versions, would anyone know which classes were modified (the bug report
does not provide any information on this)?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'>Olli<o:p></o:p></span></font></p>
<div>
<div style='margin-left:36.0pt'>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
</div>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Brett
Beaumont [mailto:brett.beaumont@sytec.co.nz] <br>
<b><span style='font-weight:bold'>Sent:</span></b> 24 August 2004 22:03<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">olli_aro@yahoo.co.uk</st1:PersonName>;
<st1:PersonName w:st="on">The OpenCms mailing list</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [opencms-dev] Fix for
bug id 28 for version 5.0.0</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Olli,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Check
whether any property definitions have incorrect IDs by executing the following
SQL:</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>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</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'><br>
If any property definitions are listed with different IDs in online and offline
mode, the ID of the online definition must be updated. <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'><br>
If a definition has <offl_id> as its offline ID and <onl_id> as its
online ID, follow these steps:<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Check
the Online ID is not in use<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>select * from CMS_ONLINE_PROPERTYDEF where PROPERTYDEF_ID =
<offl_id></span></font><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>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.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Update
the Online Property Definition ID <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>update CMS_ONLINE_PROPERTYDEF set PROPERTYDEF_ID = <offl_id>
where PROPERTYDEF_ID = <onl_id></span></font><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>After
each fix, run the top SQL to ensure everything is correct.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Commit
the changes, if any.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Finally,
check that the sequences are not affected:</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>SELECT TABLE_KEY,ID<br>
FROM CMS_SYSTEMID<br>
WHERE TABLE_KEY = 'CMS_PROPERTYDEF' OR TABLE_KEY =
'CMS_ONLINE_PROPERTYDEF'</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>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:</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=2
color=blue face="Courier New"><span lang=EN-NZ style='font-size:10.0pt;
font-family:"Courier New";color:blue'>SELECT MAX(PROPERTYDEF_ID) FROM CMS_PROPERTYDEF;
<br>
SELECT MAX(PROPERTYDEF_ID) FROM CMS_ONLINE_PROPERTYDEF;</span></font><span
lang=EN-NZ><o:p></o:p></span></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=2
color=blue face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:
Arial;color:blue'>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.</span></font><span lang=EN-NZ><o:p></o:p></span></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=3
face="Times New Roman"><span lang=EN-NZ style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=2
color=blue face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:
Arial;color:blue'>I have found that once you get this problem, it is likely to
happen each time a new property definition is created.</span></font><span
lang=EN-NZ><o:p></o:p></span></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=3
face="Times New Roman"><span lang=EN-NZ style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=2
color=blue face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:
Arial;color:blue'>Please let me know if this helps, or if you have any
questions.</span></font><span lang=EN-NZ><o:p></o:p></span></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=3
face="Times New Roman"><span lang=EN-NZ style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=2
color=blue face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:
Arial;color:blue'>Reagrds,</span></font><span lang=EN-NZ><o:p></o:p></span></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=3
face="Times New Roman"><span lang=EN-NZ style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=2
color=blue face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:
Arial;color:blue'>Brett Beaumont</span></font><span lang=EN-NZ><o:p></o:p></span></p>
<p class=MsoPlainText style='mso-margin-top-alt:0cm;margin-right:0cm;
margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt'><font size=3
face="Times New Roman"><span lang=EN-NZ style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><font size=2 face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]<b><span
style='font-weight:bold'>On Behalf Of </span></b>Olli Aro<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, 25 August 2004
5:04 a.m.<br>
<b><span style='font-weight:bold'>To:</span></b> Opencms-Dev<br>
<b><span style='font-weight:bold'>Subject:</span></b> [opencms-dev] Fix for bug
id 28 for version 5.0.0</span></font><o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;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 size=2 face=Wingdings><span
lang=EN-GB style='font-size:10.0pt;font-family:Wingdings'>L</span></font><font
size=2 face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial'>Olli<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=sub align=center style='margin-left:36.0pt;text-align:center'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>---<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</span></font><o:p></o:p></p>
</blockquote>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2>---<BR>
Incoming 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><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.744 / Virus Database: 496 - Release Date: 24/08/2004<BR>
</FONT> </P>