[^SmileY]

INT (10)

and

default '-1'

For real? OMFG

CREATE TABLE IF NOT EXISTS amx_match_main
(
	match_id SMALLINT NOT NULL AUTO_INCREMENT,
	map1_id SMALLINT NOT NULL default 0,
	map2_id SMALLINT NOT NULL default 0, 
	half1_id SMALLINT NOT NULL default 0,
	half2_id SMALLINT NOT NULL default 0,
	half3_id SMALLINT NOT NULL default 0,
	half4_id SMALLINT NOT NULL default 0,
	half5_id SMALLINT NOT NULL default 0,
	half6_id SMALLINT NOT NULL default 0,
	half7_id SMALLINT NOT NULL default 0,
	half8_id SMALLINT NOT NULL default 0,
	PRIMARY KEY(match_id)
)

You can not deal with an INTEGER TYPE using single or double quotes, and you never (I think) need to be insert a size of an integer field in mysql.
Oh and you never do not need to use quotes in a table or field name in SQL, because they can't be created using spaces.

EDIT: I have attached the .sql file (Working for me)

[Icery]

now i can use my orignal account again :-/

i already use your way to change my sql like this

# MySQL file for AMXMDs Stats # -------------------------------------------------------- # # Table structure for table amx_match_main # # half1 = half1; half2 = half2; half3 = ot1; half4 = ot2 # map2: half5 = half1; half6 = half2; half7 = ot1; half8 = ot2 # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_main ( match_id SMALLINT NOT NULL AUTO_INCREMENT, map1_id SMALLINT NOT NULL default 0, map2_id SMALLINT NOT NULL default 0, half1_id SMALLINT NOT NULL default 0, half2_id SMALLINT NOT NULL default 0, half3_id SMALLINT NOT NULL default 0, half4_id SMALLINT NOT NULL default 0, half5_id SMALLINT NOT NULL default 0, half6_id SMALLINT NOT NULL default 0, half7_id SMALLINT NOT NULL default 0, half8_id SMALLINT NOT NULL default 0, PRIMARY KEY(match_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_half # # team1 -> T # team2 -> CT # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_half ( half_id int(10) NOT NULL auto_increment, team1_id int(10) NOT NULL default -1, team1_score int(4) NOT NULL default 0, team2_id int(10) NOT NULL default -1, team2_score int(4) NOT NULL default 0, PRIMARY KEY (half_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_map # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_map ( map_id int(10) NOT NULL auto_increment, map_name varchar(64) NOT NULL default , PRIMARY KEY (map_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_player # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player ( player_id int(10) NOT NULL auto_increment, player_steamid varchar(64) NOT NULL default , PRIMARY KEY (player_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_player_name # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player_name ( name_id int(10) NOT NULL auto_increment, player_id int(10) NOT NULL default -1, player_name varchar(64) NOT NULL default , PRIMARY KEY (name_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_player_statistics # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player_statistics ( statistics_id int(10) NOT NULL auto_increment, player_id int(10) NOT NULL default -1, half_id int(10) NOT NULL default -1, player_frags int(4) NOT NULL default 0, player_deaths int(4) NOT NULL default 0, team_id int(10) NOT NULL default -1, PRIMARY KEY (statistics_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_team # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_team ( team_id int(10) NOT NULL auto_increment, team_name varchar(64) NOT NULL default , PRIMARY KEY (team_id) ) # --------------------------------------------------------

but it show the same error

[^SmileY]

You have read my post? I think not!

Remove sizes from int

[YamiKaitou]

Originally Posted by ^SmileY Remove sizes from int

Not required. 5.5 supports both ways.

[Icery]

Originally Posted by ^SmileY You have read my post? I think not! Remove sizes from int

Like this.........?

# MySQL file for AMXMDs Stats # -------------------------------------------------------- # # Table structure for table amx_match_main # # half1 = half1; half2 = half2; half3 = ot1; half4 = ot2 # map2: half5 = half1; half6 = half2; half7 = ot1; half8 = ot2 # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_main ( match_id SMALLINT NOT NULL AUTO_INCREMENT, map1_id SMALLINT NOT NULL default 0, map2_id SMALLINT NOT NULL default 0, half1_id SMALLINT NOT NULL default 0, half2_id SMALLINT NOT NULL default 0, half3_id SMALLINT NOT NULL default 0, half4_id SMALLINT NOT NULL default 0, half5_id SMALLINT NOT NULL default 0, half6_id SMALLINT NOT NULL default 0, half7_id SMALLINT NOT NULL default 0, half8_id SMALLINT NOT NULL default 0, PRIMARY KEY(match_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_half # # team1 -> T # team2 -> CT # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_half ( half_id SMALLINT NOT NULL auto_increment, team1_id SMALLINT NOT NULL default 0, team1_score SMALLINT NOT NULL default 0, team2_id SMALLINT NOT NULL default 0, team2_score SMALLINT NOT NULL default 0, PRIMARY KEY (half_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_map # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_map ( map_id SMALLINT NOT NULL auto_increment, map_name varchar(64) NOT NULL default , PRIMARY KEY (map_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_player # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player ( player_id SMALLINT NOT NULL auto_increment, player_steamid varchar(64) NOT NULL default , PRIMARY KEY (player_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_player_name # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player_name ( name_id SMALLINT NOT NULL auto_increment, player_id SMALLINT NOT NULL default 0, player_name varchar(64) NOT NULL default , PRIMARY KEY (name_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_player_statistics # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player_statistics ( statistics_id SMALLINT NOT NULL auto_increment, player_id SMALLINT NOT NULL default 0, half_id SMALLINT NOT NULL default 0, player_frags SMALLINT NOT NULL default 0, player_deaths SMALLINT NOT NULL default 0, team_id SMALLINT NOT NULL default 0, PRIMARY KEY (statistics_id) ) # -------------------------------------------------------- # # Table structure for table amx_match_team # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_team ( team_id SMALLINT NOT NULL auto_increment, team_name varchar(64) NOT NULL default , PRIMARY KEY (team_id) ) # --------------------------------------------------------

It fail eiher.........

[YamiKaitou]

Stick a semi-colon after each query

[Icery]

Originally Posted by YamiKaitou Stick a semi-colon after each query

Sorry......I don't understand what you mean.........
I'm not good at sql and English..........
Can you help me to fix it andshow me.......? plz..

[Icery]

do you have teamviwer :-/?
you can control my PC!

[YamiKaitou]

Put a ; at the end of each statement. Or execute each statement by itself

[Icery]

Originally Posted by YamiKaitou Put a ; at the end of each statement. Or execute each statement by itself

I try to fix like this

# MySQL file for AMXMDs Stats # -------------------------------------------------------- # # Table structure for table amx_match_main # # half1 = half1; half2 = half2; half3 = ot1; half4 = ot2 # map2: half5 = half1; half6 = half2; half7 = ot1; half8 = ot2 # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_main ( match_id SMALLINT NOT NULL AUTO_INCREMENT, map1_id SMALLINT NOT NULL default 0, map2_id SMALLINT NOT NULL default 0, half1_id SMALLINT NOT NULL default 0, half2_id SMALLINT NOT NULL default 0, half3_id SMALLINT NOT NULL default 0, half4_id SMALLINT NOT NULL default 0, half5_id SMALLINT NOT NULL default 0, half6_id SMALLINT NOT NULL default 0, half7_id SMALLINT NOT NULL default 0, half8_id SMALLINT NOT NULL default 0, PRIMARY KEY(match_id) ); # -------------------------------------------------------- # # Table structure for table amx_match_half # # team1 -> T # team2 -> CT # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_half ( half_id SMALLINT NOT NULL auto_increment, team1_id SMALLINT NOT NULL default 0, team1_score SMALLINT NOT NULL default 0, team2_id SMALLINT NOT NULL default 0, team2_score SMALLINT NOT NULL default 0, PRIMARY KEY (half_id) ); # -------------------------------------------------------- # # Table structure for table amx_match_map # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_map ( map_id SMALLINT NOT NULL auto_increment, map_name varchar(64) NOT NULL default , PRIMARY KEY (map_id) ); # -------------------------------------------------------- # # Table structure for table amx_match_player # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player ( player_id SMALLINT NOT NULL auto_increment, player_steamid varchar(64) NOT NULL default , PRIMARY KEY (player_id) ); # -------------------------------------------------------- # # Table structure for table amx_match_player_name # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player_name ( name_id SMALLINT NOT NULL auto_increment, player_id SMALLINT NOT NULL default 0, player_name varchar(64) NOT NULL default , PRIMARY KEY (name_id) ); # -------------------------------------------------------- # # Table structure for table amx_match_player_statistics # # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_player_statistics ( statistics_id SMALLINT NOT NULL auto_increment, player_id SMALLINT NOT NULL default 0, half_id SMALLINT NOT NULL default 0, player_frags SMALLINT NOT NULL default 0, player_deaths SMALLINT NOT NULL default 0, team_id SMALLINT NOT NULL default 0, PRIMARY KEY (statistics_id) ); # -------------------------------------------------------- # # Table structure for table amx_match_team # -------------------------------------------------------- # CREATE TABLE IF NOT EXISTS amx_match_team ( team_id SMALLINT NOT NULL auto_increment, team_name varchar(64) NOT NULL default , PRIMARY KEY (team_id) ); # --------------------------------------------------------

and the error is different now:-/