[Error] Timer (WR Holder Rank table creation 0/4) SQL query failed.

Plugin Version:3.0.8

Database Version: Mysql 8.0.25

12/22/2021 - 15:05:17: [shavit-rankings.smx] Timer (WR Holder Rank table creation 0/4) SQL query failed. Reason: Unknown column 'wrcount' in 'window order by'

Until I fix the query, you can change this line

bhoptimer/addons/sourcemod/scripting/shavit-rankings.sp

Line 1044 in b2a9509

gB_HasSQLRANK = DoWeHaveRANK(sVersion);

to gB_HasSQLRANK = false; so that error won't happen

I will try later.Thanks

This should resolve that for MySQL 8.0: https://github.com/BoomShotKapow/bhoptimer/blob/aa4b79f9a67c4baedb0870c2afd968edbf6a9be7/addons/sourcemod/scripting/shavit-rankings.sp#L1291-L1297

https://github.com/BoomShotKapow/bhoptimer/blob/aa4b79f9a67c4baedb0870c2afd968edbf6a9be7/addons/sourcemod/scripting/shavit-rankings.sp#L1306-L1312

Until the next release is out you'll have to manually make one of the changes suggested by me or BoomShot.
BoomShot's patch for it will be included in next release.