xwiki-users

xwiki-users@xwiki.org

10408 discussions

by Rudolf van der Leeden

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

17 years, 11 months

Re: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?

by Vincent Massol

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.

17 years, 11 months

question about xwiki upgrade with postgresql 8.1 database

by jimmy＠comkraft.com

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

17 years, 11 months

XpertNet house warming in Paris

by jeremi joslin

Hi, Sorry to send this late. You are all invited the the XpertNet house warming which will be in our new office in Paris. The XWiki team will be happy to meet you there. You can register here: http://www.uneinvitation.com/invitation.asp?tp=mail&id=16202&id2=775 jeremi -- http://www.jeremi.info skype: jeremi23 - jabber: jeremi23(a)gmail.com http://www.xwiki.com - http://www.pengyou-project.info

17 years, 11 months

xwiki : loading pages problem

by Julien Oix

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

17 years, 11 months

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

by Dandre

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

17 years, 11 months

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

by 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

17 years, 11 months

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

by 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

17 years, 11 months

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

by 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

17 years, 11 months

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

by 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

17 years, 11 months

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

xwiki-users