Hi Vincent,

Yes, you're right but according to xwiki-992 at jira.xwiki.org I
thought that issue was not completely settled yet. That's why I decided
for this new thread.

Well, I tried something else! What?

I decided to import xwiki-1.0.xar again. My skin remained intact
because I copied the default skin to a new skin, and I used that at the
very beginning when setting up the wiki about a month ago now. Next I
changed from the default skin to our own one, rearranged the panels,
menus and voila saving the layout and preferences was no more problem!
After that I still had to fine tune the access rights!

Maybe this little experiment is of value to you, any way it seems that
everything is working properly again!

Regards,
 Gerard

>>> [EMAIL PROTECTED] 06/09/2007 13:39 >>>
Hi Gerard,

I thought I had already answered you about this this morning...

I'll repeat my suggestion: try tweaking the HBM file for PostGreSQL.

Alternatively try using a different database (like MYSQL) if you can  
as I believe the problem is why PostGreSQL.

Last, check the online mail archives since several people got XWiki  
working with PostGreSQL with some tweakings.

Thanks
-Vincent

On Sep 6, 2007, at 12:08 PM, Geert Verhaag wrote:

> Hi XWiki Users,
>
> I try to start a new thread about this problem, because the problem
is
> very urgent.
>
> This matter has been a topic around April this year as I found at
> jira.xwiki.org (key: xwiki-992: Cannot save new panel layout while
> logged in as Admin), but wasn't really solved if I understand it all
> well!
>
> I experience problems saving both my layout and preferences, getting
> the following message:
>
>         Error number 3201 in 3: Exception while saving document
> XWiki.XWikiPreferences
> Wrapped Exception: Could not execute JDBC batch update
> com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception
while
> saving document XWiki.XWikiPreferences
> 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:914)
>       at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:114)
>       at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:123)
>       at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:149)
>       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.doPost(ActionServlet.java:432)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>       at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
> (ApplicationFilterChain.java:269)
>       at
> org.apache.catalina.core.ApplicationFilterChain.doFilter 
> (ApplicationFilterChain.java:188)
>       at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter 
> (SetCharacterEncodingFilter.java:118)
>       at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
> (ApplicationFilterChain.java:215)
>       at
> org.apache.catalina.core.ApplicationFilterChain.doFilter 
> (ApplicationFilterChain.java:188)
>       at
> org.apache.catalina.core.StandardWrapperValve.invoke 
> (StandardWrapperValve.java:210)
>       at
> org.apache.catalina.core.StandardContextValve.invoke 
> (StandardContextValve.java:174)
>       at
> org.apache.catalina.core.StandardHostValve.invoke 
> (StandardHostValve.java:127)
>       at
> org.apache.catalina.valves.ErrorReportValve.invoke 
> (ErrorReportValve.java:117)
>       at
> org.apache.catalina.core.StandardEngineValve.invoke 
> (StandardEngineValve.java:108)
>       at
> org.apache.catalina.connector.CoyoteAdapter.service 
> (CoyoteAdapter.java:151)
>       at
> org.apache.coyote.http11.Http11Processor.process 
> (Http11Processor.java:870)
>       at
> org.apache.coyote.http11.Http11BaseProtocol 
> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 
> 665)
>       at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket 
> (PoolTcpEndpoint.java:528)
>       at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt 
> (LeaderFollowerWorkerThread.java:81)
>       at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run 
> (ThreadPool.java:685)
>       at java.lang.Thread.run(Unknown Source)
>
>
> Wrapped Exception:
>
> java.sql.BatchUpdateException: Batch entry 0 update xwikidoc set
> XWD_ARCHIVE=head
> .....
>
> Our consideration using xwiki for our institute's wiki site is in
> danger because of this error! Currently I'm unable to continue
> configuring it properly.
>
> I use XWiki version 1.0.3342 in combination with PostgreSQL-8.2,  
> TomCat
> 5.5 and jdk-6u2!
>
> The strange thing is that it has been working properly at the
> beginning.  Setting up the layout, preferences, and saving it all  
> wasn't
> a problem!
>
> Thanks!
>
> Regards,
> Gerard
>
>
> ==========================================
>
> Dit bericht is uitsluitend bestemd voor de geadresseerde.
> Het bericht kan vertrouwelijke informatie bevatten.
> Als u dit bericht per abuis hebt ontvangen, wordt u
> verzocht onmiddellijk de afzender te informeren. Ook
> verzoeken wij u het bericht te vernietigen en de inhoud
> niet onder derden te verspreiden of te gebruiken.
>
> This message is intended exclusively for the addressee.
> It may contain information that is confidential.
> If you are not the intended recipient, we request that
> you notify the sender immediately. In that case, we
> also request that you destroy the message and that
> you neither use the contents nor disclose them in any
> manner to third parties.
> ==========================================
>
> _______________________________________________
> users mailing list
> [email protected] 
> http://lists.xwiki.org/mailman/listinfo/users 

_______________________________________________
users mailing list
[email protected] 
http://lists.xwiki.org/mailman/listinfo/users
 

==========================================

Dit bericht is uitsluitend bestemd voor de geadresseerde.
Het bericht kan vertrouwelijke informatie bevatten.
Als u dit bericht per abuis hebt ontvangen, wordt u
verzocht onmiddellijk de afzender te informeren. Ook
verzoeken wij u het bericht te vernietigen en de inhoud
niet onder derden te verspreiden of te gebruiken.

This message is intended exclusively for the addressee.
It may contain information that is confidential.
If you are not the intended recipient, we request that
you notify the sender immediately. In that case, we
also request that you destroy the message and that
you neither use the contents nor disclose them in any
manner to third parties.
==========================================

_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to