SQL Error: 1044, SQLState: 42000

Help / Discuss
#1

Hi team,

I’m using XWiki 12.5 and the log will continously show the following errors. Would you please check why the errors occur and how to solve it?

Thanks in advance.

2020-07-01 10:46:42,939 [org.xwiki.rendering.async.internal.AsyncRendererJob@4a999f6b([uix, xwiki:Help.TipsPanel.WebHome, author, xwiki:XWiki.Bill, locale, zh_CN, secureDocument, xwiki:Help.TipsPanel.WebHome, 30])] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2020-07-01 10:46:42,939 [org.xwiki.rendering.async.internal.AsyncRendererJob@4a999f6b([uix, xwiki:Help.TipsPanel.WebHome, author, xwiki:XWiki.Bill, locale, zh_CN, secureDocument, xwiki:Help.TipsPanel.WebHome, 30])] ERROR o.h.e.j.s.SqlExceptionHelper   - (conn=15) Could not select database ' http' : Access denied for user 'xwiki'@'localhost' to database ' http' 
2020-07-01 10:46:52,778 [org.xwiki.rendering.async.internal.AsyncRendererJob@ea33b10([uix, xwiki:Help.TipsPanel.WebHome, author, xwiki:XWiki.Bill, locale, zh_CN, secureDocument, xwiki:Help.TipsPanel.WebHome, 34])] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2020-07-01 10:46:52,778 [org.xwiki.rendering.async.internal.AsyncRendererJob@ea33b10([uix, xwiki:Help.TipsPanel.WebHome, author, xwiki:XWiki.Bill, locale, zh_CN, secureDocument, xwiki:Help.TipsPanel.WebHome, 34])] ERROR o.h.e.j.s.SqlExceptionHelper   - (conn=27) Could not select database ' http' : Access denied for user 'xwiki'@'localhost' to database ' http'
#2

Looks like a problem in the Tips Panel with some content has a URL and the wiki syntax makes the rendering believe there’s a reference to a subwiki named “http”.

I’ll check it out. Please raise a jira issue for this. And then it fails with the mentioned error because your DB is not configured properly to support creating subwikis.

#3

What is your wiki’s language?

#4

Note that I’ve just fixed https://jira.xwiki.org/browse/XWIKI-17495 and noticed there was a bug with the zh language translations. Could that be your language?

#5

Yes, zh is my language.
So it will be fixed in 12.6, right?

#6

Yes in 12.6 but you can fix it yourself too. It’s a bug done by the zh translator.

You need to edit the zh translation of Help.Translations as done here: https://github.com/xwiki/xwiki-platform/commit/e87e30bf08d529d8a38c3a584bb0b939ebf5cf1f#diff-9eda17d022584d313fb9d03881eecf00R40-R48

The important part is to remove the extra spaces.

#7

Thanks a lot.