search

splewis / csgo-multi-1v1

CS:GO Sourcemod plugin to create multi-1v1 arena servers
GNU General Public License v3.0
277 stars 68 forks source link

Can´t create MySQL Tables #259

Closed rzrhome closed 4 years ago

rzrhome commented 4 years ago 

08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', `serverID INT NOT NULL default 0`, `auth varchar(72) NOT NULL default ''`, `na' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`serverID INT NOT NULL default 0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`recentRounds INT default 0 NOT NULL`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`rifleRating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`pistolRating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`awpRating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`scoutRating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`deagleRating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`novaRating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`mag7Rating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`sawedoffRating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`xm1014Rating FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`NoscopeOnly FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 ', ADD INDEX (`HeadshotOnly FLOAT NOT NULL default 1500.0`)' at line 1
08:50:51 L 04/04/2020 - 08:50:50: [multi1v1.smx] 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 'accountID`,`serverID``)' at line 1
iNilo commented 4 years ago

Would need to redo the fields code, I think the best option is to revert back to pre-prettifying / indexes. I won't have time this weekend.