hello, I'm trying to install xwiki version 1.7rc1 on the postgres 8.3 using jdbc - postgresql-8.3-603.jdbc3.jar. After configuration hibernate have problem with database:
2008-12-03 17:00:54,551 [http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6] INFO .AbstractXWikiMigrationManager - New storage version is now [7351] 2008-12-03 17:00:58,749 [Lucene index rebuilder thread] [Lucene Index Rebuilder] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42883 2008-12-03 17:00:58,750 [Lucene index rebuilder thread] [Lucene Index Rebuilder] ERROR util.JDBCExceptionReporter - ERROR: operator does not exist: boolean <> integer 2008-12-03 17:00:58,768 [Lucene index rebuilder thread] [Lucene Index Rebuilder] WARN lucene.IndexRebuilder - Error getting document names for wiki [xwiki]. Internal error is: $s 2008-12-03 17:00:59,153 [http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42883 2008-12-03 17:00:59,159 [http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6] ERROR util.JDBCExceptionReporter - ERROR: operator does not exist: boolean <> integer 2008-12-03 17:00:59,169 [http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6] ERROR scheduler.SchedulerPlugin - Failed to initialize the scheduler com.xpn.xwiki.plugin.scheduler.SchedulerPluginException: Error number 90009 in 5: com.xpn.xwiki.plugin.scheduler.SchedulerPlugin: Failed to restore existing scheduler jobs Wrapped Exception: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc , BaseObject as obj where (doc.hidden <> 1 or doc.hid den is null) and doc.web='Scheduler' and obj.name=doc.fullName and obj.className='XWiki.SchedulerJobClass'] Wrapped Exception: could not execute query at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.restoreExistingJobs(SchedulerPlugin.java:282) at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.init(SchedulerPlugin.java:130) at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:155) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:92) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:120) at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1007) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:728) at com.xpn.xwiki.XWiki.<init>(XWiki.java:656) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:316) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:387) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) 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:693) at javax.servlet.http.HttpServlet.service(HttpServlet.java:806) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1121) at com.xpn.xwiki.plugin.webdav.DavFilter.doFilter(DavFilter.java:68) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112) at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:96) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112) at com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:287) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363) at org.mortbay.jetty.security.ConstraintsSecurityHandler.handle(ConstraintsSecurityHandler.java:220) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:822) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:305) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:229) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:113) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:550) at org.mortbay.jetty.ajp.Ajp13Connection.access$2800(Ajp13Connection.java:44) at org.mortbay.jetty.ajp.Ajp13Connection$RequestHandler.headerComplete(Ajp13Connection.java:232) at org.mortbay.jetty.ajp.Ajp13Parser.parseNext(Ajp13Parser.java:498) at org.mortbay.jetty.ajp.Ajp13Parser.parseAvailable(Ajp13Parser.java:151) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:407) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:235) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520) ... Wrapped Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean <> integer at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal(XWikiHibernateStore.java:2262) at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2235) at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2708) at com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:251) at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.restoreExistingJobs(SchedulerPlugin.java:263) at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.init(SchedulerPlugin.java:130) at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:155) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:92) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:120) Anybody know how to solve this problem? Thx for help and Greetings, Bart -- Bartłomiej Radziszewski mobile: +48 509 561 540 e-mail: [EMAIL PROTECTED] JID: [EMAIL PROTECTED] ICQ: #305569725 _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
