Database error when trying to access any wiki page.

By _ThEcRoW

Expert (110)

_ThEcRoW의 아바타

16-09-2020, 15:15

Hello, i recently noticed that wherever i try to access the wiki for info, from this site or referenced from the web, i get an strange database error and cannot access the pages. Anyone know what could be causing that?.
The error in quewstion is this:

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "User::addToDatabase". Database returned error "1062: Duplicate entry ' ThEcRoW' for key 'user_name' (localhost)".

Thanks in advance!!!

Login or 등록 to post comments

By _ThEcRoW

Expert (110)

_ThEcRoW의 아바타

28-09-2020, 15:20

No one has this problem??

By Sylvester

Champion (490)

Sylvester의 아바타

28-09-2020, 15:42

I think your username is the problem, the underscore is a wildcard in MySQL and if you don't escape it in your queries, you will get some strange results. Try renaming your username to something without the underscore or wait till somebody fixes it in the website code Smile

By Meits

Scribe (6133)

Meits의 아바타

28-09-2020, 19:41

i remember having had that a while ago as well, but only when i was logged in.
there's no underscore in my name, but if you want to, i can remove yours (send me a mail if you want that).
try another browser as well (or throw away your cookies in your current one). that fixed some issues here as well.

By _ThEcRoW

Expert (110)

_ThEcRoW의 아바타

07-10-2020, 15:41

This weekend i discovered that(the login issue). It happened that while i was logged out, i tried to access the wiki and then worked. I was oO . At the moment i´m logging out whenever i need to access the wiki data.
Thanks for the help!!!

By Pencioner

Scribe (1279)

Pencioner의 아바타

07-10-2020, 15:57

You can use the 'private window' feature modern browser have so you don't have to log out btw...

By ren

Paragon (1635)

ren의 아바타

07-10-2020, 16:53

Certain searches also give query (Apache Solr) errors Smile

Private window, or make use of Firefox containers (you'll keep your history etc. then).

So you can login with _ThEcRoW on the site/forum? Note that the id in your profile link is thecrow-0, perhaps logging in with that works as well, and will work for the wiki (though I doubt it: it seems to (try to) register an user with the display username).

Another issue you can experience is: you're logged in on the site, can access the wiki, but are not logged in on the latter. Then try to log out & in again.

Btw, isn't an underscore a wildcard in LIKE expressions only? Would be kinda weird if that is used to find a matching username.. Note that in the error report there's a space instead of an underscore...