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