Timer (zone refresh) SQL query failed. about bhoptimer HOT 21 CLOSED

L 04/20/2016 - 18:02:13: [shavit-zones.smx] Timer (zones module) error! Map zones' table creation failed. Reason: 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 '' at line 1

from bhoptimer.

Did you locally compile the .sp files from this repository?

from bhoptimer.

yes

from bhoptimer.

Could you change the value of shavit_core_sqlprefix in cfg/sourcemod/plugin.shavit-core.cfg to something else and try again?

from bhoptimer.

the same

from bhoptimer.

Alright, set shavit_core_sqlprefix to the default value and for now run this query on your database.

CREATE TABLE IF NOT EXISTS `mapzones` (`id` INT AUTO_INCREMENT, `map` VARCHAR(128), `type` INT, `corner1_x` FLOAT, `corner1_y` FLOAT, `corner1_z` FLOAT, `corner2_x` FLOAT, `corner2_y` FLOAT, `corner2_z` FLOAT, `rot_ang` FLOAT NOT NULL default 0, `fix1_x` FLOAT NOT NULL default 0, `fix1_y` FLOAT NOT NULL default 0, `fix2_x` FLOAT NOT NULL default 0, `fix2_y` FLOAT NOT NULL default 0, PRIMARY KEY (`id`));

As I'm not sure what is the cause of it for now.

from bhoptimer.

still have the error.but i dont mind it, thank you for your help.

from bhoptimer.

Just wanted to tell you that I attempted to fix this issue because I found the cause.

Could you try to recompile the whole timer and try again?

from bhoptimer.

Ha,no more error.

from bhoptimer.

[shavit-replay] Line 147 CS_SetClientContributionScore(gI_ReplayBotClient[i], 2000)
it doesn't work in cs:s.

from bhoptimer.

Pushed an update to shavit-replay.sp

from bhoptimer.

Could you make a wait time before start replaying?

sorry for troubling you so much ;)

from bhoptimer.

Will be added on next update I guess :)

On Sun, Apr 24, 2016 at 7:54 AM, Skyline23 [email protected] wrote:

Could you make a wait time before start replaying?

sorry for troubling you so much ;)

—
You are receiving this because you modified the open/close state.
Reply to this email directly or view it on GitHub
#23 (comment)

from bhoptimer.

Done! Need anything else?

from bhoptimer.

No more,Thank you so much!

ehh.i found when no mapzones in map type "!r" will start timer.

can you fix it?

from bhoptimer.

Delete cfg/sourcemod/plugin.shavit-misc.cfg
Delete cfg/sourcemod/plugin.shavit-zones.cfg

Reconfigure them, there are new cvars

from bhoptimer.

https://youtu.be/g624HOe119Q

from bhoptimer.

I have actually had a similar issue with zones not loading, give it another try after recompiling everything.

Do you have any error logs?

from bhoptimer.

No....

from bhoptimer.

Alright I'll take a look when I get home (2 days)
On Apr 26, 2016 06:46, "Skyline23" [email protected] wrote:

No....

—
You are receiving this because you modified the open/close state.
Reply to this email directly or view it on GitHub
#23 (comment)

from bhoptimer.

So I didn't understand exactly what your issue was, I tested it in-game and now I see!

I fixed it. I even added a new cvar, but the default setting will work.

from bhoptimer.