Open StinGer-ShoGuN opened 5 years ago
Hi,
that is a known issue.
Unfortunately, there are two problems with fixing this "properly". The first is mods. Any custom SQL they might use still could cause that error.
The second is that there are queries which are generated dynamically. Back when the issue first arose, I took a look at what needed to change, one thing lead to another and to another and...
So I'm a bit ashamed to admit that I opted for this option: https://github.com/evekb/evedev-kb/blob/4.4/install/templates/install_step1.tpl#L5
I will gladly accept any proper fixes, though!
Best Regards, Salvoxia
Huhu... never read that since I installed my KB... no I won't count. Which is the second sql-mode
configuration I gave.
I see the concern with the mods. I'd says it would be a great opportunity to clean them up a bit though... đŸ˜‹
The only "proper" solution then would be to analyse the queries to rewrite them when they are invalid. There might be a way to do so with MySQL directly, I don't know (I mean, it parses the query to give the error, so maybe we could get that error before actually executing the query).
Another consequence of my recent updates: now the main page of my killboard displays the following error message.
A solution is to set
sql-mode
inmy.cnf
.A maybe better solution, is the following instead.
An even better solution (i.e. the solution), would be to change the query to include kll_timestamp in the SELECT DISTINCT. It would require more adjustments in the code though. So in
common/includes/class.killlist.php
, on line 601 (at least, this is the one used for the homepage if I'm correct), change to this: