Timer (zone refresh) SQL query failed.

[ghost]

[shavit-zones.smx] Timer (zone refresh) SQL query failed. Reason: Table 'bhop.mapzones' doesn't exist.

need help

[ghost]

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

[shavitush]

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

[ghost]

yes

[shavitush]

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

[ghost]

the same

[shavitush]

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.

[ghost]

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

[shavitush]

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?

[ghost]

Ha,no more error.

[ghost]

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

[shavitush]

Pushed an update to shavit-replay.sp

[ghost]

Could you make a wait time before start replaying?

sorry for troubling you so much ;)

[shavitush]

Will be added on next update I guess :)

On Sun, Apr 24, 2016 at 7:54 AM, Skyline23 notifications@github.com 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)

[shavitush]

Done! Need anything else?

[ghost]

No more,Thank you so much!

---

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

can you fix it?

[shavitush]

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

Reconfigure them, there are new cvars

[ghost]

https://youtu.be/g624HOe119Q

[shavitush]

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

Do you have any error logs?

[ghost]

No....

[shavitush]

Alright I'll take a look when I get home (2 days)
On Apr 26, 2016 06:46, "Skyline23" notifications@github.com 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)

[shavitush]

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.