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.com<mailto: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 Interactive<http://www.edgeip.com>| 
> SchoolFinder.com<http://www.schoolfinder.com> | 
> StudyinCanada.com<http://www.studyincanada.com> | 
> ScholarshipsCanada.com<http://www.scholarshipscanada.com/> | 
> GradSchoolFinder.com<http://www.gradschoolfinder.com/>


-- 
Sergiu Dumitriu
http://purl.org/net/sergiu
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to