Still having this problem...

[gangstajosh55]

ok i have a problem where my gameobjects arent saving. Every repack i use ive been getting this error when executing th .sql:

[Err] 1115 - Unknown character set: 'cp1251'
[Err] 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=103523 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System';

I do the thing with the 1 after the id and i also do the saveall thing and nothing. it doesnt work. pls help me

[gangstajosh55]

also when it gets to the gameobject table adding in the executing, i get a bunch of errors with the gameobject tables

[latruwski]

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=2107173 /*!40100 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System'*/;

should work like a charm...

[gangstajosh55]

kk i made a text document and ran it and got this:

[Err] 1115 - Unknown character set: 'cp1251'
[Err] 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=2107173 /*!40100 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System'*/;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[latruwski]

kk i made a text document and ran it and got this:

[Err] 1115 - Unknown character set: 'cp1251'
[Err] 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=2107173 /*!40100 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System'*/;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

i copy pasted in a query and worked perfectly.... what MySQL server are you using? and what program are you using to import it?

[gangstajosh55]

im using mysql 5.0 and im using navicat

[Chrispee]

first delete gameobject_spawns from your db but if i where u i would backup the one u have in the db cause if u will run the query u will have just the table and no records 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`)
) ENGINE=MyISAM AUTO_INCREMENT=2107173 /*!40100 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System'*/;

[gangstajosh55]

hmm i just looked in my db and noticed there was no gameobject_spawns there

[gangstajosh55]

still having this problem :/

[waymirec]

try not specifying the default charset..

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

[gangstajosh55]

ill try that code when its done executing. trying a 2.4.1 repack and getting that issue wih my world.gameobject_spawns saying it doesnt exist. ive gotten 35399 errors all with my world.gameobject_spawns

[gangstajosh55]

kk just tried that code got the same error and got this:

[Err] 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 '' at line 19

[gangstajosh55]

any ideas??

[latruwski]

kk just tried that code got the same error and got this:

[Err] 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 '' at line 19

post line 1-30 of the file you were trying to execute...

[gangstajosh55]

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