xwiki-users

xwiki-users@xwiki.org

10408 discussions

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

by Dandre

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

17 years, 11 months

authenticated RSS Read

by Uwe Kleinschmidt

The only way to establish an authenticated RSS Read with XWiki (XWiki <http://www.xwiki.org> Version 1.0b1.1663b <http://motorimmune.xwiki.com/xwiki/bin/view/Main/> ) I thought is to use http://username:password@mywiki.xwiki.com/xwiki/bin/view/Main/BlogRss?xpage= rdf. It doesn't work though. Can somebody help me, how to create an authenticated RSS Feed with XWiki? Thanks Uwe

17 years, 11 months

how to build wiki-1.0-beta-3.xar via sources?

by zoke-xwiki＠zoke.de

How to build xwiki.xar via the sources? Downloading is currently broken and i would like to start :) Markus

17 years, 11 months

Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

by VanderLeeden

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)

17 years, 11 months

1.0beta2 cannot auto create some tables in Oracle 10

by feixingyu99＠hotmail.com

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

17 years, 11 months

Re: Moving from PostgreSQL to MySQL

by Dandre

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

17 years, 11 months

Re: Moving from PostgreSQL to MySQL

by 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

17 years, 11 months

Re: Moving from PostgreSQL to MySQL

by Dandre

Ok, so far so good. The plugin seems to work. Now I am really gonna put it through the test ;-) Wish me luck! :-D Regards, Dandre

17 years, 11 months

Moving from PostgreSQL to MySQL

by 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

17 years, 11 months

Debugging XWiki

by 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

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