Hi Fabian, On Feb 6, 2007, at 8:29 PM, Fabian Gorsler wrote:
Hi,
I finally managed the update from XWiki 0.9.840 to 1.0b3 running on Postgres 8.1. :-) For my situation two SQL commands were necessary in order to have a pretty nice 1.0b3 instance.
1) Have a look at the xwikilongs-table. Write down the row for upload_maxsize. Later you will have to insert the whole row. 2) DELETE FROM xwikilongs; (Be careful!) 3) Deploy the new XWiki version and configure your database in hibernate.cfg.xml. 4) Start the context and access your WebHome. Hibernate will update your database layout, but you will receive a exception, because XWiki can't find your configuration setting for upload_maxsize...;-) 5) INSERT INTO xwikilongs VALUES(PK_OF_THE_PARAM, 'upload_maxsize', VALUE_OF_THE_PARAM); (Replace PK_OF_THE_PARAM and VALUE_OF_THE_PARAM with your values.) 6) Have fun with your upgraded XWiki! :-D
Today I have done this procedure twice in order to be sure that it works and both times it worked without any problems. After upgrading I did some tests (attaching files, browsing, etc.) and everything worked really fine.
That's really cool, thanks. Now the next step is to prevent users from having to do this at all I think... We have an updateSchema() method in the XWikiHibernateBaseStore class. Does anyone know why steps 1) and 5) have to be done for it to work with PostGreSQL? Is that something we could add in updateSchema()?
One thing everyone should consider to do: Go to your XWiki directory and delete the skins/default folder in order to replace it with skins/xwiki10b1 in order to have the new skin. Only with the new skin you can access new features like the improved settings editor and so on. If you did not use the default skin with your old XWiki, have a look at the database and run an UPDATE on xwikiprefs.xwd_skin (I think thats the right table/column. I forgot to write it down...).
AFAIK the easiest way to change the skin is to log in as admin, edit your wiki preferences and under skin, use xwiki10b1.
PS: Thanks a lot XWiki-devs and go for the release! After testing this beta release, we now know more than ever that XWiki was the right choice for us! Great work!
Thanks for the kind words and thanks for fixing the PostGreSQL issue! Lots of users are going to praise you :-) -Vincent ___________________________________________________________________________ Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface r�volutionnaire. http://fr.mail.yahoo.com