(HELP) kepp getting this error...

[gangstajosh55]

HEY guys. i keep getting thie error whenever i execute any db .sql into navicat. Here it is:

[Err] 1115 - Unknown character set: 'cp1251'
[Err] -- ----------------------------
-- Table structure for gameobject_spawns
-- ----------------------------
CREATE TABLE `gameobject_spawns` (
`id` int(11) unsigned NOT NULL auto_increment,
`Entry` int(10) unsigned NOT NULL default '0',
`map` int(10) unsigned NOT NULL default '0',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`Facing` float NOT NULL default '0',
`orientation1` float NOT NULL default '0',
`orientation2` float NOT NULL default '0',
`orientation3` float NOT NULL default '0',
`orientation4` float NOT NULL default '0',
`State` int(10) unsigned NOT NULL default '0',
`Flags` int(10) unsigned NOT NULL default '0',
`Faction` int(10) unsigned NOT NULL default '0',
`Scale` float NOT NULL default '0',
`stateNpcLink` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `Map` (`map`)
) ENGINE=MyISAM AUTO_INCREMENT=960201146 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Will +Rep if you help thanks.

[Jacob7]

That means its already in your DB ^_^.

[gangstajosh55]

thing is thoe is that i just made a new db in my navicat

[Jacob7]

To fix it just get rid of the table you have in there thats Game spawn table..

[gangstajosh55]

ok ill try that ill still rep ya =)

[Jacob7]

Also are you using 2 sep DB's for the logon and the world ? Its better if you do.

[gangstajosh55]

no im just using 1

[Jacob7]

Go download my DB i put on my new guide that is setting up a server and ill upload my logon DB for you so you can have 2 working ones.

[gangstajosh55]

ight thanks

[SectorSeven]

Change to this:

UPDATE TABLE `gameobject_spawns` (
`id` int(11) unsigned NOT NULL auto_increment,
`Entry` int(10) unsigned NOT NULL default '0',
`map` int(10) unsigned NOT NULL default '0',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`Facing` float NOT NULL default '0',
`orientation1` float NOT NULL default '0',
`orientation2` float NOT NULL default '0',
`orientation3` float NOT NULL default '0',
`orientation4` float NOT NULL default '0',
`State` int(10) unsigned NOT NULL default '0',
`Flags` int(10) unsigned NOT NULL default '0',
`Faction` int(10) unsigned NOT NULL default '0',
`Scale` float NOT NULL default '0',
`stateNpcLink` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `Map` (`map`)
) ENGINE=MyISAM AUTO_INCREMENT=960201146 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System';

[Jacob7]

Here is the download link for the logon. DOWNLOAD

[gangstajosh55]

ty so much