Bugs with maps

[4F-Beep]

Congratulations for your work

Describe the bug
Bug with maps
Impossible to play some maps
i can add them
i can juke them
But i cant play them, they stay in jukebox

In log file, there's an error
[09:06:32] Hook->execute(): Exception: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'evosc.pbs.score' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select players.id, Login, Rating, Map, pbs.Score from players left join mx-karma on mx-karma.Player = players.id and mx-karma.Map = 44 left join pbs on pbs.player_id = players.id where players.id in (17) group by players.id, Login, Rating, Map)

Expected behavior
Explain what should have happened, or not.

To Reproduce
Please explain what led to the issue.
Example:
evosc_2021-05-15.txt

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Screenshots/Logs
If any available, add screenshots/logs to help explain your problem.

EvoSC (please complete the following information):

• EvoSC-Version: 0.99.7
• Game: TM2020

When using git (please complete the following information):

• Current-Commit: [e.g. bb3eefb] (get with git rev-parse HEAD)

[4F-Beep]

Server is ok without evosc

The problem is about my evosc

What you do you think about that?

Thanks for answer

[snixtho]

Your EvoSC version (0.99.7) is several months old, what happens if you update to the latest version, 0.99.22?

[4F-Beep]

Thanks for your answer

I updated with "git pull"

Now, I have PHP fatal error

[4F-Beep]

Here's the terminal
..................................................PHP Fatal error: Uncaught Error: Class 'Mexitek\PHPColors\Color' not found in /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Engine.php(190) : eval()'d code:98
Stack trace:
#0 /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Runtime/Template.php(205): Templatee33b184567->main()
#1 /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Runtime/Template.php(247): Latte\Runtime\Template->render()
#2 /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Runtime/Template.php(351): Latte\Runtime\Template->Latte\Runtime{closure}()
#3 /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Runtime/Template.php(250): Latte\Runtime\Template->filter()
#4 /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Engine.php(190) : eval()'d code(17): Latte\Runtime\Template->renderToContentType()
#5 /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Runtime/Template.php(205): Templatef5bf56786f->main()
#6 /home/sebastien/Bureau/TMserver/EvoSC in /home/sebastien/Bureau/TMserver/EvoSC/vendor/latte/latte/src/Latte/Engine.php(190) : eval()'d code on line 98

[araszka]

You may want to call composer install --no-dev -o after pulling, to make sure you have all required packages installed.

[4F-Beep]

Big thanks

[4F-Beep]

But maps are not played

server is ok without evoSC

When EvoSC is running some maps cant be played :(

[4F-Beep]

Someone have an idea about these maps not played?
Without evoSC, maps rotation is ok.

[4F-Beep]

Here's error in log file
[09:06:32] Hook->execute(): Exception: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'evosc.pbs.score' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select players.id, Login, Rating, Map, pbs.Score from players left join mx-karma on mx-karma.Player = players.id and mx-karma.Map = 44 left join pbs on pbs.player_id = players.id where players.id in (17) group by players.id, Login, Rating, Map)

Someone know what's is the problem?
txt file is on top of thread

[4F-Beep]

Nobody knows about this error.

Need help :)

Thanks for return

[snixtho]

Which version of MySQL do you use?

[araszka]

Please try with the latest develop version

[4F-Beep]

thx for return,
i dont know about version, i installed automaticly with linux
i ll try with the next

[4F-Beep]

version (); donne
8.0.23 - ubuntu 20.04.1