problem with tips against postgresql
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.
Well, I munged the Postgresql schema until it worked. Now, my problem is that the Registration email verification seems to do nothing at all... I set it to "Yes" in both the XWiki preferences and the default Space Preferences (which, I assume, should inherit the XWiki preferences, but I tried it just to be sure...). But, it stll just registers users and says they are "correctly registered" (but without doing any email verification...) - I tried bouncing Tomcat (5.5.20, Sun jvm 1.5.0_10, Ubuntu Dapper). - There are no errors or exceptions in the logs. Am I missing something basic? -Tom -- May 4, 1970: Alison Krause, Jeffrey Miller, Sandra Scheuer, William Schroeder.
participants (1)
-
Thomas Arthur Oehser