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. bb3eefb3622e864ad480641f281d4a2e4be50a69] (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