I really like the new skin, especially the comments/attachments/history
display handling, and I don't want that to be missed. I have two
difficulties, however, both related to the elimination of the More
Actions menu:
First, I can't find a direct link to the Edit Objects URL for the page.
It works if I enter it manually (and let me gratefully note here that
the new skin has made the editobject template *much* more friendly), but
none of the menus seems to offer a path to it.
Second, the More Actions menu had an item that mitigated an existing
annoyance, which was that, if a page had objects (other than comments)
displayed on it, the URL in the Edit link was changed to /inline/ from
/edit/. To me it was annoying, but to many users, it was confusing,
which is worse, of course. It got to the point where I always used the
More Actions menu to select inline or edit myself, but now that option
is unavailable. Of course, I can always enter the URL by hand, or use
FoXWiki if I'm opening it from a link, so again it's not a show-stopper
for me but a problem for the Great Unwashed (or, as they say in
Ludovic-land, the sans culottes)...
I know how I can provide these, so I don't need that advice, but it
would, of course, be good to have them available in the default skin, so
I would like somebody to: 1) point out where they are if I've just
missed them; 2) discuss where you think they ought to be from the user's
perspective (especially if, for example, you have already re-implemented
them); and/or 3) suggest a JIRA item to provide them in the default
skin.
brain[sic]
Hello,
I'm new on this list, so forgive me for asking this, as I'm sure it's
answered before (but couldn't find it in FAQ). It took me a long time to
figure out how to create a link to the registration form, but finally found
it in one bug report: $xwiki.getURL("XWikiRegister", "register"). However,
now if you put it in a href it works the first time after saving, but if you
edit the same document in (in Wiki view) you see it's getting cut by the
parser at the first double quote, like $xwiki.getURL(". Saving the document
again understandably renders the link non-functional. Is there a proper way
of doing this and/or is there a reason why I couldn't use single quotes
instead of double quotes (as you would commonly circumvent the same problem
in Javascript implementations).
Kalle
Hi guys, this is my first message here. I would like to integrate Xwiki
inside of my system, using SSO, sharing stylesheets, menus and things like
that.
Anyone knows if there is documentation about that?
I've searched in the web-site, but without results.
Thanks,
Franklin Samir
http://jnuke.dev.java.net
Thanks alot guys.
I discovered the PanelWizard Page and I played around with it a bit.
What I did was add the expand/collapse header to it, and instead of
showing all the spaces and eliminating a few, I chose only to show the
spaces I wanted with the Navigator Panel. Looks pretty nice.
Its got some potential if you take the time to play around with it some
more, will see how much time I have left for it.
Regards,
Dandre
Hi All,
I was wondering if there was a simple way to get all the options for a
static list - eg, via a query?
In a few of my custom classes, I have several staticlist properties - I
need to cycle through the available options of each within velocity.
Brandon Esbach
Software Engineer
M/A-Com Eurotec Operations
LoughMahon Technology Park,
Skehard Road,
Blackrock,
Cork, Ireland
Tel +353 21 4808305
Good day everyone.
After getting our production DB to work with the new XWiki with
Postgres, I am just wondering how do you group all the spaces located in
the right-side panel like in the XWiki website, where you can click on a
group and the thing collapses or expands. In our case, there is so many
spaces that you scroll down and down and it gets pretty irritating after
a bit.
Any ideas on how to do it? I hope I am clear enough.
Thanks
Regards,
Dandre
I am new to using XWiki and tried looking for any previous discussion
on this (and didn't find any).
One of the biggest issues I've found so far in using XWiki is editing
documents (especially when developing a new set of pages for the web
site or adding many of them).
So, as per the Ideas page on xwiki.org I'd like to bring up the idea
of adding a WebDAV interface to XWiki.
This could allow easy access to the various pages themselves
(including classes, objects, and attachments using some sort of naming
convention) so that creating/updating pages could be done with many
different tools.
I haven't looked into anything too much yet, but I would think that
using something like the WebDAV Construction Kit from Jakarta Slide
(http://jakarta.apache.org/slide/wck.html) should make the task fairly
straight forward.
Does this sound like it's feasible?
David
dward(a)curriki.org
--
Ok, I have finally got my production DB to work.
It loads the new XWiki with our old skin (but we decided to move to the
new skin ;-) ) and you can save posts, etc.
For very long now, I've been receiving exceptions regarding the
xwikidocum0.xwdtitle_0 (kind of stuff, typed it out of my head) and
XWiki.XWikiPreferences errors. The problem was in xwikilongs where 2
entries (rows if you will) had NULL values in the xwd_value column. I
removed them and then received the Batch-error which Rudolf solved which
I then applied to the wiki (his SQL query that is) and then it worked.
Thanks for everyone's help and I hope that everyone would now be able to
move to the new XWiki with Postgres. Just note that I too am using
Postgres 8.2 now (upgrading wasn't an issue, just don't forget the JDBC
drivers!).
Regards,
Dandre
Hello, please help me with this problem
Why I can't see the header, footer and background images and the button color is a simple grey but not the color of my skin - I use xwiki10 skin? All the images (header-bg.jpg , background.jpg , and others) are still in the xwiki10 directory, but they aren't visible.
Hi, I would be very apreciate if someone answers this question
Where can I find pathes to the logo and background images in xwiki10 skin in order to change these pathes? Maybe it is some velocity or css file?
Hi there!
Is it possible to hide " ${pdoc.displayTitle}" and similar texts from the
navigation bar?
It's renders the proper title of the doc if the user is logged in but
displays the "${pdoc.displayTitle}" (and similar) strings if the user is
not logged out.
Anybody faced the problem? Solutions?
Cheers,
P
Hi,
I'm setting up xwiki on a debian server and keep getting the
"com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)"
error.
We are using 4.0.x and 7.1.
Do you use features that require more actual versions? Or other way
around: has anyone a running xwiki (b3) on debian using MySQL 4.0.x
and can help me with the setup?
Its a shared server, so maybe I just have to ask the admins to do some
config for me?
thanks
jan
Enclosed is xwiki-postgresql-1.0-beta-1.sql , the equivalent of
xwiki-mysql-1.0-beta-1.sql (available on the XWiki download area) for
Postgres.
This provides an empty Postgres database as a starting point for
working with XWiki 1.0Beta.
It has been tested with PostgreSQL 8.2.1 and XWiki 1.0B3.
Please test and provide feedback.
Rudolf VanderLeeden
vanderleeden(a)logicunited.com

Hi Fabian,
Any news or progress? Ludovic has answered to you but I didn't see
any answer from you... (I may have missed it though).
Thanks
-Vincent
On Jan 7, 2007, at 1:13 AM, Ludovic Dubost wrote:
>
> This line looks bad in your log file
>
> 15:05:41,526 ERROR http-8080-1 http://localhost:8080/xwiki/bin/view/
> Main/WebHome XWikiHibernateBaseStore:updateSchema:334 - Failed
> updating schema: ERROR: update or delete on "xwikiproperties"
> violates foreign key constraint "fkdf25ae4f283ee295" on "xwikilongs"
> Detail: Key (xwp_id,xwp_name)=(-1931600447,editbox_height) is still
> referenced from table "xwikilongs".
>
>
> You might want to try cleaning references between xwikilongs and
> xwikiproperties
>
> Fabian Gorsler a écrit :
> > Hi Vincent,
> >
> > thanks for your fast reply. :)
> >
> >
> >> The migration is described in the Release Notes and I've just
> linked it
> >> from the installation page this morning.
> >>
> >
> > The tasks described in the Release Notes don't work for my
> problem. At the
> > moment I'm not able to display anything with XWiki, I just receive
> > exceptions.
> >
> >
> >> Ha, that would be a problem. We need to track this as this is
> supposed to
> >> be the way to upgrade. What errors are you getting?
> >>
> >
> > org.postgresql.util.PSQLException: ERROR: column
> xwikidocum0_.xwd_title
> > does not exist
> >
> > This exception led me to assume that Hibernate mappings have
> changed. The
> > dump I've set up on my database for testing is identical to the live
> > system which serves the old XWiki.
> >
> > (The whole log with more exceptions and details is here:
> > http://www.der-moloch.de/files/xwiki-ml/xwiki_stdout.log)
> >
> >
> >> Don't do it manually!
> >>
> >
> > :)
> >
> >
> >> We thought it would work seamlessly but it seems it doesn’t in
> >> your case so we need to find out what's not working. Let's work
> >> together to resolve this.
> >>
> >
> > This sounds really great. Perhaps I should pass you my whole
> configuration
> > at first:
> >
> > - OS: Windows XP SP 2
> > - Tomcat 5.5.20
> > - JVM: Java(TM) 2 Runtime Environment, Standard Edition (build
> 1.5.0_07-b03)
> > - DB: PostgreSQL 8.1.5 (JDBC: postgresql-8.1-408.jdbc3.jar) / UTF-8
> >
> > The things I did:
> >
> > - I downloaded xwiki-1.0-beta-1.war and deployed it via Tomcat
> Manager.
> > - Stopped Tomcat.
> > - Renamed xwiki-1.0-beta-1/ to xwiki/ in webapps-folder of Tomcat.
> > - Added Postgres-JDBC-driver to xwiki/WEB-INF/lib.
> > - Edited hibernate.cfg.xml: Removed MySQL entries, pasted our
> > configuration of the old XWiki and reconfigured some connection
> settings.
> > - Started Tomcat and tried to open
> > http://localhost:8080/xwiki/bin/view/Main/WebHome.
> >
> > The connection settings from hibernate.cfg.xml:
> > <property
> > name="connection.url">jdbc:postgresql://localhost/xwikidb</property>
> > <property name="connection.username">xwiki</property>
> > <property name="connection.password">topsecret</property>
> > <property name="connection.driver_class">org.postgresql.Driver</
> property>
> > <property
> >
> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionPro
> vider</property>
> > <property name="connection.pool_size">50</property>
> > <property name="statement_cache.size">50</property>
> > <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</
> property>
> >
> > Connections to the Postgres-DB are opened and data is
> transferred. The
> > connection seems to be ok.
> >
> > Which information do you need additionally? What should I try to do?
> >
> > Thanks in advance for your help! :)
> >
> > Best regards,
> > Fabian.
Hi,
Currently we are using xwiki 0.984 in production (with postgresql 8.1). We
are planning to upgrade to 1.0 but don't want to migrate all the data from
the old db (for version 0.984 , 27 tables) to the new db (for version 1.0,
36 tables).
I dumped the production db into my pc and then point xwiki 1.0 code to
this old db. I left the ...hibernate.updateschema=1 as in subversion and
it automatically created the missing 7 tables. However, when I tried to
start xwiki, I got the following errors in the screen:
-------------------------------------------------------------------------
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize
main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.TagClass
Wrapped Exception: Could not execute JDBC batch update
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:266)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
--------------------------------------------------------------------
In xwiki.log, the error looks like:
11:55:36,605 ERROR http-8080-Processor25 [action]:invoke:253 -
Servlet.service() for servlet action threw exception
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize
main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.TagClass
Wrapped Exception: Could not execute JDBC batch update
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:266)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
saving document XWiki.TagClass
Wrapped Exception: Could not execute JDBC batch update
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:314)
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:100)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:94)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:793)
at com.xpn.xwiki.XWiki.getTagClass(XWiki.java:1897)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:601)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:513)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:257)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
java.sql.BatchUpdateException: Batch entry 0 insert into xwikidoc
(XWD_FULLNAME, XWD_NAME, XWD_TITLE, XWD_LANGUAGE, XWD_DEFAULT_LANGUAGE,
XWD_TRANSLATION, XWD_DATE, XWD_CONTENT_UPDATE_DATE, XWD_CREATION_DATE,
XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR, XWD_WEB, XWD_CONTENT,
XWD_VERSION, XWD_CUSTOM_CLASS, XWD_PARENT, XWD_CLASS_XML, XWD_ELEMENTS,
XWD_DEFAULT_TEMPLATE, XWD_VALIDATION_SCRIPT, XWD_ID) values
(XWiki.TagClass, TagClass, , , , 0, 2007-02-03 11:55:29.000000 -0500,
2007-02-03 11:55:29.000000 -0500, 2007-02-03 11:55:29.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>1</relationalStorage>
<displayType>checkbox</displayType>
<multiSelect>1</multiSelect>
<size>30</size>
<separator> </separator>
<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.
at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1314)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2574)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:561)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:539)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:309)
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:100)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:94)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:793)
at com.xpn.xwiki.XWiki.getTagClass(XWiki.java:1897)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:601)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:513)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:257)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
I saw some postings regarding xwiki upgrade in a postgresql environment
but haven't seen a success story yet. Has anyone successfully upgrade the
database in a postgresql environment? Or do you see why the above error
could happen? I am using the xwiki 1.1 snapshot from subversion last
night.
Thanks
-Jimmy
hi everyone,
I managed to deploy successfully a xwiki with Apache/Tomcat/mod_jk
container thanks to this help
(http://mail-archive.objectweb.org/xwiki-users/2007-01/msg00179.html :)
after configuration for needs, I notice that browsing the wiki with
firefox and the "html validator" extension :
** loading a page entirely needs much time (the content is loaded
immediatly but the loading icon runs a few seconds before stopping).
** the html validator extension tells me that "html cache is empty", it
can't analyse errors and warnings.
** this doesn't happen on the login page, only on pages with content,
accessible after logon.
Could it be a Apache user's permission problem ?
Anything else ?
Thanks.
--
Julien Oix
UFR d'Informatique - Université Paris Diderot
Bureau 5C01 (5ème étage)
175 rue du Chevaleret
75013 PARIS
Tel : +33 (0) 144 278 504
Mobile : +33 (0) 664 392 207
---------------------------------------------
http://www.gnu.org/philosophy/no-word-attachments.html
This is what I found in the Postgres serverlog file:
(Sorry that it is so long)
LOG: database system was shut down at 2007-02-05 14:37:48 SAST
LOG: checkpoint record is at 0/5825D640
LOG: redo record is at 0/5825D640; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/7259; next OID: 295714
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_aggregatorgroup_pkey" for table "feeds_aggregatorgroup"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_aggregatorurl_pkey" for table "feeds_aggregatorurl"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_aggregatorurlgroups_pkey" for table "feeds_aggregatorurlgroups"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_feedentry_pkey" for table "feeds_feedentry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_feedentrytags_pkey" for table "feeds_feedentrytags"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_keyword_pkey" for table "feeds_keyword"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"xwikicomments_pkey" for table "xwikicomments"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"xwikilinks_pkey" for table "xwikilinks"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"xwikipreferences_pkey" for table "xwikipreferences"
ERROR: update or delete on table "xwikiproperties" violates foreign key
constraint "fkdf25ae4f283ee295" on table "xwikilongs"
DETAIL: Key (xwp_id,xwp_name)=(-1531382335,editbox_width) is still
referenced from table "xwikilongs".
STATEMENT: delete from xwikiproperties where xwp_name like 'editbox_%'
and xwp_classtype='com.xpn.xwiki.objects.LongProperty'
ERROR: column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_,
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_,
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_,
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_,
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR: column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_,
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_,
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_,
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_,
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR: column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_,
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_,
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_,
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_,
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR: column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_,
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_,
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_,
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_,
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR: column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_,
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_,
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_,
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_,
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR: column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_,
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_,
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_,
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_,
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_aggregatorgroup_pkey" for table "feeds_aggregatorgroup"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_aggregatorurl_pkey" for table "feeds_aggregatorurl"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_aggregatorurlgroups_pkey" for table "feeds_aggregatorurlgroups"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_feedentry_pkey" for table "feeds_feedentry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_feedentrytags_pkey" for table "feeds_feedentrytags"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"feeds_keyword_pkey" for table "feeds_keyword"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"xwikicomments_pkey" for table "xwikicomments"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"xwikilinks_pkey" for table "xwikilinks"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"xwikipreferences_pkey" for table "xwikipreferences"
ERROR: update or delete on table "xwikiproperties" violates foreign key
constraint "fkdf25ae4f283ee295" on table "xwikilongs"
DETAIL: Key (xwp_id,xwp_name)=(-1531382335,editbox_width) is still
referenced from table "xwikilongs".
STATEMENT: delete from xwikiproperties where xwp_name like 'editbox_%'
and xwp_classtype='com.xpn.xwiki.objects.LongProperty'
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_ARCHIVE as XWD23_0_0_ from xwikidoc xwikidocum0_ where
xwikidocum0_.XWD_ID=$1
ERROR: column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_,
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_,
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_,
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_,
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
It keeps on referencing to tables and columns that doesn't exist, it
adds "_0" 's the whole time.
Regards,
Dandre
Oh, wait I saw it now. I did a SELECT statement in SQuirreL and I saw
that it only limited the tables to 100 from 600 and something.
Still, XWiki so far only has a problem opening up XWiki.XWikiPreferences.
Regards,
Dandre
@teh stu:
> But I wasn't upgrading from a Postgre DB, it was a MySQL 4.1.
> Problem was that it didn't work with the new Code (1.0B3) and developers
> suggested I change the DB to MySQL 5.
I know, I was just saying that MySQL 5 works but I was experiencing
problems with PostgreSQL.
@Everyone else: ;-)
I saw something interesting in my DB. In the old XWiki you still have a
XWiki.XWikiPreferences document. Now I think the reason why the new
XWiki isn't seeing it is because the DB viewers doesn't see it. I can do
a SQL statement and it will popup from the xwikidoc table but open it up
with SQuirreL or webmin (I also tried to view it in Postgres's psql app
but it was totally mixed up due to the table's data size), then it
doesn't appear to be in the xwikidoc table.
Anyone have any idea how to fix this? I tried deleting the
XWikiPreferences and adding it again but it won't show. Could it be a
reference problem or something?
Thanks
Regards,
Dandre
Hi Rudolf,
Yeah I did what you said and it worked for the dummy DB I've setup
earlier today.
When I cleaned up everything and added our production DB, and applying
what you said, it still gave me the same error as what I experienced
last week and the week before. Aparently I am missing a
XWiki.XWikiPreferences Document.
You can get the error messages here:
http://www.objectweb.org/wws/arc/xwiki-users/2007-01/msg00242.html
Regards,
Dandre
Hey VanderLeeden!
Thanks for your advice. I can confirm your story that I have started up
with a dummy DB and by upgrading to Postgres 8.2.1, and applying that
ALTER TABLE statement really did the trick!
Now I have to do it with our real DB! ;-)
Thanks again man!
Regards,
Dandre