Re: [xwiki-users] 6.1 upgrade issue
You can try to manually alter the database, run this in Oracle: alter table xwiki.xwikidoc add XWD_HIDDEN number(1,0) DEFAULT 0 not null; Then restart XWiki. Hopefully you won't get this error anymore, although you might get another one. On 07/15/2014 05:12 PM, Hu Yang wrote: Hi, The errors are: Failed updating schema while executing query [alter table xwiki.xwikidoc add XWD_HIDDEN number(1,0) not null] Caused by: java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column Urgent, help please. Hu -Original Message- From: users [mailto:users-boun...@xwiki.org] On Behalf Of Hu Yang Sent: July-15-14 4:52 PM To: users@xwiki.org Subject: [xwiki-users] 6.1 upgrade issue Hi, I have upgrade our wiki to 6.1 today using war package, after start tomcat, the page shows: Xwiki is initializing (100%)... Not sure what's wrong here, no extra error log in tomcat. Help please, Hu Yang Senior Application Developer EDge Interactive | SchoolFinder Group E: hu.y...@edgeip.commailto:hu.y...@edgeip.com | P: 416-494-3343 ext. 201 | F: 416-494-0949 Toll-Free in North America: 1-800-211-5577 Toll-Free in North America: 1-800-211-5577 EDge Interactivehttp://www.edgeip.com| SchoolFinder.comhttp://www.schoolfinder.com | StudyinCanada.comhttp://www.studyincanada.com | ScholarshipsCanada.comhttp://www.scholarshipscanada.com/ | GradSchoolFinder.comhttp://www.gradschoolfinder.com/ -- Sergiu Dumitriu http://purl.org/net/sergiu ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] 6.1 upgrade issue
Hi, What version of XWiki are you ugrading from? Thanks -Vincent On 15 Jul 2014 at 23:12:40, Hu Yang (hu.y...@edgeip.com) wrote: Hi, The errors are: Failed updating schema while executing query [alter table xwiki.xwikidoc add XWD_HIDDEN number(1,0) not null] Caused by: java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column Urgent, help please. Hu -Original Message- From: users [mailto:users-boun...@xwiki.org] On Behalf Of Hu Yang Sent: July-15-14 4:52 PM To: users@xwiki.org Subject: [xwiki-users] 6.1 upgrade issue Hi, I have upgrade our wiki to 6.1 today using war package, after start tomcat, the page shows: Xwiki is initializing (100%)... Not sure what's wrong here, no extra error log in tomcat. Help please, Hu Yang ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] 6.1 upgrade issue
Hi Vincent, The developer installed wiki has left, I cannot find what version it is. Do you know how to check? Thanks, Hu From: Vincent Massol [mailto:vmas...@gmail.com] On Behalf Of vinc...@massol.net Sent: July-16-14 2:36 AM To: XWiki Users Cc: Hu Yang Subject: Re: [xwiki-users] 6.1 upgrade issue Hi, What version of XWiki are you ugrading from? Thanks -Vincent On 15 Jul 2014 at 23:12:40, Hu Yang (hu.y...@edgeip.commailto:hu.y...@edgeip.com) wrote: Hi, The errors are: Failed updating schema while executing query [alter table xwiki.xwikidoc add XWD_HIDDEN number(1,0) not null] Caused by: java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column Urgent, help please. Hu -Original Message- From: users [mailto:users-boun...@xwiki.org] On Behalf Of Hu Yang Sent: July-15-14 4:52 PM To: users@xwiki.orgmailto:users@xwiki.org Subject: [xwiki-users] 6.1 upgrade issue Hi, I have upgrade our wiki to 6.1 today using war package, after start tomcat, the page shows: Xwiki is initializing (100%)... Not sure what's wrong here, no extra error log in tomcat. Help please, Hu Yang ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] 6.1 upgrade issue
Hi, See http://www.xwiki.org/xwiki/bin/view/FAQ/How+can+I+find+the+version+of+XWiki+I%27m+running Thanks -Vincent PS: You may also want to look at getting some professional support, see http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport On 16 Jul 2014 at 14:41:49, Hu Yang (hu.y...@edgeip.com(mailto:hu.y...@edgeip.com)) wrote: Hi Vincent, The developer installed wiki has left, I cannot find what version it is. Do you know how to check? Thanks, Hu From: Vincent Massol [mailto:vmas...@gmail.com] On Behalf Of vinc...@massol.net Sent: July-16-14 2:36 AM To: XWiki Users Cc: Hu Yang Subject: Re: [xwiki-users] 6.1 upgrade issue Hi, What version of XWiki are you ugrading from? Thanks -Vincent On 15 Jul 2014 at 23:12:40, Hu Yang (hu.y...@edgeip.com(mailto:hu.y...@edgeip.com)) wrote: Hi, The errors are: Failed updating schema while executing query [alter table xwiki.xwikidoc add XWD_HIDDEN number(1,0) not null] Caused by: java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column Urgent, help please. Hu -Original Message- From: users [mailto:users-boun...@xwiki.org] On Behalf Of Hu Yang Sent: July-15-14 4:52 PM To: users@xwiki.org(mailto:users@xwiki.org) Subject: [xwiki-users] 6.1 upgrade issue Hi, I have upgrade our wiki to 6.1 today using war package, after start tomcat, the page shows: Xwiki is initializing (100%)... Not sure what's wrong here, no extra error log in tomcat. Help please, Hu Yang ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] 6.1 upgrade issue
Hi Vincent, We are on version 1.4.1. Is it too old for upgrade, should I upgrade to some other version first? Thanks, Hu -Original Message- From: Vincent Massol [mailto:vmas...@gmail.com] On Behalf Of vinc...@massol.net Sent: July-16-14 9:30 AM To: XWiki Users Cc: Hu Yang Subject: RE: [xwiki-users] 6.1 upgrade issue Hi, See http://www.xwiki.org/xwiki/bin/view/FAQ/How+can+I+find+the+version+of+XWiki+I%27m+running Thanks -Vincent PS: You may also want to look at getting some professional support, see http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport On 16 Jul 2014 at 14:41:49, Hu Yang (hu.y...@edgeip.com(mailto:hu.y...@edgeip.com)) wrote: Hi Vincent, The developer installed wiki has left, I cannot find what version it is. Do you know how to check? Thanks, Hu From: Vincent Massol [mailto:vmas...@gmail.com] On Behalf Of vinc...@massol.net Sent: July-16-14 2:36 AM To: XWiki Users Cc: Hu Yang Subject: Re: [xwiki-users] 6.1 upgrade issue Hi, What version of XWiki are you ugrading from? Thanks -Vincent On 15 Jul 2014 at 23:12:40, Hu Yang (hu.y...@edgeip.com(mailto:hu.y...@edgeip.com)) wrote: Hi, The errors are: Failed updating schema while executing query [alter table xwiki.xwikidoc add XWD_HIDDEN number(1,0) not null] Caused by: java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column Urgent, help please. Hu -Original Message- From: users [mailto:users-boun...@xwiki.org] On Behalf Of Hu Yang Sent: July-15-14 4:52 PM To: users@xwiki.org(mailto:users@xwiki.org) Subject: [xwiki-users] 6.1 upgrade issue Hi, I have upgrade our wiki to 6.1 today using war package, after start tomcat, the page shows: Xwiki is initializing (100%)... Not sure what's wrong here, no extra error log in tomcat. Help please, Hu Yang ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] 6.1 upgrade issue
Hi, The errors are: Failed updating schema while executing query [alter table xwiki.xwikidoc add XWD_HIDDEN number(1,0) not null] Caused by: java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column Urgent, help please. Hu -Original Message- From: users [mailto:users-boun...@xwiki.org] On Behalf Of Hu Yang Sent: July-15-14 4:52 PM To: users@xwiki.org Subject: [xwiki-users] 6.1 upgrade issue Hi, I have upgrade our wiki to 6.1 today using war package, after start tomcat, the page shows: Xwiki is initializing (100%)... Not sure what's wrong here, no extra error log in tomcat. Help please, Hu Yang Senior Application Developer EDge Interactive | SchoolFinder Group E: hu.y...@edgeip.commailto:hu.y...@edgeip.com | P: 416-494-3343 ext. 201 | F: 416-494-0949 Toll-Free in North America: 1-800-211-5577 Toll-Free in North America: 1-800-211-5577 EDge Interactivehttp://www.edgeip.com| SchoolFinder.comhttp://www.schoolfinder.com | StudyinCanada.comhttp://www.studyincanada.com | ScholarshipsCanada.comhttp://www.scholarshipscanada.com/ | GradSchoolFinder.comhttp://www.gradschoolfinder.com/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
