[SurfTimer] SQL Error

[tomtko]

[SurfTimer] SQL Error

[tomtko]

Did you use create-tables.sql ? hold on there isn't a antibhop colum, let me make it

[bedstespil]

Did you use create-tables.sql ? Yes

[bedstespil]

Error
Static analysis:

3 errors were found during analysis.

A comma or a closing bracket was expected. (near "(" at position 2116)
Unexpected beginning of statement. (near "mapname" at position 2117)
Unrecognized statement type. (near "ENGINE" at position 2130)
SQL query:

CREATE TABLE IF NOT EXISTS ck_mapsettings ( mapname varchar(128) NOT NULL, startprespeed float NOT NULL DEFAULT '350', bonusprespeed float NOT NULL DEFAULT '350', stageprespeed2 float NOT NULL DEFAULT '350', stageprespeed3 float NOT NULL DEFAULT '350', stageprespeed4 float NOT NULL DEFAULT '350', stageprespeed5 float NOT NULL DEFAULT '350', stageprespeed6 float NOT NULL DEFAULT '350', stageprespeed7 float NOT NULL DEFAULT '350', stageprespeed8 float NOT NULL DEFAULT '350', stageprespeed9 float NOT NULL DEFAULT '350', stageprespeed10 float NOT NULL DEFAULT '350', stageprespeed11 float NOT NULL DEFAULT '350', stageprespeed12 float NOT NULL DEFAULT '350', stageprespeed13 float NOT NULL DEFAULT '350', stageprespeed14 float NOT NULL DEFAULT '350', stageprespeed15 float NOT NULL DEFAULT '320', stageprespeed16 float NOT NULL DEFAULT '350', stageprespeed17 float NOT NULL DEFAULT '350', stageprespeed18 float NOT NULL DEFAULT '350', stageprespeed19 float NOT NULL DEFAULT '350', stageprespeed20 float NOT NULL DEFAULT '350', stageprespeed21 float NOT NULL DEFAULT '350', stageprespeed22 float NOT NULL DEFAULT '350', stageprespeed23 float NOT NULL DEFAULT '350', stageprespeed24 float NOT NULL DEFAULT '350', stageprespeed25 float NOT NULL DEFAULT '350', stageprespeed26 float NOT NULL DEFAULT '350', stageprespeed27 float NOT NULL DEFAULT '350', stageprespeed28 float NOT NULL DEFAULT '350', stageprespeed29 float NOT NULL DEFAULT '350', stageprespeed30 float NOT NULL DEFAULT '350', stageprespeed31 float NOT NULL DEFAULT '320', stageprespeed32 float NOT NULL DEFAULT '350', stageprespeed33 float NOT NULL DEFAULT '350', stageprespeed34 float NOT NULL DEFAULT '350', stageprespeed35 float NOT NULL DEFAULT '350', maxvelocity float NOT NULL DEFAULT '3500', announcerecord float NOT NULL DEFAULT '0', gravityfix int(11) NOT NULL DEFAULT '1', antibhopmap int (11) NOT NULL DEFAULT '0', antibhopbonus int (11) NOT NULL DEFAULT'0' PRIMARY KEY (mapname) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

MySQL said: Documentation

#1064 - 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 '(mapname)
) ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 44

When i try to put your new sql file into my database.

[tomtko]

try new create-tables.sql and surftimer.smx

[bedstespil]

New error:

Notice in ./libraries/sql-parser/src/Components/OptionsArray.php#216
Trying to get property of non-object

Backtrace

./libraries/sql-parser/src/Components/CreateDefinition.php#247: SqlParser\Components\OptionsArray::parse(
,
,
array,
)
./libraries/sql-parser/src/Statements/CreateStatement.php#435: SqlParser\Components\CreateDefinition::parse(
,
,
)
./libraries/sql-parser/src/Statement.php#90: SqlParser\Statements\CreateStatement->parse(
,
,
)
./libraries/sql-parser/src/Parser.php#488: SqlParser\Statement->__construct(
,
,
)
./libraries/sql-parser/src/Parser.php#369: SqlParser\Parser->parse()
./libraries/sql-parser/src/Utils/Query.php#373: SqlParser\Parser->__construct(string 'CREATE TABLE IF NOT EXISTS ck_mapsettings ( mapname varchar(128) NOT NULL, startprespeed float NOT NULL DEFAULT '350', bonusprespeed float NOT NULL DEFAULT '350', stageprespeed2 float NOT NULL DEFAULT '350', stageprespeed3 float NOT NULL DEFAULT '350', stageprespeed4 float NOT NULL DEFAULT '350', stageprespeed5 float NOT NULL DEFAULT '350', stageprespeed6 float NOT NULL DEFAULT '350', stageprespeed7 float NOT NULL DEFAULT '350', stageprespeed8 float NOT NULL DEFAULT '350', stageprespeed9 float NOT NULL DEFAULT '350', stageprespeed10 float NOT NULL DEFAULT '350', stageprespeed11 float NOT NULL DEFAULT '350', stageprespeed12 float NOT NULL DEFAULT '350', stageprespeed13 float NOT NULL DEFAULT '350', stageprespeed14 float NOT NULL DEFAULT '350', stageprespeed15 float NOT NULL DEFAULT '320', stageprespeed16 float NOT NULL DEFAULT '350', stageprespeed17 float NOT NULL DEFAULT '350', stageprespeed18 float NOT NULL DEFAULT '350', stageprespeed19 float NOT NULL DEFAULT '350', stageprespeed20 float NOT NULL DEFAULT '350', stageprespeed21 float NOT NULL DEFAULT '350', stageprespeed22 float NOT NULL DEFAULT '350', stageprespeed23 float NOT NULL DEFAULT '350', stageprespeed24 float NOT NULL DEFAULT '350', stageprespeed25 float NOT NULL DEFAULT '350', stageprespeed26 float NOT NULL DEFAULT '350', stageprespeed27 float NOT NULL DEFAULT '350', stageprespeed28 float NOT NULL DEFAULT '350', stageprespeed29 float NOT NULL DEFAULT '350', stageprespeed30 float NOT NULL DEFAULT '350', stageprespeed31 float NOT NULL DEFAULT '320', stageprespeed32 float NOT NULL DEFAULT '350', stageprespeed33 float NOT NULL DEFAULT '350', stageprespeed34 float NOT NULL DEFAULT '350', stageprespeed35 float NOT NULL DEFAULT '350', maxvelocity float NOT NULL DEFAULT '3500', announcerecord float NOT NULL DEFAULT '0', gravityfix int(11) NOT NULL DEFAULT '1', antibhopmap int (11) NOT NULL DEFAULT '0', antibhopbonus int (11) NOT NULL DEFAULT'0', PRIMARY KEY (mapname) ) ENGINE=InnoDB DEFAULT CHARSET=utf8')
./libraries/parse_analyze.lib.php#28: SqlParser\Utils\Query::getAll(string 'CREATE TABLE IF NOT EXISTS ck_mapsettings ( mapname varchar(128) NOT NULL, startprespeed float NOT NULL DEFAULT '350', bonusprespeed float NOT NULL DEFAULT '350', stageprespeed2 float NOT NULL DEFAULT '350', stageprespeed3 float NOT NULL DEFAULT '350', stageprespeed4 float NOT NULL DEFAULT '350', stageprespeed5 float NOT NULL DEFAULT '350', stageprespeed6 float NOT NULL DEFAULT '350', stageprespeed7 float NOT NULL DEFAULT '350', stageprespeed8 float NOT NULL DEFAULT '350', stageprespeed9 float NOT NULL DEFAULT '350', stageprespeed10 float NOT NULL DEFAULT '350', stageprespeed11 float NOT NULL DEFAULT '350', stageprespeed12 float NOT NULL DEFAULT '350', stageprespeed13 float NOT NULL DEFAULT '350', stageprespeed14 float NOT NULL DEFAULT '350', stageprespeed15 float NOT NULL DEFAULT '320', stageprespeed16 float NOT NULL DEFAULT '350', stageprespeed17 float NOT NULL DEFAULT '350', stageprespeed18 float NOT NULL DEFAULT '350', stageprespeed19 float NOT NULL DEFAULT '350', stageprespeed20 float NOT NULL DEFAULT '350', stageprespeed21 float NOT NULL DEFAULT '350', stageprespeed22 float NOT NULL DEFAULT '350', stageprespeed23 float NOT NULL DEFAULT '350', stageprespeed24 float NOT NULL DEFAULT '350', stageprespeed25 float NOT NULL DEFAULT '350', stageprespeed26 float NOT NULL DEFAULT '350', stageprespeed27 float NOT NULL DEFAULT '350', stageprespeed28 float NOT NULL DEFAULT '350', stageprespeed29 float NOT NULL DEFAULT '350', stageprespeed30 float NOT NULL DEFAULT '350', stageprespeed31 float NOT NULL DEFAULT '320', stageprespeed32 float NOT NULL DEFAULT '350', stageprespeed33 float NOT NULL DEFAULT '350', stageprespeed34 float NOT NULL DEFAULT '350', stageprespeed35 float NOT NULL DEFAULT '350', maxvelocity float NOT NULL DEFAULT '3500', announcerecord float NOT NULL DEFAULT '0', gravityfix int(11) NOT NULL DEFAULT '1', antibhopmap int (11) NOT NULL DEFAULT '0', antibhopbonus int (11) NOT NULL DEFAULT'0', PRIMARY KEY (mapname) ) ENGINE=InnoDB DEFAULT CHARSET=utf8')
./import.php#800: PMA_parseAnalyze(
string 'CREATE TABLE IF NOT EXISTS ck_mapsettings ( mapname varchar(128) NOT NULL, startprespeed float NOT NULL DEFAULT '350', bonusprespeed float NOT NULL DEFAULT '350', stageprespeed2 float NOT NULL DEFAULT '350', stageprespeed3 float NOT NULL DEFAULT '350', stageprespeed4 float NOT NULL DEFAULT '350', stageprespeed5 float NOT NULL DEFAULT '350', stageprespeed6 float NOT NULL DEFAULT '350', stageprespeed7 float NOT NULL DEFAULT '350', stageprespeed8 float NOT NULL DEFAULT '350', stageprespeed9 float NOT NULL DEFAULT '350', stageprespeed10 float NOT NULL DEFAULT '350', stageprespeed11 float NOT NULL DEFAULT '350', stageprespeed12 float NOT NULL DEFAULT '350', stageprespeed13 float NOT NULL DEFAULT '350', stageprespeed14 float NOT NULL DEFAULT '350', stageprespeed15 float NOT NULL DEFAULT '320', stageprespeed16 float NOT NULL DEFAULT '350', stageprespeed17 float NOT NULL DEFAULT '350', stageprespeed18 float NOT NULL DEFAULT '350', stageprespeed19 float NOT NULL DEFAULT '350', stageprespeed20 float NOT NULL DEFAULT '350', stageprespeed21 float NOT NULL DEFAULT '350', stageprespeed22 float NOT NULL DEFAULT '350', stageprespeed23 float NOT NULL DEFAULT '350', stageprespeed24 float NOT NULL DEFAULT '350', stageprespeed25 float NOT NULL DEFAULT '350', stageprespeed26 float NOT NULL DEFAULT '350', stageprespeed27 float NOT NULL DEFAULT '350', stageprespeed28 float NOT NULL DEFAULT '350', stageprespeed29 float NOT NULL DEFAULT '350', stageprespeed30 float NOT NULL DEFAULT '350', stageprespeed31 float NOT NULL DEFAULT '320', stageprespeed32 float NOT NULL DEFAULT '350', stageprespeed33 float NOT NULL DEFAULT '350', stageprespeed34 float NOT NULL DEFAULT '350', stageprespeed35 float NOT NULL DEFAULT '350', maxvelocity float NOT NULL DEFAULT '3500', announcerecord float NOT NULL DEFAULT '0', gravityfix int(11) NOT NULL DEFAULT '1', antibhopmap int (11) NOT NULL DEFAULT '0', antibhopbonus int (11) NOT NULL DEFAULT'0', PRIMARY KEY (mapname) ) ENGINE=InnoDB DEFAULT CHARSET=utf8',
string 'surftimer',
)

[tomtko]

now?

[bedstespil]

Yes

Now there is no error on the sql file :) I will test on and will say if there are errors.
I also see that the materials/decals/paint files are missing in your package. It tries to download the files, but they are missing.

[tomtko]

ah yeah forgot about those, will add, thanks. =)

[bedstespil]

L 08/19/2017 - 19:01:56: SourceMod error session started
L 08/19/2017 - 19:01:56: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170819.log")
L 08/19/2017 - 19:01:56: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/19/2017 - 19:01:56: [CSTRIKE] Failed to lookup AliasToWeaponID signature.
L 08/19/2017 - 19:01:58: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/19/2017 - 19:01:58: [CSTRIKE] Failed to lookup AliasToWeaponID signature.
L 08/19/2017 - 19:02:08: Error log file session closed.
L 08/19/2017 - 19:02:12: SourceMod error session started
L 08/19/2017 - 19:02:12: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170819.log")
L 08/19/2017 - 19:02:12: [surftimer.smx] [SurfTimer] SQL Error (SQL_CheckVIPAdminCallback): 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 'steamid = 'STEAM_1:1:61281672'' at line 1
L 08/19/2017 - 19:02:12: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 08/19/2017 - 19:02:12: [SM] Blaming: surftimer.smx
L 08/19/2017 - 19:02:12: [SM] Call stack trace:
L 08/19/2017 - 19:02:12: [SM] [0] SQL_HasResultSet
L 08/19/2017 - 19:02:12: [SM] [1] Line 299, SurfTimer/sql2.sp::SQL_CheckVIPAdminCallback
L 08/19/2017 - 19:02:12: [surftimer.smx] [SurfTimer] SQL Error (SQL_viewCustomTitlesCallback): Unknown column 'vip' in 'field list'
L 08/19/2017 - 19:02:15: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/19/2017 - 19:02:15: [CSTRIKE] Failed to lookup AliasToWeaponID signature.
L 08/19/2017 - 19:02:18: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/19/2017 - 19:02:18: [CSTRIKE] Failed to lookup AliasToWeaponID signature.

[bedstespil]

Another error ... When I revert my server and access the server, no zones are loaded or ranks on the server. I have to switch to the same map before zone and rank come again. So it's as if it does not connect to database at restart and boot of server?

[tomtko]

Use new create-tables.sql and yeah it's a known ckSurf bug

[bedstespil]

Gets the same error with the new sql file.

L 08/19/2017 - 21:17:52: [surftimer.smx] [SurfTimer] SQL Error (SQL_CheckVIPAdminCallback): 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 'steamid = 'STEAM_1:1:61281672'' at line 1
L 08/19/2017 - 21:17:52: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 08/19/2017 - 21:17:52: [SM] Blaming: surftimer.smx
L 08/19/2017 - 21:17:52: [SM] Call stack trace:
L 08/19/2017 - 21:17:52: [SM] [0] SQL_HasResultSet
L 08/19/2017 - 21:17:52: [SM] [1] Line 299, SurfTimer/sql2.sp::SQL_CheckVIPAdminCallback
L 08/19/2017 - 21:17:52: [surftimer.smx] [SurfTimer] SQL Error (SQL_viewCustomTitlesCallback): Unknown column 'vip' in 'field list'
L 08/19/2017 - 21:17:52: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/19/2017 - 21:17:52: [CSTRIKE] Failed to lookup AliasToWeaponID signature.
L 08/19/2017 - 21:19:55: [surftimer.smx] [SurfTimer] SQL Error (SQL_CheckVIPAdminCallback): 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 'steamid = 'STEAM_1:0:208275391'' at line 1
L 08/19/2017 - 21:19:55: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 08/19/2017 - 21:19:55: [SM] Blaming: surftimer.smx
L 08/19/2017 - 21:19:55: [SM] Call stack trace:
L 08/19/2017 - 21:19:55: [SM] [0] SQL_HasResultSet
L 08/19/2017 - 21:19:55: [SM] [1] Line 299, SurfTimer/sql2.sp::SQL_CheckVIPAdminCallback
L 08/19/2017 - 21:19:55: [surftimer.smx] [SurfTimer] SQL Error (SQL_viewCustomTitlesCallback): Unknown column 'vip' in 'field list'
L 08/19/2017 - 21:19:55: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/19/2017 - 21:19:55: [CSTRIKE] Failed to lookup AliasToWeaponID signature.
L 08/19/2017 - 21:19:59: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/19/2017 - 21:19:59: [CSTRIKE] Failed to lookup AliasToWeaponID signature.

[tomtko]

use new smx

[RAMBATEN]

Still get SQL error

[tomtko]

what's the error?

[RAMBATEN]

https://pastebin.com/MusCiUzV

[tomtko]

@RAMBATEN what version of sm?
edit: you probably need to update sm and your gamedata

[bedstespil]

L 08/20/2017 - 08:15:18: SourceMod error session started
L 08/20/2017 - 08:15:18: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170820.log")
L 08/20/2017 - 08:15:18: [surftimer.smx] [SurfTimer] SQL Error (SQL_CheckVIPAdminCallback): Unknown column 'vip' in 'field list'
L 08/20/2017 - 08:15:18: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 08/20/2017 - 08:15:18: [SM] Blaming: surftimer.smx
L 08/20/2017 - 08:15:18: [SM] Call stack trace:
L 08/20/2017 - 08:15:18: [SM] [0] SQL_HasResultSet
L 08/20/2017 - 08:15:18: [SM] [1] Line 299, SurfTimer/sql2.sp::SQL_CheckVIPAdminCallback
L 08/20/2017 - 08:15:18: [surftimer.smx] [SurfTimer] SQL Error (SQL_viewCustomTitlesCallback): Unknown column 'vip' in 'field list'
L 08/20/2017 - 08:15:18: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature.
L 08/20/2017 - 08:15:18: [CSTRIKE] Failed to lookup AliasToWeaponID signature.

[tomtko]

@bedstespil did you remake the tables and use the new smx file?

[bedstespil]

Hello again. Everything works now. So do not have more errors. Thanks for the help :)

[bedstespil]

I have another error: The game starts again in 3 seconds. This happens every time a new player goes on hold. Then everyone gets thrown back to the start.
Any suggestions on how to solve this?

[tomtko]

Not sure I understand what you mean, what is "goes on hold"?

[bedstespil]

When people go to team

94.250.219.140:27015

[RAMBATEN]

Everything works now fine for me..Only error I have..I dont know why..Even I have the latest 6024 sourcemod..
But this aint problem of your timer..

https://pastebin.com/L3H4FeDK

[bedstespil]

Its everytime the second person joins "The game starts again in 3 seconds"

[tomtko]

@RAMBATEN https://forums.alliedmods.net/showthread.php?p=2542767

[tomtko]

@bedstespil i think it's a different plugin causing that, list your sm plugins list here

[bedstespil]

sm plugins list
[SM] Listing 28 plugins:
01 "Basic Votes" (1.8.0.6024) by AlliedModders LLC
02 "Basic Commands" (1.8.0.6024) by AlliedModders LLC
03 "Admin Help" (1.8.0.6024) by AlliedModders LLC
04 "Player Commands" (1.8.0.6024) by AlliedModders LLC
05 "SQL Admins (Prefetch)" (1.8.0.6024) by AlliedModders LLC
06 "Admin Menu" (1.8.0.6024) by AlliedModders LLC
07 "Map Nominations Extended" (1.10.0) by Powerlord and AlliedModders LLC
08 "Anti-Flood" (1.8.0.6024) by AlliedModders LLC
09 "Basic Info Triggers" (1.8.0.6024) by AlliedModders LLC
10 "Updater" (1.2.2) by GoD-Tony
11 "Basic Comm Control" (1.8.0.6024) by AlliedModders LLC
12 "Fun Commands" (1.8.0.6024) by AlliedModders LLC
13 "Fun Votes" (1.8.0.6024) by AlliedModders LLC
14 "SQL Admin Manager" (1.8.0.6024) by AlliedModders LLC
15 "Admin File Reader" (1.8.0.6024) by AlliedModders LLC
16 "cURL self test" (1.1.0.0) by Raydan
17 "MapChooser Extended" (1.10.2) by Powerlord, Zuko, and AlliedModders LLC
18 "SQL Admins (Threaded)" (1.8.0.6024) by AlliedModders LLC
19 "Nextmap" (1.8.0.6024) by AlliedModders LLC
20 "Ingame Map Download" (2.2.1) by Popoklopsi
21 "SurfTimer" (2.05) by Fluffys, Jakeey802
22 "CS:GO Choose Team Fix" (1.0) by bbs.93x.net
23 "Reserved Slots" (1.8.0.6024) by AlliedModders LLC
24 "Basic Chat" (1.8.0.6024) by AlliedModders LLC
25 "Rock The Vote Extended" (1.10.0) by Powerlord and AlliedModders LLC
26 "Basic Ban Commands" (1.8.0.6024) by AlliedModders LLC
27 "Client Preferences" (1.8.0.6024) by AlliedModders LLC
28 "Sound Commands" (1.8.0.6024) by AlliedModders LLC

[tomtko]

Try disabling #22, or perhaps you didn't upload the cfg folder?

[bedstespil]

Try disabling #22 Thanks it works now