February 2007 - xwiki-users@xwiki.org

xwiki : loading pages problem
by Julien Oix 05 Feb '07

05 Feb '07

hi everyone, I managed to deploy successfully a xwiki with Apache/Tomcat/mod_jk container thanks to this help (http://mail-archive.objectweb.org/xwiki-users/2007-01/msg00179.html :) after configuration for needs, I notice that browsing the wiki with firefox and the "html validator" extension : ** loading a page entirely needs much time (the content is loaded immediatly but the loading icon runs a few seconds before stopping). ** the html validator extension tells me that "html cache is empty", it can't analyse errors and warnings. ** this doesn't happen on the login page, only on pages with content, accessible after logon. Could it be a Apache user's permission problem ? Anything else ? Thanks. -- Julien Oix UFR d'Informatique - Université Paris Diderot Bureau 5C01 (5ème étage) 175 rue du Chevaleret 75013 PARIS Tel : +33 (0) 144 278 504 Mobile : +33 (0) 664 392 207 --------------------------------------------- http://www.gnu.org/philosophy/no-word-attachments.html

3 6

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by Dandre 05 Feb '07

05 Feb '07

This is what I found in the Postgres serverlog file: (Sorry that it is so long) LOG: database system was shut down at 2007-02-05 14:37:48 SAST LOG: checkpoint record is at 0/5825D640 LOG: redo record is at 0/5825D640; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 0/7259; next OID: 295714 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system is ready NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_aggregatorgroup_pkey" for table "feeds_aggregatorgroup" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_aggregatorurl_pkey" for table "feeds_aggregatorurl" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_aggregatorurlgroups_pkey" for table "feeds_aggregatorurlgroups" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_feedentry_pkey" for table "feeds_feedentry" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_feedentrytags_pkey" for table "feeds_feedentrytags" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_keyword_pkey" for table "feeds_keyword" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "xwikicomments_pkey" for table "xwikicomments" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "xwikilinks_pkey" for table "xwikilinks" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "xwikipreferences_pkey" for table "xwikipreferences" ERROR: update or delete on table "xwikiproperties" violates foreign key constraint "fkdf25ae4f283ee295" on table "xwikilongs" DETAIL: Key (xwp_id,xwp_name)=(-1531382335,editbox_width) is still referenced from table "xwikilongs". STATEMENT: delete from xwikiproperties where xwp_name like 'editbox_%' and xwp_classtype='com.xpn.xwiki.objects.LongProperty' ERROR: column xwikidocum0_.xwd_title does not exist at character 118 STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 ERROR: column xwikidocum0_.xwd_title does not exist at character 118 STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 ERROR: column xwikidocum0_.xwd_title does not exist at character 118 STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 ERROR: column xwikidocum0_.xwd_title does not exist at character 118 STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 ERROR: column xwikidocum0_.xwd_title does not exist at character 118 STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 ERROR: column xwikidocum0_.xwd_title does not exist at character 118 STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_aggregatorgroup_pkey" for table "feeds_aggregatorgroup" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_aggregatorurl_pkey" for table "feeds_aggregatorurl" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_aggregatorurlgroups_pkey" for table "feeds_aggregatorurlgroups" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_feedentry_pkey" for table "feeds_feedentry" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_feedentrytags_pkey" for table "feeds_feedentrytags" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "feeds_keyword_pkey" for table "feeds_keyword" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "xwikicomments_pkey" for table "xwikicomments" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "xwikilinks_pkey" for table "xwikilinks" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "xwikipreferences_pkey" for table "xwikipreferences" ERROR: update or delete on table "xwikiproperties" violates foreign key constraint "fkdf25ae4f283ee295" on table "xwikilongs" DETAIL: Key (xwp_id,xwp_name)=(-1531382335,editbox_width) is still referenced from table "xwikilongs". STATEMENT: delete from xwikiproperties where xwp_name like 'editbox_%' and xwp_classtype='com.xpn.xwiki.objects.LongProperty' ERROR: current transaction is aborted, commands ignored until end of transaction block STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_ARCHIVE as XWD23_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 ERROR: column xwikidocum0_.xwd_title does not exist at character 118 STATEMENT: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=$1 It keeps on referencing to tables and columns that doesn't exist, it adds "_0" 's the whole time. Regards, Dandre

1 0

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by Dandre 05 Feb '07

05 Feb '07

Oh, wait I saw it now. I did a SELECT statement in SQuirreL and I saw that it only limited the tables to 100 from 600 and something. Still, XWiki so far only has a problem opening up XWiki.XWikiPreferences. Regards, Dandre

1 0

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by Dandre 05 Feb '07

05 Feb '07

@teh stu: > But I wasn't upgrading from a Postgre DB, it was a MySQL 4.1. > Problem was that it didn't work with the new Code (1.0B3) and developers > suggested I change the DB to MySQL 5. I know, I was just saying that MySQL 5 works but I was experiencing problems with PostgreSQL. @Everyone else: ;-) I saw something interesting in my DB. In the old XWiki you still have a XWiki.XWikiPreferences document. Now I think the reason why the new XWiki isn't seeing it is because the DB viewers doesn't see it. I can do a SQL statement and it will popup from the xwikidoc table but open it up with SQuirreL or webmin (I also tried to view it in Postgres's psql app but it was totally mixed up due to the table's data size), then it doesn't appear to be in the xwikidoc table. Anyone have any idea how to fix this? I tried deleting the XWikiPreferences and adding it again but it won't show. Could it be a reference problem or something? Thanks Regards, Dandre

1 0

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by Dandre 05 Feb '07

05 Feb '07

Hi Rudolf, Yeah I did what you said and it worked for the dummy DB I've setup earlier today. When I cleaned up everything and added our production DB, and applying what you said, it still gave me the same error as what I experienced last week and the week before. Aparently I am missing a XWiki.XWikiPreferences Document. You can get the error messages here: http://www.objectweb.org/wws/arc/xwiki-users/2007-01/msg00242.html Regards, Dandre

2 1

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by Dandre 05 Feb '07

05 Feb '07

Hey VanderLeeden! Thanks for your advice. I can confirm your story that I have started up with a dummy DB and by upgrading to Postgres 8.2.1, and applying that ALTER TABLE statement really did the trick! Now I have to do it with our real DB! ;-) Thanks again man! Regards, Dandre

2 1

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by Dandre 05 Feb '07

05 Feb '07

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

2 1

authenticated RSS Read
by Uwe Kleinschmidt 04 Feb '07

04 Feb '07

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

1 0

how to build wiki-1.0-beta-3.xar via sources?
by zoke-xwiki＠zoke.de 04 Feb '07

04 Feb '07

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

2 1

Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by VanderLeeden 02 Feb '07

02 Feb '07

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)

1 0