tomtko / Surftimer-archived

A CS:GO Surftimer which is heavily modified from ckSurf
GNU General Public License v3.0
53 stars 43 forks source link

[SurfTimer] SQL Error #1

Closed bedstespil closed 7 years ago

bedstespil commented 7 years ago

L 08/19/2017 - 15:40:22: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:22: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:24: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:24: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:29: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:29: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:29: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:29: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:29: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:29: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:30: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:30: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:32: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:34: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:59: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:59: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:59: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:59: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:40:59: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:40:59: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:00: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:00: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:13: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:13: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:13: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:13: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:13: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:13: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:16: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:16: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:25: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:36: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:41:48: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:42:06: Error log file session closed. L 08/19/2017 - 15:42:10: SourceMod error session started L 08/19/2017 - 15:42:10: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170819.log") L 08/19/2017 - 15:42:10: [surftimer.smx] [SurfTimer] SQL Error (sql_viewMapSettingsCallback): Unknown column 'antibhopmap' in 'field list' L 08/19/2017 - 15:42:10: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 08/19/2017 - 15:42:10: [SM] Blaming: surftimer.smx L 08/19/2017 - 15:42:10: [SM] Call stack trace: L 08/19/2017 - 15:42:10: [SM] [0] SQL_HasResultSet L 08/19/2017 - 15:42:10: [SM] [1] Line 222, SurfTimer/mapsettings.sp::sql_viewMapSettingsCallback L 08/19/2017 - 15:42:17: Error log file session closed. L 08/19/2017 - 15:42:18: SourceMod error session started L 08/19/2017 - 15:42:18: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170819.log") L 08/19/2017 - 15:42:18: [surftimer.smx] [SurfTimer] SQL Error (sql_viewMapSettingsCallback): Unknown column 'antibhopmap' in 'field list' L 08/19/2017 - 15:42:18: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 08/19/2017 - 15:42:18: [SM] Blaming: surftimer.smx L 08/19/2017 - 15:42:18: [SM] Call stack trace: L 08/19/2017 - 15:42:18: [SM] [0] SQL_HasResultSet L 08/19/2017 - 15:42:18: [SM] [1] Line 222, SurfTimer/mapsettings.sp::sql_viewMapSettingsCallback L 08/19/2017 - 15:42:24: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:42:24: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:42:27: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:42:27: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:42:55: Error log file session closed. L 08/19/2017 - 15:42:55: SourceMod error session started L 08/19/2017 - 15:42:55: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170819.log") L 08/19/2017 - 15:42:55: [surftimer.smx] [SurfTimer] SQL Error (sql_viewMapSettingsCallback): Unknown column 'antibhopmap' in 'field list' L 08/19/2017 - 15:42:55: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 08/19/2017 - 15:42:55: [SM] Blaming: surftimer.smx L 08/19/2017 - 15:42:55: [SM] Call stack trace: L 08/19/2017 - 15:42:55: [SM] [0] SQL_HasResultSet L 08/19/2017 - 15:42:55: [SM] [1] Line 222, SurfTimer/mapsettings.sp::sql_viewMapSettingsCallback L 08/19/2017 - 15:42:55: [surftimer.smx] [SurfTimer] SQL Error (sql_selectMapRecordCallback): Unknown column 'style' in 'field list' L 08/19/2017 - 15:42:55: [surftimer.smx] [SurfTimer] SQL Error (sql_selectPlayerProCountCallback): Unknown column 'style' in 'field list' L 08/19/2017 - 15:42:56: [surftimer.smx] [SurfTimer] SQL Error (db_selectMapCurrentImprovementCallback): Unknown column 'b.style' in 'where clause' L 08/19/2017 - 15:42:59: [surftimer.smx] [SurfTimer] SQL Error (SQL_selectPersonalRecordsCallback): Unknown column 'style' in 'field list' L 08/19/2017 - 15:42:59: [surftimer.smx] [SurfTimer] SQL Error (SQL_CheckVIPAdminCallback): Table 'db_541052_1.sb_admins' doesn't exist L 08/19/2017 - 15:42:59: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 08/19/2017 - 15:42:59: [SM] Blaming: surftimer.smx L 08/19/2017 - 15:42:59: [SM] Call stack trace: L 08/19/2017 - 15:42:59: [SM] [0] SQL_HasResultSet L 08/19/2017 - 15:42:59: [SM] [1] Line 309, SurfTimer/sql2.sp::SQL_CheckVIPAdminCallback L 08/19/2017 - 15:42:59: [surftimer.smx] [SurfTimer] SQL Error (SQL_viewCustomTitlesCallback): Unknown column 'vip' in 'field list' L 08/19/2017 - 15:42:59: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:42:59: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:42:59: [surftimer.smx] [SurfTimer] SQL Error (sql_CountFinishedMapsCallback): Unknown column 'b.style' in 'where clause' L 08/19/2017 - 15:44:13: Error log file session closed. L 08/19/2017 - 15:44:18: SourceMod error session started L 08/19/2017 - 15:44:18: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170819.log") L 08/19/2017 - 15:44:18: [surftimer.smx] [SurfTimer] SQL Error (sql_viewMapSettingsCallback): Unknown column 'antibhopmap' in 'field list' L 08/19/2017 - 15:44:18: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 08/19/2017 - 15:44:18: [SM] Blaming: surftimer.smx L 08/19/2017 - 15:44:18: [SM] Call stack trace: L 08/19/2017 - 15:44:18: [SM] [0] SQL_HasResultSet L 08/19/2017 - 15:44:18: [SM] [1] Line 222, SurfTimer/mapsettings.sp::sql_viewMapSettingsCallback L 08/19/2017 - 15:46:16: Error log file session closed. L 08/19/2017 - 15:46:16: SourceMod error session started L 08/19/2017 - 15:46:16: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20170819.log") L 08/19/2017 - 15:46:16: [surftimer.smx] [SurfTimer] SQL Error (sql_viewMapSettingsCallback): Unknown column 'antibhopmap' in 'field list' L 08/19/2017 - 15:46:16: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 08/19/2017 - 15:46:16: [SM] Blaming: surftimer.smx L 08/19/2017 - 15:46:16: [SM] Call stack trace: L 08/19/2017 - 15:46:16: [SM] [0] SQL_HasResultSet L 08/19/2017 - 15:46:16: [SM] [1] Line 222, SurfTimer/mapsettings.sp::sql_viewMapSettingsCallback L 08/19/2017 - 15:46:22: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:46:22: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:46:25: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:46:25: [CSTRIKE] Failed to lookup AliasToWeaponID signature. L 08/19/2017 - 15:47:13: [surftimer.smx] [SurfTimer] SQL Error (sql_selectMapRecordCallback): Unknown column 'style' in 'field list' L 08/19/2017 - 15:47:13: [surftimer.smx] [SurfTimer] SQL Error (sql_selectPlayerProCountCallback): Unknown column 'style' in 'field list' L 08/19/2017 - 15:47:14: [surftimer.smx] [SurfTimer] SQL Error (db_selectMapCurrentImprovementCallback): Unknown column 'b.style' in 'where clause' L 08/19/2017 - 15:47:14: [surftimer.smx] [SurfTimer] SQL Error (SQL_selectPersonalRecordsCallback): Unknown column 'style' in 'field list' L 08/19/2017 - 15:47:14: [surftimer.smx] [SurfTimer] SQL Error (SQL_CheckVIPAdminCallback): Table 'db_541052_1.sb_admins' doesn't exist L 08/19/2017 - 15:47:14: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 08/19/2017 - 15:47:14: [SM] Blaming: surftimer.smx L 08/19/2017 - 15:47:14: [SM] Call stack trace: L 08/19/2017 - 15:47:14: [SM] [0] SQL_HasResultSet L 08/19/2017 - 15:47:14: [SM] [1] Line 309, SurfTimer/sql2.sp::SQL_CheckVIPAdminCallback L 08/19/2017 - 15:47:14: [surftimer.smx] [SurfTimer] SQL Error (SQL_viewCustomTitlesCallback): Unknown column 'vip' in 'field list' L 08/19/2017 - 15:47:14: [surftimer.smx] [SurfTimer] SQL Error (sql_CountFinishedMapsCallback): Unknown column 'b.style' in 'where clause' L 08/19/2017 - 15:47:28: [CSTRIKE] Failed to lookup GetTranslatedWeaponAlias signature. L 08/19/2017 - 15:47:28: [CSTRIKE] Failed to lookup AliasToWeaponID signature.

tomtko commented 7 years ago

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

bedstespil commented 7 years ago

Did you use create-tables.sql ? Yes

bedstespil commented 7 years ago

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 commented 7 years ago

try new create-tables.sql and surftimer.smx

bedstespil commented 7 years ago

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 commented 7 years ago

now?

bedstespil commented 7 years ago

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 commented 7 years ago

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

bedstespil commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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

bedstespil commented 7 years ago

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 commented 7 years ago

use new smx

RAMBATEN commented 7 years ago

Still get SQL error

tomtko commented 7 years ago

what's the error?

RAMBATEN commented 7 years ago

https://pastebin.com/MusCiUzV

tomtko commented 7 years ago

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

bedstespil commented 7 years ago

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 commented 7 years ago

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

bedstespil commented 7 years ago

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

bedstespil commented 7 years ago

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 commented 7 years ago

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

bedstespil commented 7 years ago

When people go to team

94.250.219.140:27015

RAMBATEN commented 7 years ago

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 commented 7 years ago

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

tomtko commented 7 years ago

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

tomtko commented 7 years ago

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

bedstespil commented 7 years ago

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 commented 7 years ago

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

bedstespil commented 7 years ago

Try disabling #22 Thanks it works now