[freak.exe_uLow]

Originally Posted by stac Good call! However I am not getting this error on the problem map! Anyway, it is showing this: [ckSurf_sl.smx] [ckSurf] SQL Error (SQL_UpdateRecordProCallback): Incorrect string value: '\xE3\x83\x84' for column `database`.`ck_playertimes`.`name` at row 1

I'm no pro at databases, but he'll write you the error...I will write StOOne privately, maybe he can help you (I hate databases)

[scarneck]

having issues with the


sm_resetplayermaptime not working and most of the commands arent working either. idk why

[stac]

I am now getting a new error on the issue map:

[ckSurf_sl.smx] [ckSurf] SQL Error (SQL_CheckCallback): Incorrect string value: '\xE2\x9C\xAF3L1...' for column `database`.`ck_playerrank`.`name` at row 1


Additionally the bot is the previous record even after a full server reboot?

[freak.exe_uLow]

Originally Posted by stac I am now getting a new error on the issue map: [ckSurf_sl.smx] [ckSurf] SQL Error (SQL_CheckCallback): Incorrect string value: '\xE2\x9C\xAF3L1...' for column `database`.`ck_playerrank`.`name` at row 1 Additionally the bot is the previous record even after a full server reboot?

You didn't really use a fresh database...I think you still used the old tables from the old ckSurf timer^^

[St00ne]

Personally I did a fresh install with sqlite.
I tried with old data and was getting errors so I removed the map causing the error.
After I saw more errors I did a fresh install again, recreated all points, and have no error since.

In your place I would do a fresh install with absolutely no old database. Your error seems to be due to database compatibility problem. ckSurf 1.18 is not compatible with fluffy's or other versions.
If you can't afford this (a reset), try removing maps causing errors.

[stac]

Originally Posted by St00ne Personally I did a fresh install with sqlite. I tried with old data and was getting errors so I removed the map causing the error. After I saw more errors I did a fresh install again, recreated all points, and have no error since. In your place I would do a fresh install with absolutely no old database. Your error seems to be due to database compatibility problem. ckSurf 1.18 is not compatible with fluffy's or other versions. If you can't afford this (a reset), try removing maps causing errors.

This was a fresh database, brand new and only this version of cksurf has ever been installed on the server.

The entries were all made recently within the past 4 days, maybe 10 or so different names. I believe I tracked this down to an issue with mySQL handling utf-8 characters. Long story short, if someone uses a unicode character it can mess with mySQL.

I'm unsure on how to handle, maybe my database was configured incorrectly? I'm fine wiping and tarting again, but I believe this issue will just re-appear when someone with unicode in their name places a record.

Is there maybe a way to force everyone's name to a certain character set?

[St00ne]

Yes it seems due to a database char problem but I don't know how to solve it right now.
I never saw a player with weird name mess my database, I personally play with special char in my name and have records on server. I don't know what to tell you.

[freak.exe_uLow]

Originally Posted by stac This was a fresh database, brand new and only this version of cksurf has ever been installed on the server. The entries were all made recently within the past 4 days, maybe 10 or so different names. I believe I tracked this down to an issue with mySQL handling utf-8 characters. Long story short, if someone uses a unicode character it can mess with mySQL. I'm unsure on how to handle, maybe my database was configured incorrectly? I'm fine wiping and tarting again, but I believe this issue will just re-appear when someone with unicode in their name places a record. Is there maybe a way to force everyone's name to a certain character set?

Ohhh pls use utf8mb4, then the problem should be fixed

[nunganu]

Hi there,

Great plugin! Although I have ran into one issue. The timer itself has the string formatting, but doesn't actually resolve into a user friendly format. Please see the attached image.

https://gyazo.com/de1b0759f448c18c92b5c654253e9287

[freak.exe_uLow]

Originally Posted by nunganu Hi there, Great plugin! Although I have ran into one issue. The timer itself has the string formatting, but doesn't actually resolve into a user friendly format. Please see the attached image. https://gyazo.com/de1b0759f448c18c92b5c654253e9287

first, which version of cksurf do you using? the original plugin (ckSurf 1.18f) is not supported and there are problems with it or it can crash your server

and the fix for the hud: https://github.com/Franc1sco/FixHintColorMessages