Database error when trying to access any wiki page.

Por _ThEcRoW

Expert (107)

imagem de _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!!!

Entrar ou registrar-se para comentar

Por _ThEcRoW

Expert (107)

imagem de _ThEcRoW

28-09-2020, 15:20

No one has this problem??

Por Sylvester

Champion (465)

imagem de 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

Por Meits

Scribe (6051)

imagem de 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.

Por _ThEcRoW

Expert (107)

imagem de _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!!!

Por Pencioner

Scribe (1207)

imagem de 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...

Por ren

Paragon (1532)

imagem de 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...