Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Console warnings and errors #46

Closed
ane-gabriela opened this issue Jan 29, 2019 · 5 comments
Closed

Console warnings and errors #46

ane-gabriela opened this issue Jan 29, 2019 · 5 comments
Assignees
Milestone

Comments

@ane-gabriela
Copy link

ane-gabriela commented Jan 29, 2019

Steps to reproduce:

  1. Log in as Admin
  2. Create a Forum, Topic, Answer Comment
  3. Log in as a simple user
  4. Create a Forum, Topic, Answer Comment

Expected results: All pages are created as expected.

Actual results: All pages are created but some Warnings and Errors appear in the Console.

Environment: Windows 10, XWiki 10.11.2 Standard Version, Edge 18 - the forum was installed on Farm (2 other subwikis included)

2019-01-29 19:19:12,615 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.script.RefactoringScriptService.createRenameRequest] in 75:xwiki:ForumCode.Actions@196,46 2019-01-29 19:19:12,617 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.job.MoveRequest.setDeleteSource] in 75:xwiki:ForumCode.Actions@197,33 2019-01-29 19:19:27,941 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.script.RefactoringScriptService.createRenameRequest] in 73:xwiki:ForumCode.Actions@196,46 2019-01-29 19:19:27,942 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.job.MoveRequest.setDeleteSource] in 73:xwiki:ForumCode.Actions@197,33 2019-01-29 19:19:33,779 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] WARN o.h.u.JDBCExceptionReporter - SQL Error: -4850, SQLState: 3F000 2019-01-29 19:19:33,780 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] ERROR o.h.u.JDBCExceptionReporter - invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI 2019-01-29 19:19:33,781 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] WARN c.x.x.a.XWiki - Failed to access document [{{html clean="false" wiki="false"}} <ul class="users"><li class="user" data-reference="xwiki:XWiki.Admin"><img class="user-avatar" src="/xwiki/bin/skin/resources/icons/xwiki/noavatar.png" alt="Administrator" /><a class="user-name" href="/xwiki/bin/view/XWiki/Admin">Administrator</a></li></ul> {{/html}}]. Root reason: [HsqlException: invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI] 2019-01-29 19:19:33,795 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] WARN o.h.u.JDBCExceptionReporter - SQL Error: -4850, SQLState: 3F000 2019-01-29 19:19:33,796 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] ERROR o.h.u.JDBCExceptionReporter - invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI 2019-01-29 19:19:33,797 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] WARN c.x.x.XWiki - Failed to display the user name of [{{html clean="false" wiki="false"}} <ul class="users"><li class="user" data-reference="xwiki:XWiki.Admin"><img class="user-avatar" src="/xwiki/bin/skin/resources/icons/xwiki/noavatar.png" alt="Administrator" /><a class="user-name" href="/xwiki/bin/view/XWiki/Admin">Administrator</a></li></ul> {{/html}}]. Root cause is [HsqlException: invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI]. Falling back on the user id. 2019-01-29 19:19:33,808 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] WARN o.h.u.JDBCExceptionReporter - SQL Error: -4850, SQLState: 3F000 2019-01-29 19:19:33,809 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] ERROR o.h.u.JDBCExceptionReporter - invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI 2019-01-29 19:19:33,809 [http://localhost:8080/xwiki/bin/view/Forums/Admin%20Forum/Admin.Topic/] WARN c.x.x.XWiki - Failed to display the user name of [{{html clean="false" wiki="false"}} <ul class="users"><li class="user" data-reference="xwiki:XWiki.Admin"><img class="user-avatar" src="/xwiki/bin/skin/resources/icons/xwiki/noavatar.png" alt="Administrator" /><a class="user-name" href="/xwiki/bin/view/XWiki/Admin">Administrator</a></li></ul> {{/html}}]. Root cause is [HsqlException: invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI]. Falling back on the user id. 2019-01-29 19:21:42,500 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.script.RefactoringScriptService.createRenameRequest] in 14:xwiki:ForumCode.Actions@196,46 2019-01-29 19:21:42,500 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.job.MoveRequest.setDeleteSource] in 14:xwiki:ForumCode.Actions@197,33 2019-01-29 19:21:50,901 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.script.RefactoringScriptService.createRenameRequest] in 13:xwiki:ForumCode.Actions@196,46 2019-01-29 19:21:50,901 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.job.MoveRequest.setDeleteSource] in 13:xwiki:ForumCode.Actions@197,33 2019-01-29 19:21:56,147 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] WARN o.h.u.JDBCExceptionReporter - SQL Error: -4850, SQLState: 3F000 2019-01-29 19:21:56,147 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] ERROR o.h.u.JDBCExceptionReporter - invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI 2019-01-29 19:21:56,148 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] WARN c.x.x.a.XWiki - Failed to access document [{{html clean="false" wiki="false"}} <ul class="users"><li class="user" data-reference="xwiki:XWiki.user01"><img class="user-avatar" src="/xwiki/bin/skin/resources/icons/xwiki/noavatar.png" alt="user01" /><a class="user-name" href="/xwiki/bin/view/XWiki/user01">user01</a></li></ul> {{/html}}]. Root reason: [HsqlException: invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI] 2019-01-29 19:21:56,161 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] WARN o.h.u.JDBCExceptionReporter - SQL Error: -4850, SQLState: 3F000 2019-01-29 19:21:56,162 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] ERROR o.h.u.JDBCExceptionReporter - invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI 2019-01-29 19:21:56,162 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] WARN c.x.x.XWiki - Failed to display the user name of [{{html clean="false" wiki="false"}} <ul class="users"><li class="user" data-reference="xwiki:XWiki.user01"><img class="user-avatar" src="/xwiki/bin/skin/resources/icons/xwiki/noavatar.png" alt="user01" /><a class="user-name" href="/xwiki/bin/view/XWiki/user01">user01</a></li></ul> {{/html}}]. Root cause is [HsqlException: invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI]. Falling back on the user id. 2019-01-29 19:21:56,175 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] WARN o.h.u.JDBCExceptionReporter - SQL Error: -4850, SQLState: 3F000 2019-01-29 19:21:56,175 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] ERROR o.h.u.JDBCExceptionReporter - invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI 2019-01-29 19:21:56,176 [http://localhost:8080/xwiki/bin/view/Forums/User%20Forum/User%20Topic/] WARN c.x.x.XWiki - Failed to display the user name of [{{html clean="false" wiki="false"}} <ul class="users"><li class="user" data-reference="xwiki:XWiki.user01"><img class="user-avatar" src="/xwiki/bin/skin/resources/icons/xwiki/noavatar.png" alt="user01" /><a class="user-name" href="/xwiki/bin/view/XWiki/user01">user01</a></li></ul> {{/html}}]. Root cause is [HsqlException: invalid schema name: {{HTML CLEAN="FALSE" WIKI="FALSE"}} <UL CLASS="USERS"><LI CLASS="USER" DATA_REFERENCE="XWIKI]. Falling back on the user id.

@ane-gabriela
Copy link
Author

Also getting this quite often:
2019-01-31 12:03:32,667 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.script.RefactoringScriptService.createRenameRequest] in 70:xwiki:ForumCode.Actions@196,46 2019-01-31 12:03:32,668 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.job.MoveRequest.setDeleteSource] in 70:xwiki:ForumCode.Actions@197,33 2019-01-31 12:03:39,933 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.script.RefactoringScriptService.createRenameRequest] in 71:xwiki:ForumCode.Actions@196,46 2019-01-31 12:03:39,934 [http://localhost:8080/xwiki/bin/view/ForumCode/Actions] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [org.xwiki.refactoring.job.MoveRequest.setDeleteSource] in 71:xwiki:ForumCode.Actions@197,33

@ilieandriuta
Copy link
Collaborator

ilieandriuta commented Mar 6, 2019

I've reproduced the issue too, testing on XWiki 11.1 (Firefox 65, PostgreSQL 10). In addition, the user avatar on the comment is not displayed (was displayed properly on the answer above it):

image

Stacktrace: Stacktrace.txt

Please also see #34.

@acotiuga acotiuga modified the milestones: 2.6, 3.0 Mar 14, 2019
@ane-gabriela
Copy link
Author

Getting some new errors when accessing the Forum app on XWiki 11.5

2019-07-22 14:16:48,907 [XWiki Solr index thread] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of getter [com.xpn.xwiki.api.Document.getName] in 64:xwiki:ForumCode.ForumSheet@1,10 2019-07-22 14:17:28,304 [http://localhost:8080/xwiki/bin/get/ForumCode/GetForumsJson?outputSyntax=plain&transprefix=conversations.&classname=ForumCode.ForumClass&collist=doc.title%2Cdoc.date%2Cdoc.creator%2Cactions&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=doc.title&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?))] has been converted to [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3))] 2019-07-22 14:17:28,325 [http://localhost:8080/xwiki/bin/get/ForumCode/GetForumsJson?outputSyntax=plain&transprefix=conversations.&classname=ForumCode.ForumClass&collist=doc.title%2Cdoc.date%2Cdoc.creator%2Cactions&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=doc.title&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?))] has been converted to [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3))] 2019-07-22 14:17:28,339 [http://localhost:8080/xwiki/bin/get/ForumCode/GetForumsJson?outputSyntax=plain&transprefix=conversations.&classname=ForumCode.ForumClass&collist=doc.title%2Cdoc.date%2Cdoc.creator%2Cactions&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=doc.title&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select doc.fullName from XWikiDocument doc , BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?) )) order by lower(doc.title) asc, doc.title asc] has been converted to [select doc.fullName from XWikiDocument doc , BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3) )) order by lower(doc.title) asc, doc.title asc] 2019-07-22 14:17:28,345 [http://localhost:8080/xwiki/bin/get/ForumCode/GetForumsJson?outputSyntax=plain&transprefix=conversations.&classname=ForumCode.ForumClass&collist=doc.title%2Cdoc.date%2Cdoc.creator%2Cactions&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=doc.title&dir=asc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select count(doc.fullName) from XWikiDocument doc , BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?) )) ] has been converted to [select count(doc.fullName) from XWikiDocument doc , BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3) )) ]

@acotiuga
Copy link

acotiuga commented Aug 28, 2019

There is a remaining deprecation usage to be fixed in #72: RefactoringScriptService#createRenameRequest() + MoveRequest#setDeleteSource().

@acotiuga
Copy link

The rest of the logs were caused by the livetable and were fixed in platform.

@acotiuga acotiuga self-assigned this Aug 28, 2019
acotiuga added a commit that referenced this issue Aug 28, 2019
@acotiuga acotiuga modified the milestones: 3.0, 2.6.1 Aug 28, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants