Man, I am starting to get depressed.
It worked with the dummy DB but when I tried our main DB, it gave the
same exception as allways. The XWiki.XWikiPreferences thing that I've
been trying to fix for a while now.
Regards,
Dandre
I just wanted to let you know that I didn't have serious problems going from XWiki 0.9.1252 to XWiki 1.0B3 with a Postgres database.
Basically, I followed the instructions in:
http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWiki10Beta3
As reported earlier, you'll get an exception ("Could not execute JDBC batch update") connecting to XWiki 1.0B3 for the first time.
Analyzing the error message in xwiki.log:
Batch entry 0 insert into xwikidoc (XWD_FULLNAME .)
SQL ERROR: null value in column "xwd_archive" violates not-null constraint
leads to an easy conclusion: remove the not-null constraint from the xwd_archive column in the xwikidoc table.
The SQL statement is: ALTER TABLE xwikidoc ALTER COLUMN xwd_archive DROP NOT NULL;
After running this SQL statement the connection was done successfully and I could load the XAR file as described in the instructions.
In my case, only one thing was different from the old XWiki. All the memberships in XWikiAllGroup were gone. Only the ADMIN user was a member. So I created a Ruby script to add all users to XWikiAllGroup in the database. This can of course also be done manually.
I don't know if this works in all Postgres cases.
BTW, I did at the same time a database upgrade from PG 8.1.3 to 8.2.1.
Rudolf VanderLeeden
SysAdmin
Logic United GmbH
(Germany)
Hi everyone,
Why can't I find the xwiki.hbm.xml file in 1.0B2 package? Am I required to create it by my self, or XWiki will provide one?
Because once XWiki tried to recreate the tables, I got the error:
[XWikiHibernateStore] Failed updating schema: ORA-01754: a table may contain only one column of type LONG
It seems that we have to map some MySQL datatype to the proper Oracle type, in order to generate the proper DDL.
Does anyone have a hbm.xml file that works with Oracle? Or what else need to be changed in the hibernate.cfg.xml?
(I am using 10g JDBC driver)
Best regards,
Eric Sun
-----Original Message-----
From: Ludovic Dubost [mailto:ludovic@xwiki.org]
Sent: Wed 1/18/2006 6:42 PM
To: Eric Sun (Toronto)
Subject: Re: Installation concerns for Oracle 10g
Hi,
You should post this to the users/dev lists.
http://forge.objectweb.org/mail/?group_id=170
With XWiki 1.0B2 you should be able to run XWiki with an empty database
(XWiki creates the tables automatically) and then try to import the
".xar" file available on xwiki.org into the XWiki running with the
Oracle DB.
Let us know how this works.
Ludovic
Ok, the only problem I encountered while surfing the wiki is that it
throws up exceptions while saving stuff. Maybe XWiki has a problem or
maybe the problem I encountered while copying is the bugger.
Anyway, I think we can use this way to help shape XWiki to use an old
xwiki db in postgres directly as MySQL.
What you do is you take your old xwiki postgres db, use the SQuirreL (or
any DB copier) to copy over the tables from your postgres to MySQL. Move
to the new xwiki while pointing at your MySQL db. Then move back to
postgres and let the new XWiki point to Postgres again. MySQL and XWiki
will "straighten" things out that will allow you to use the new Xwiki
with Postgres. I hope this will work for everyone as it worked for me
(well it almost worked 100% :-) ).
Regards,
Dandre
Ha ha! It worked! Well, it couldn't copy over something in 1 table,
something about a duplicate reference or something but other than that,
I could open up the new xwiki in postgres with an imported db from the
old one!
Ok, I'll post more info later.
Regards,
Dandre
I have found a forum on the MySQL site (something like this on the net
is as scarce as chicken teeth :-D ) that talks about converting a
PostgreSQL db to a MySQL one (well I still need to try it out, will let
everyone know):
http://forums.mysql.com/read.php?83,34517,34517#msg-34517
Why? Well if you want the new XWiki to work and you don't mind the kind
of DB to use, then this is a good solution.
But I wanna try something. I want to copy my PSQL db to MySQL and get
that to work on the new XWiki and hopefully I can convert it back to
PSQL and it'll work on the new XWiki (HOPEFULLY)!!!
On that forum thread, there is a plugin for SQuirreL SQL that basically
allows you to copy between DBs! Now thats handy! I want to test that out
and see if it will work! Oh how I hope it'll work!!!
Regards,
Dandre
Hello Vincent and everyone at XWiki!
I am going through the code but I need to view how XWiki is generating
SQL queries that are sent to the JDBC driver in order to see if it's
XWiki that has a problem or Hibernate or the JDBC driver. Yes, I am
working with Fabian and them to try and figure out why Postgres gives a
problem when porting from an old DB.
Could you guys maybe give me instructions of how to turn on debug mode.
Thanks alot.
Regards,
Dandre
> Which IDE are you using? I've planned to write documentation on how to
> debug XWiki from within IntelliJ IDEA. If you need it I can do it
> sooner rather than later.
Right now I am not using an IDE. Pure text viewers and editing ;-)
If you can it would be great, but unfortunately I cannot spend too much
time figuring out what is wrong, being at work they only give me a
certain amount of time to get this thing moving and I've been working on
this for almost 2 weeks now.
I think I should try to find a way to extract the posts from the old
xwiki DB and get it to insert into the new xwiki DB through an app or
something. Maybe that is a good short-term solution. It should work,
right? Unless there are too many dependencies to insert and keep track of.
Thanks
Regards,
Dandre
> I just did that, running on Tomcat 5.5 against a MySQL 5.0.21 server.
> I loaded the database dump from the old xwiki app.
> Unfortunately, still the same error, see below.
I use MySQL 5.0.22 and it works great.
I think XWiki might have a problem with porting from the old xwiki with
Postgres and not the JDBC driver or the Hibernate thing.
Hi ,
I am New to XWIki.
I want to Create Menu for My XWiki Appalication , the Help DOc said I have
to create a Page called Menu in a Space , then it will automatically
DIsplay it in all the pages in that Space.
I have create the Page called Menu In a Space , But the Menu is not at all
Loaded in any page . If I open the3 Menu page I can See the Content Only
Once But as per the Help Doc it should Show 2 time.
I am using XWiki 1.0 Beta 2
Pl. let me know how to get the Menu is Left or in Right Side .
--
View this message in context: http://www.nabble.com/How-to-Create-Menu-in-XWiki-tf3148965.html#a8729694
Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi,
It's probably me, but I can't seem to find a way to export specific spaces.
In earlier version of the import/export there was a drop down and you
could select specific spaces & pages to export... now it seems to only
export the entire wiki.
I had a nasty problem with my wiki (some pages were "bad" and when I
tried to delete them I got told they didn't exist) and thought... I
know, I'll just export the good stuff and drop the db then import my
good pages back in... I couldn't becuase export seems to be exporting
the whole wiki (despite a space parameter in the url).
So, question is can I export specific pages / spaces only & if so any hints :)
Thanks,
Dan
>
> >> Is there a way to get the numbered list (i.e . 1.) to continue the
> >> numbering instead of restarting if the list item is separated by some
> >> text, paragraph, etc?
>
It's on my todo list.
Could we imagine a carriage return character as like as for properties
> files which could be used for both list and table?
Try \\
--
http://purl.org/net/sergiu
Hi Everyone,
I was trying to upgrade from 0.984 to 1.0B3, but to no avail.
I found this thread:
http://mail-archive.objectweb.org/xwiki-users/2006-12/msg00106.html
But there are no answers there.
If I just run 1.0B3 on the existing database, I get an exception (trace
below).
Somewhere i read that this could mean the database is corrupted.
But I don't think so, it works fine with release 0.984.
So, is there an official way to upgrade the database so I can keep all
the articles ?
Thanks,
Lukas
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.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:223)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303)
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)
On Mar 9, 2007, at 2:30 AM, Duke Tantiprasut wrote:
> Is there a way to get the numbered list (i.e. 1.) to continue the
> numbering instead of restarting if the list item is separated by
> some text, paragraph, etc?
Not that I know of. That would be nice and useful to have but I'm not
sure about the algorithm to use. I guess we could introduce a {list}
macro to delimitate the list section. Without this it's hard to guess
if it should be one list or 2 lists.
In any case could you add this as an improvement in JIRA and if you
want to see it implemented quickly, could you submit a patch for it?
(otherwise it'll have to wait for some time as we're currently busy
trying to fix the maximum number of bugs for the 1.0 release).
Thanks
-Vincent
___________________________________________________________________________
Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface r�volutionnaire.
http://fr.mail.yahoo.com
I have a old xwiki deploied with tomcat + postgresql:
tomcat 5.5.20-r7
postgresql 8.0.9-r1
and I did a migrate from 0.9.840 to 1.0b3 using war package and I have
meet following exception when load the page:
exception
javax.servlet.ServletException: Error number 3 in 0: Could not
initialize main XWiki context
Wrapped Exception: Error number 3202 in 3: Exception while reading
document XWiki.XWikiPreferences
Wrapped Exception: Could not parse configuration:
jndi:/localhost/xwiki/WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
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)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize
main XWiki context
Wrapped Exception: Error number 3202 in 3: Exception while reading
document XWiki.XWikiPreferences
Wrapped Exception: Could not parse configuration:
jndi:/localhost/xwiki/WEB-INF/hibernate.cfg.xml
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)
here is the hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate
Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>
<property name="dbcp.defaultAutoCommit">false</property>
<property name="dbcp.maxActive">50</property>
<property name="dbcp.maxIdle">5</property>
<property name="dbcp.maxWait">30000</property>
<property name="dbcp.whenExhaustedAction">1</property>
<property name="dbcp.ps.whenExhaustedAction">1</property>
<property name="dbcp.ps.maxActive">20</property>
<property name="dbcp.ps.maxWait">120000</property>
<property name="dbcp.ps.maxIdle">20</property>
<!-- Uncomment if you want to use HSQLDB.
Note that the database will be created automatically if it doesn't
already exist.
<property
name="connection.url">jdbc:hsqldb:file:/some/path/xwiki_db;shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property
name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
-->
<!-- Default MySQL configuration
<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
-->
<!-- Default MySQL configuration -->
<property
name="connection.url">jdbc:postgresql://localhost/xwiki</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property
name="connection.driver_class">org.postgresql.Driver</property>
<property
name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property
name="connection.provider_class">com.xpn.xwiki.store.DBCPConnecti$
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
<!-- Mapping files -->
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
</session-factory>
</hibernate-configuration>
I see that it cannot parse the hibernate.cfg.xml through jndi, where I
did wrong? how to let it parse the configuration file through jndi.
kind regards,
- Muzi
Hi everyone,
I installed the xwiki-1.0-beta-3 with the standalone distribution (tar.gz
package) on my Unix (Sun OS) server but I get some issues trying to access
it. The server starts without any problem, but when I try to access to
"http://localhost:8080/xwiki/bin/view/Main/WebHome" url, I get an "HTTP
ERROR: 500" on my browser and this error in my main log :
com.xpn.xwiki.XWikiException: Error number 3001 in 3: Cannot load store
class com.xpn.xwiki.store.XWikiHibernateStore
Wrapped Exception: java/util/concurrent/ConcurrentHashMap
Followed by several other stack traces. I checked and forced my classpath by
modifying the "start_server.sh" that way:
CLASSPATH=$CLASSPATH:\
$JETTY_HOME/lib/org.mortbay.jetty-jdk1.2.jar:\
$JETTY_HOME/lib/javax.servlet.jar:\
$JETTY_HOME/ext/jasper-runtime.jar:\
$JETTY_HOME/ext/jasper-compiler.jar:\
$JETTY_HOME/ext/xercesImpl.jar:\
$JETTY_HOME/ext/xml-apis.jar:\
$JETTY_HOME/ext/xmlParserAPIs.jar
$JAVA_HOME/java $JAVA_OPTS -cp $CLASSPATH -Dfile.encoding=iso-8859-1
-Djetty.port=$JETTY_PORT -Djetty.home=$JETTY_HOME -jar $JETTY_HOME/start.jar
My java version:
java version "1.4.1_05"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_05-b01)
I encounter the same problem with this standalone installation on my Windows
PC. I would like to know what is my mistake.
Thanks in advance.
Regards,
Vincent.
--
View this message in context: http://www.nabble.com/-xwiki-1.0-beta-3--Install---Wrapped-Exception-tf3149…
Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi everyone,
We're happy to announce the 1.0 Beta 3 release. It's a bug fix release.
Release note on: http://www.xwiki.org/xwiki/bin/view/Main/
ReleaseNotesXWiki10Beta3
Thanks and enjoy
-The XWiki Team
___________________________________________________________________________
Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface r�volutionnaire.
http://fr.mail.yahoo.com
Hi
is it me or the import feature is broken?
I can upload packages and they are listed under "select the file you wish to
import" but I can't get further. Clicking on a file name would not help.
There is no feedback for the interface either.
http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWi…
Regards,
Marc
Peter,
This was fixed in XWiki 1.0 Beta 1 as you've probably noticed by
now... ;-)
Thanks
-Vincent
On Jan 13, 2006, at 8:43 PM, Peter Flynn wrote:
> Spoke too soon… Looking at the source, the <img> tag at least is
> not deleted, but all the quotes in it have been escaped. So the
> tag turns into this:
>
>
>
> <img src="$xwiki.getAttachmentURL
> ('ContinuousSearch','itunes-unfiltered')" alt="" />
>
>
>
> This seems like a bug in the WYSIWYG editor—it should ever need to
> escape quote characters. Is there a way to make it stop doing this?
>
>
>
> - Peter
>
>
>
> From: Peter Flynn [mailto:pflynn@adobe.com]
> Sent: Wednesday, December 13, 2006 11:35 AM
> To: xwiki-users(a)objectweb.org
> Subject: [xwiki-users] WYSIWYG editor deletes content
>
>
>
> Hi everyone,
>
>
>
> We’re having some major issues with the WYSIWYG editor deleting
> content that it doesn’t understand when you save a page. For
> example, in order to link to an image on another page, we add
> something like this to the code:
>
>
>
> <img src=”$xwiki.getAttachmentURL(‘MyPage’,’my-image’)” />
>
>
>
> That works great, until you edit this page using the WYSIWYG
> editor. Savings your changes just deletes the whole tag. The page
> basically cannot be edited (other than as raw code) once it links
> to an image this way. We have the same issue with the <form> code
> suggested in the FAQ for document templates – you can’t edit the
> template page in WYSIWYG mode anymore because if you do, it’ll
> delete the form.
>
>
>
> Is there any way around this?
>
>
>
> - Peter
>
> <messagefooter.txt>