I'm trying to get the tips running against postgresql, I'm getting:
In postgresql logs:
ERROR: null value in column "xwd_archive" violates not-null constraint
In xwiki.log:
Wrapped Exception:
java.sql.BatchUpdateException: Batch entry 0 insert into xwikidoc
(XWD_FULLNAME, XWD_NAME, XWD_TITL
E, XWD_LANGUAGE, XWD_DEFAULT_LANGUAGE, XWD_TRANSLATION, XWD_DATE,
XWD_CONTENT_UPDATE_DATE, XWD_CREA
TION_DATE, XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR, XWD_WEB,
XWD_CONTENT, XWD_VERSION, XWD_CUST
OM_CLASS, XWD_PARENT, XWD_CLASS_XML, XWD_ELEMENTS, XWD_DEFAULT_TEMPLATE,
XWD_VALIDATION_SCRIPT, XWD
_ID) values (XWiki.TagClass, TagClass, , , , 0, 2006-12-09
16:16:20.000000 -0500, 2006-12-09 16:16:
20.000000 -0500, 2006-12-09 16:16:20.000000 -0500, , , , XWiki,
, 1.1, , , <?xml version="1.0" encoding="UTF-8"?>
<class>
<name>XWiki.TagClass</name>
<customClass></customClass>
<customMapping></customMapping>
<defaultViewSheet></defaultViewSheet>
<defaultEditSheet></defaultEditSheet>
<defaultWeb></defaultWeb>
<nameField></nameField>
<validationScript></validationScript>
<tags>
<name>tags</name>
<prettyName>Tags</prettyName>
<unmodifiable>0</unmodifiable>
<relationalStorage>0</relationalStorage>
<displayType>select</displayType>
<multiSelect>1</multiSelect>
<size>30</size>
<separators> ,|</separators>
<values></values>
<number>1</number>
<classType>com.xpn.xwiki.objects.classes.StaticListClass</classType>
</tags>
</class>
, 0, , , -1050118876) was aborted. Call getNextException to see the
cause.
Is this a know issue, or something where I need to get a more current
schema? I tried finding the current schema at:
http://www.xwiki.org/xwiki/bin/view/DevGuide/Database+Schema
and it does have xwd_archive as a non-nullable field...
Help?
-Tom
--
May 4, 1970: Alison Krause, Jeffrey Miller, Sandra Scheuer, William Schroeder.