search

StAwN74 / ckSurf-1.18kd-Release

Last seen version of a great plugin, server crash fixed.
9 stars 4 forks source link

SQL Error (sql_CountFinishedBonusCallback) #4

Open ghost opened 4 years ago

ghost commented 4 years ago

Hi,

I got and SQL error sometimes in the addons/sourcemod/logs/errors_*** log

Plugin: ckSurf_slh_rev.smx - (02/06/20 version) Metamod: Source version 1.10.7-dev SourceMod Version: 1.10.0.6488 MySQL (Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64)

SourceMod error session started L 06/08/2020 - 19:38:45: Info (map "workshop/156054906/surf_utopia_v3") (file "/home/cs/surf/serverfiles/csgo/addons/sourcemod/logs/errors_20200608.log")

L 06/08/2020 - 19:38:45: [ckSurf_slh_rev.smx] [ckSurf] SQL Error (sql_CountFinishedBonusCallback): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, (SELECT count(1) FROM ck_bonus b WHERE a.mapname = b.mapname AND a.zonegro' at line 1

L 06/08/2020 - 19:40:23: [ckSurf_slh_rev.smx] [ckSurf] SQL Error (sql_CountFinishedBonusCallback): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, (SELECT count(1) FROM ck_bonus b WHERE a.mapname = b.mapname AND a.zonegro' at line 1

L 06/08/2020 - 19:41:37: [ckSurf_slh_rev.smx] [ckSurf] SQL Error (sql_CountFinishedBonusCallback): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, (SELECT count(1) FROM ck_bonus b WHERE a.mapname = b.mapname AND a.zonegro' at line 1

L 06/08/2020 - 19:43:19: Error log file session closed.

If you need more info, do not hesitate to ask me.

ghost commented 4 years ago

https://stackoverflow.com/questions/54343203/mysql-8-nested-select-with-count

StAwN74 commented 4 years ago

Thx Enghausen, I just can't find how to correct, I use Sql and it works fine even with special chars. Plus, the stackoverflow advice you give, seems ok but it concerns fluffy's fork, there is no such error in my version, with %i that should be written with quotes: '%i'. The only %i char left is for the zonegroups, and it is intentional. Maybe we should change line 180: SQL_FastQuery(g_hDb, "SET NAMES 'utf8'"); with utf8mb4 ?

StAwN74 commented 4 years ago

Done. Seems to work by just changing line 180 of sql according to Freak.

freakexeuLow commented 4 years ago

Seems like he has a error in hes MySQL Database Syntax. This can happen when things have been changed in the database. i have changed my database from utf8 times to utf8mb4 + changed the entries in the database (all tables) to utf8mb4_unicode and have no problems (but didn't use MySQL 8 either) maybe there is a new syntax here that doesn't recognize the old one?

ghost commented 4 years ago

Hi, I had to move to another hosting provider and changed from LGSM to Pterodactyl Panel. I also chaged from MySQL to MariaDB - I can not recreate this error now!

MariaDB Version: Ver 15.1 Distrib 10.4.13-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Cksurf: Latest from 17-06-2020

/Cheers

freakexeuLow commented 4 years ago

Hi, I had to move to another hosting provider and changed from LGSM to Pterodactyl Panel. I also chaged from MySQL to MariaDB - I can not recreate this error now!

MariaDB Version: Ver 15.1 Distrib 10.4.13-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Cksurf: Latest from 17-06-2020

/Cheers

then try to fix your database of cksurf, it's not due to cksurf as said :3

'rank, (SELECT count(1) FROM ck_bonus b WHERE a.mapname = b.mapname AND a.zonegro' at line 1