SQL Syntax errror (New Server)

[Kasel]

I'm not really sure where this should go.

I'm having this error while trying to EXECUTE main.sql with my new database schema "ragnarok".

16:23:18 `clan_id` int(11) unsigned NOT NULL auto_increment,   `name` varchar(24) NOT NULL DEFAULT '',   `master` varchar(24) NOT NULL DEFAULT '',   `mapname` varchar(24) NOT NULL DEFAULT '',   `max_member` smallint(6) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY (`clan_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 Error Code: 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 '`clan_id` int(11) unsigned NOT NULL auto_increment,   `name` varchar(24) NOT NUL' at line 1 0.000 sec
 

I cannot for the life of me figure this out and google has given me nothing. Any of you know what I should do?

 

EDIT: I just went into the code in the sql workbench and removed everything relating to clans.  Everything else executed perfectly fine.  It was only the clan data for some reason.  I suppose I could always add it to the database manually at some point.

Edited September 24, 2017 by Kasel

[Kasel]

This can be considered solved.  I couldn't execute the clan data all at once with the main.sql, I had to do it separately.

All is right in the world now.

[yakiboy]

What did you do to eliminate the error? I'm having the same error.