Still having this problem...

[latruwski]

i tried executing a txt file with this in it:

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`)
)

did you try copy paste into a query in navicat? cuz it is working perfectly for me....

edit you could try this too:

CREATE TABLE `gameobject_spawns2` (
`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`)
);

[gangstajosh55]

any1 else have any solutions??

[gangstajosh55]

kk the code u just gave me worked. i tried executing it w/o the db already in navicat/ just made a new db and executed the code and the table worked.

[gangstajosh55]

nvm going to try something else. going to first put the db in and then try to run the code. trying to execute it again and getting the same error so when its done ill execute the code and see how it goes.

[gangstajosh55]

ok the code worked but my objects still rnt staying do i have to add anything to the new table?

[datastream]

i went in the sql file and just subed this out for the code you gave. thanks! it worked!