[kobold v2] Characters.sql problems

Followed the guide ("Kobold v2 pictures included")

And i get various errors
#1- While updating\patching characters.sql
#2- While starting the batch files

#1- While updating patching characters.sql
Step #6 it says:

Quote:

-- ----------------------------
-- Table structure for characters
-- ----------------------------
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`guid` bigint(20) unsigned NOT NULL default '0',
`acct` bigint(20) unsigned NOT NULL default '0',
`data` longtext NOT NULL,
`indepData` longtext NOT NULL,
`name` varchar(21) NOT NULL default '',
`level` int(10) unsigned NOT NULL default '0',
`class` int(10) unsigned NOT NULL default '0',
`race` int(10) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`mapId` int(10) unsigned NOT NULL default '0',
`zoneId` int(10) unsigned NOT NULL default '0',
`orientation` float NOT NULL default '0',
`taximask` longtext NOT NULL,
`outfit` longtext NOT NULL,
`reputation` text NOT NULL default '',
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float NOT NULL default '0',
`taxiZ` float NOT NULL default '0',
`unlearn_count` int(11) NOT NULL default '0',
`transportGuid` bigint(32) unsigned NOT NULL default '0',
`stableSlots` tinyint(4) unsigned NOT NULL default '0',
`enumFlag` int(10) unsigned NOT NULL default '0',
`resurrectionLoc` text NOT NULL,
`instanceId` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

`reputation` text NOT NULL default '', That little part is giving me errors:

Quote:

[Err] 1101 - BLOB/TEXT column 'reputation' can't have a default value
[Msg] Finished - Unsuccessfully

>>> Screenshot of the error <<<
http://img295.imageshack.us/img295/5...shotkc2.th.jpg
>>> Screenshot of the error <<<

#2 - While starting the batch files

Code:

18 07:58:23 S Python: | -> Registering Taxi Modules 18 07:58:23 S Python: | -> Registering BattleMasters Modules 18 07:58:23 S Python: | -> Registering GuildMasters Modules 18 07:58:23 S Python: | -> Registering Banker Modules 18 07:58:23 S Python: | -> Registering Stable Master Modules 18 07:58:23 S Python: | -> Registering Auctioner Modules 18 07:58:23 S Python: |>----------------Successfully----------------<| 18 07:58:23 S Python: 18 07:58:23 S Python: |>---------Registering Custom Modules----------<| 18 07:58:23 S Python: |>----------------Successfully----------------<| 18 07:58:23 S Python: 18 07:58:23 S Python: ------------========================------------ 18 07:58:23 S Python: |ooo SETTING UP <Default NPC Texts and MenuItems> ooo| 18 07:58:23 S Python: ------------========================------------ 18 07:58:23 S Python: |>----------------Successfully----------------<| 18 07:58:23 S Python: 18 07:58:23 S Python: ------------========================------------ 18 07:58:23 S Python: |oooo Quest system ready to be used oooo| 18 07:58:23 S Python: ------------========================------------ 18 07:58:23 S Python: Spells module... 18 07:58:23 S Python: o -- o Health Level Up Reader 18 07:58:23 S Python: o -- o Health Level Up Reader 18 07:58:24 S Python: o Registering Spell Effects 18 07:58:24 S Python: -> EFFECT_SEND_EVENT 18 07:58:24 S Python: -> EFFECT_DUMMY (partially) 18 07:58:24 S Python: -> EFFECT_ACTIVATE_OBJECT 18 07:58:24 S Python: o Setting up Spell handlers : 18 07:58:24 S Python: o Quest-related spells: 18 07:58:24 S Python: Registered handler class for SpellId[19938] 18 07:58:24 S Python: o Aura Handlers: Registered handler func for Aura Id 4 18 07:58:24 S Python: o Spell scripting system ready to be used 18 07:58:24 S Python: 18 07:58:24 S Python: Player Class module... 18 07:58:24 S Python: Unit Class module... 18 07:58:24 S Python: o -- o Health Level Up Reader 18 07:58:24 S Python: Creature Class module... 18 07:58:24 S Python: o Registerring Creature Class 18 07:58:24 S Python: o Registerring Creature Class Modifier 18 07:58:24 S Python: Gameobject Class module... 18 07:58:24 S Python: o Registerring Gameobject Class 18 07:58:24 S Python: Weather Class module... 18 07:58:24 S Python: o Registerring Weather System 18 07:58:24 S Python: Item Class module... 18 07:58:24 S Python: o Registerring Item Class 18 07:58:24 S Python: Spell Class module... 18 07:58:24 S Python: Instance Class module... 18 07:58:24 S Python: o -- o Health Level Up Reader 18 07:58:24 S Python: Executables module... 18 07:58:24 S Python: Functions module... 18 07:58:24 S Python: o Setting up Core Supporting Modules : 18 07:58:24 S Python: -> Registering XP module 18 07:58:24 S Python: o Setting up Core Supporting Modules : 18 07:58:24 S Python: -> Registering XP Group module 18 07:58:24 S Python: -> Registering Damage Reduction (DR) module 18 07:58:24 S Python: -> Registering Exploration XP calculating module 18 07:58:24 S Python: scripting initialized ->>> 18 07:58:24 I Loading World coordinates... 18 07:58:24 V -------------------------------------------------- 18 07:58:24 V 44 Maps 18 07:58:24 V 629 World Area Triggers from DB 18 07:58:24 V 97 World Area Triggers from DBC 18 07:58:24 V 1081 World Zones for Maps 18 07:58:24 V -------------------------------------------------- 18 07:58:24 V World coordinates: Done! 18 07:58:24 V 18 07:58:24 I Loading Auctions... 18 07:58:24 V 0 auctions 18 07:58:24 V Precaching Taxi Environment... 18 07:58:24 V 85 taxi nodes 18 07:58:24 V 287 taxi paths 18 07:58:24 V 9582 taxi path-nodes 18 07:58:24 V Precaching Item Instances... 18 07:58:24 E sqlpp: could not query SELECT guid, type_id FROM item_instances WH E sqlpp: ERE flags = 2: Unknown column 'type_id' in 'field list' 18 07:58:24 V 0 auctioned items 18 07:58:24 E sqlpp: could not query SELECT guid, type_id FROM item_instances WH E sqlpp: ERE flags = 3: Unknown column 'type_id' in 'field list' 18 07:58:24 V 0 mailed items 18 07:58:24 V Precaching Quests... 18 07:58:25 V 3163 quest definitions 18 07:58:25 V Loading Guilds... 18 07:58:25 V 0 guilds loaded 18 07:58:25 V Precaching World... 18 07:58:25 V 23 waypoints for 5 NPCs precached 18 07:59:09 V 54094 spawned creatures 18 07:59:09 S 146 spawned creatures with AI modules 18 07:59:10 E db: go template was not found: 4 18 07:59:10 E go: failed loading spell for GO from DB! skipping... 18 07:59:10 W objmgr: found double Transport spawn GUID[F000700000000217] 18 07:59:10 W objmgr: found double Transport spawn GUID[F000700000000314] 18 07:59:10 W objmgr: found double Transport spawn GUID[F000700000000315] 18 07:59:11 E db: go template was not found: 4 18 07:59:11 E go: failed loading spell for GO from DB! skipping... 18 07:59:11 E db: go template was not found: 4 18 07:59:11 E go: failed loading spell for GO from DB! skipping... 18 07:59:12 E db: go template was not found: 4 18 07:59:12 E go: failed loading spell for GO from DB! skipping... 18 07:59:16 W objmgr: found double Transport spawn GUID[F000700000001F4B] 18 07:59:16 W objmgr: found double Transport spawn GUID[F000700000001F4C] 18 07:59:16 W objmgr: found double Transport spawn GUID[F000700000001F4D] 18 07:59:16 W objmgr: found double Transport spawn GUID[F000700000002311] 18 07:59:16 W objmgr: found double Transport spawn GUID[F000700000002313] 18 07:59:16 W objmgr: found double Transport spawn GUID[F000700000002316] 18 07:59:16 W objmgr: found double Transport spawn GUID[F000700000002317] 18 07:59:18 E db: go template was not found: 160842 18 07:59:18 E go: failed loading spell for GO from DB! skipping... 18 07:59:19 E db: go template was not found: 4 18 07:59:19 E go: failed loading spell for GO from DB! skipping... 18 07:59:19 E db: go template was not found: 4 18 07:59:19 E go: failed loading spell for GO from DB! skipping... 18 07:59:19 E db: go template was not found: 4 18 07:59:19 E go: failed loading spell for GO from DB! skipping... 18 07:59:19 E db: go template was not found: 4 18 07:59:19 E go: failed loading spell for GO from DB! skipping... 18 07:59:19 E db: go template was not found: 4 18 07:59:19 E go: failed loading spell for GO from DB! skipping... 18 07:59:19 E db: go template was not found: 4 18 07:59:19 E go: failed loading spell for GO from DB! skipping... 18 07:59:19 E db: go template was not found: 4 18 07:59:19 E go: failed loading spell for GO from DB! skipping... 18 07:59:21 V 14219 gameobjects 18 07:59:21 V Loading Corpses... 18 07:59:21 V Precaching NPC Texts... 18 07:59:21 V 2097 npc texts 18 07:59:21 V Loading international translations... 18 07:59:21 V Precaching Item Pages... 18 07:59:21 V 821 pages 18 07:59:21 V 0 pages of saved mail 18 07:59:21 V Precaching Graveyards... 18 07:59:21 V 122 graveyards 18 07:59:21 V Precaching Quest Area points 18 07:59:21 V 9 quest trigger points 18 07:59:21 V Analysing Spells for Trainers... 18 07:59:21 V 22351 Spells for Trainers 18 07:59:21 V Loading Checkpoints 18 07:59:21 V SetHighestGuids: Creating characters guids: 0x1 18 07:59:21 V SetHighestGuids: Creating creatures guids: 0x14C41 18 07:59:21 V SetHighestGuids: Creating pet_store guids: 0x14C41 18 07:59:21 V SetHighestGuids: Creating item_instances guids: 0x1 18 07:59:21 V SetHighestGuids: Creating auctionhouse guids: 0x1 18 07:59:21 V SetHighestGuids: Creating mail guids: 0x1 18 07:59:21 V SetHighestGuids: Creating guild_charters guids: 0x1 18 07:59:21 V SetHighestGuids: Creating gameobjects & corpses guids: 0xBF18 18 07:59:21 V Creating reusable guids: 18 07:59:21 V : G[34690] 18 07:59:22 V : C[30962] 18 07:59:22 V Creating reusable guids: done. 18 07:59:22 V Loading Saved Instances... 18 07:59:22 V Calling Python Support On Server Start... 18 07:59:22 S Python: OnServerStart: starting Py supporting services... 18 07:59:22 S Python: BattleGround: initialising ... 18 07:59:22 S Python: BattleGround: starting [Alterac Valley] 18 07:59:22 V mmgr: ------------------------------------------------------- 18 07:59:22 V mmgr: safeloc: M[30] -X[-8000] +X[8000] -Y[-8000] +Y[8000] 18 07:59:26 V mmgr: +: id=30 cX=321 cY=321 (103041) size_1=36 18 07:59:26 V mmgr: ------------------------------------------------------- 18 07:59:27 V mmgr: grids resolution MAP[30] X[64]/Y[64] 18 07:59:43 V instance: created: map_id[30] id[1] 18 07:59:43 S Python: BattleGround: starting [Warsong Gulch] 18 07:59:43 V mmgr: ------------------------------------------------------- 18 07:59:43 V mmgr: safeloc: M[489] -X[-8000] +X[8000] -Y[-8000] +Y[8000] 18 08:00:29 V mmgr: +: id=489 cX=321 cY=321 (103041) size_1=36 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: grids resolution MAP[489] X[64]/Y[64] 18 08:00:29 V instance: created: map_id[489] id[2] 18 08:00:29 S Python: BattleGround: starting [Arathi Basin] 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: safeloc: M[529] -X[-8000] +X[8000] -Y[-8000] +Y[8000] 18 08:00:29 V mmgr: +: id=529 cX=321 cY=321 (103041) size_1=36 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: grids resolution MAP[529] X[64]/Y[64] 18 08:00:29 V instance: created: map_id[529] id[3] 18 08:00:29 S Python: BattleGround: starting [Azshara Crater] 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: safeloc: M[37] -X[-8000] +X[8000] -Y[-8000] +Y[8000] 18 08:00:29 V mmgr: +: id=37 cX=321 cY=321 (103041) size_1=36 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: grids resolution MAP[37] X[64]/Y[64] 18 08:00:29 V instance: created: map_id[37] id[4] 18 08:00:29 S Python: BattleGround: done. 18 08:00:29 S Python: WeatherZones: registering ... 18 08:00:29 S Python: +[0]weather zone: 148 18 08:00:29 S Python: +[1]weather zone: 85 18 08:00:29 S Python: +[2]weather zone: 12 18 08:00:29 S Python: +[3]weather zone: 357 18 08:00:29 S Python: +[4]weather zone: 490 18 08:00:29 S Python: +[5]weather zone: 33 18 08:00:29 S Python: +[6]weather zone: 1 18 08:00:29 S Python: +[7]weather zone: 618 18 08:00:29 S Python: +[8]weather zone: 36 18 08:00:29 S Python: +[9]weather zone: 440 18 08:00:29 S Python: WeatherZones: done with 10 zones registered. 18 08:00:29 V ---- Finished >> 18 08:00:29 I Populating world with objects... 18 08:00:29 V Placing creatures 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: safeloc: M[0] -X[-16000] +X[7500] -Y[-19200] +Y[16000] 18 08:00:29 V mmgr: +: id=0 cX=471 cY=705 (332055) size_1=36 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: grids resolution MAP[0] X[64]/Y[64] 18 08:00:29 V mmgr: ------------------------------------------------------- 18 08:00:29 V mmgr: safeloc: M[1] -X[-11800] +X[12800] -Y[-19800] +Y[17000] 18 08:00:30 V mmgr: +: id=1 cX=493 cY=737 (363341) size_1=36 18 08:00:30 V mmgr: ------------------------------------------------------- 18 08:00:30 V mmgr: grids resolution MAP[1] X[64]/Y[64] 18 08:00:31 V mmgr: ------------------------------------------------------- 18 08:00:31 V mmgr: safeloc: M[369] -X[-8000] +X[8000] -Y[-8000] +Y[8000] 18 08:00:31 V mmgr: +: id=369 cX=321 cY=321 (103041) size_1=36 18 08:00:31 V mmgr: ------------------------------------------------------- 18 08:00:31 V mmgr: grids resolution MAP[369] X[64]/Y[64] 18 08:00:48 V mmgr: ------------------------------------------------------- 18 08:00:48 V mmgr: safeloc: M[450] -X[-8000] +X[8000] -Y[-8000] +Y[8000] 18 08:00:48 V mmgr: +: id=450 cX=321 cY=321 (103041) size_1=36 18 08:00:48 V mmgr: ------------------------------------------------------- 18 08:00:48 V mmgr: grids resolution MAP[450] X[64]/Y[64] 18 08:00:58 V mmgr: ------------------------------------------------------- 18 08:00:58 V mmgr: safeloc: M[449] -X[-8000] +X[8000] -Y[-8000] +Y[8000] 18 08:00:58 V mmgr: +: id=449 cX=321 cY=321 (103041) size_1=36 18 08:00:58 V mmgr: ------------------------------------------------------- 18 08:00:58 V mmgr: grids resolution MAP[449] X[64]/Y[64] 18 08:01:01 V 54415 creatures 18 08:01:01 V Placing player corpses 18 08:01:01 V 0 corpses 18 08:01:01 V Placing gameobjects 18 08:01:02 V 14392 gameobjects 18 08:01:02 I Initial server settings done! 18 08:01:02 V -------------------------------------------------- 18 08:01:02 V auction: << AUCTION SERVER >> 18 08:01:02 V auction: processing auctions... 18 08:01:02 V auction: << AUCTION SERVER >> : Success! 18 08:01:02 V mail: << MAIL SERVER >> 18 08:01:02 V mail: parsing mail... 18 08:01:02 V mail: << MAIL SERVER >> : Success! 18 08:01:02 V hs: << HONOR SYSTEM >> 18 08:01:02 V hs: processing honor status for players... 18 08:01:02 V hs: processing daily honor status for players... 18 08:01:02 W empty honor table 18 08:01:02 V hs: daily honor status updated 18 08:01:02 V hs: clear daily kills 18 08:01:02 V hs: << HONOR SYSTEM >> : Success! 18 08:01:02 I Network: TCP Port 4200 listener started 18 08:01:02 V Getting WS info from DB: 18 08:01:02 I WorldSrv: listening at: 127.0.0.1:4200 18 08:01:02 I WorldSrv: <<<-- Accepting client connections -->>> Accept: Client connected = [127.0.0.1] - [1660] 18 08:21:02 V auction: << AUCTION SERVER >> 18 08:21:02 V auction: processing auctions... 18 08:21:02 V auction: << AUCTION SERVER >> : Success!

Errors i get while creating character:

[CODE]
[COLOR="Red"] E sqlpp: 0 0 0 0 0 0 0 20 20 ', 1, 3, '0 ' ) ]
18 08:42:58 E item: error: db << guid[4000000000000019] flags[1]
18 08:42:58 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:58 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387926, '22 1073741824 3 38 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 ', '22 1073741824 3 38 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 ', 1, 3, '0 ' ) ]
18 08:42:58 E item: error: db << guid[4000000000000016] flags[1]
18 08:42:58 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:58 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387927, '23 1073741824 3 39 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 25 25 ', '23 1073741824 3 39 1065353216 0 4 0 4 0 0 0 0
E sqlpp: 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 25 25 ', 1, 3, '0 ' ) ]
18 08:42:58 E item: error: db << guid[4000000000000017] flags[1]
18 08:42:58 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:58 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387928, '24 1073741824 3 40 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 100 100 ', '24 1073741824 3 40 1065353216 0 4 0 4 0 0 0
E sqlpp: 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 100 100 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000018] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387929, '25 1073741824 3 25 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 1900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 20 20 ', '25 1073741824 3 25 1065353216 0 4 0 4 0 0
E sqlpp: 0 0 0 1 1900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 20 20 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000019] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387930, '26 1073741824 3 2362 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 20 20 ', '26 1073741824 3 2362 1065353216 0 4 0 4 0 0
E sqlpp: 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 20 20 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[400000000000001A] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387925, '21 1073741824 3 6948 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 ', '21 1073741824 3 6948 1065353216 0 4 0 4 0 0 0
E sqlpp: 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000015] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387930, '26 1073741824 3 2362 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 20 20 ', '26 1073741824 3 2362 1065353216 0 4 0 4 0 0
E sqlpp: 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 20 20 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[400000000000001A] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387926, '22 1073741824 3 38 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 ', '22 1073741824 3 38 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000016] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387927, '23 1073741824 3 39 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 25 25 ', '23 1073741824 3 39 1065353216 0 4 0 4 0 0 0 0
E sqlpp: 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 25 25 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000017] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387928, '24 1073741824 3 40 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 100 100 ', '24 1073741824 3 40 1065353216 0 4 0 4 0 0 0
E sqlpp: 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 100 100 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000018] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387929, '25 1073741824 3 25 1065353216 0 4 0 4 0 0 0 0 0 1
E sqlpp: 1900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 20 20 ', '25 1073741824 3 25 1065353216 0 4 0 4 0 0
E sqlpp: 0 0 0 1 1900 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 20 20 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000019] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387930, '26 1073741824 3 2362 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 20 20 ', '26 1073741824 3 2362 1065353216 0 4 0 4 0 0
E sqlpp: 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 20 20 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[400000000000001A] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387925, '21 1073741824 3 6948 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 ', '21 1073741824 3 6948 1065353216 0 4 0 4 0 0 0
E sqlpp: 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[4000000000000015] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387931, '27 1073741824 3 117 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 4 0 1 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 ', '27 1073741824 3 117 1065353216 0 4 0 4 0 0 0
E sqlpp: 0 0 4 0 1 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 0 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[400000000000001B] flags[1]
18 08:42:59 E sqlpp: error executing query, error code[1][Unknown column 'type_i
E sqlpp: d' in 'field list']
18 08:42:59 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
E sqlpp: `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
E sqlpp: 7387931, '27 1073741824 3 117 1065353216 0 4 0 4 0 0 0 0 0
E sqlpp: 4 0 1 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 ', '27 1073741824 3 117 1065353216 0 4 0 4 0 0 0
E sqlpp: 0 0 4 0 1 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 0 ', 1, 3, '0 ' ) ]
18 08:42:59 E item: error: db << guid[400000000000001B] flags[1]
18 08:42:59 S Python: Setting Action Buttons ...
18 08:42:59 S Python: Init class: Warrior
18 08:42:59 S Python: Setting Initial Values for Health/Mana/RAGE/ENERGY (1st Le
S Python: vel) ...
18 08:42:59 V player: Init Reputation
18 08:42:59 E sqlpp: error executing query, error code[1][Field 'reputation' doe
E sqlpp: sn't have a default value]
18 08:42:59 E sqlpp: your failed query[REPLACE INTO characters (guid, acct, name
E sqlpp: , level, class, race, mapId, zoneId, positionX, positionY,
E sqlpp: positionZ, orientation, data, indepData, taximask, outfit,
E sqlpp: skills, taxiX, taxiY, taxiZ, unlearn_count, transportGuid,
E sqlpp: stableSlots, enumFlag, resurrectionLoc, instanceId) VALUES
E sqlpp: (4, 3, 'Conna', 1, 1, 7, 0, 1, -6240.32, 331.033, 382.758,
E sqlpp: 1, '4 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 50 65 1000 100 100 0 1 115 16843015 0 0 0 0 0 0
E sqlpp: 0 0 0 262152 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1900 2
E sqlpp: 000 0 1050455048 1069547520 1564 1564 0 1081501288 10860101
E sqlpp: 64 1077936129 1077936129 0 0 0 0 0 0 0 1065353216 0 0 0 0 1
E sqlpp: 9 23 21 23 20 53 0 0 0 0 0 0 40 60 0 21 0 0 27 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33947652 33554437 1 0 4
E sqlpp: 008636142 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E sqlpp: 0 0 0 0 0

Solution = waiting for reply (space reserved)

PS: I can connect to the server but i cannot make a character (once i hit accept it doesnt create it)

Quote:

Originally Posted by Arkalite

Solution = waiting for reply (space reserved)

PS: I can connect to the server but i cannot make a character (once i hit accept it doesnt create it)

Make this:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`guid` bigint(20) unsigned NOT NULL default '0',
`acct` bigint(20) unsigned NOT NULL default '0',
`data` longtext NOT NULL,
`indepData` longtext NOT NULL,
`name` varchar(21) NOT NULL default '',
`level` int(10) unsigned NOT NULL default '0',
`class` int(10) unsigned NOT NULL default '0',
`race` int(10) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`mapId` int(10) unsigned NOT NULL default '0',
`zoneId` int(10) unsigned NOT NULL default '0',
`orientation` float NOT NULL default '0',
`taximask` longtext NOT NULL,
`outfit` longtext NOT NULL,
`reputation` bigint(20) unsigned NOT NULL default '0',
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float NOT NULL default '0',
`taxiZ` float NOT NULL default '0',
`unlearn_count` int(11) NOT NULL default '0',
`transportGuid` bigint(32) unsigned NOT NULL default '0',
`stableSlots` tinyint(4) unsigned NOT NULL default '0',
`enumFlag` int(10) unsigned NOT NULL default '0',
`resurrectionLoc` text NOT NULL,
`instanceId` int(10) unsigned NOT NULL default '0',
`actionButtons` longtext,
`tutorials` longtext,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Work fine!!!

PS: sorry for my english

OMG, thx i never thought i was gonna get a reply!!!
i can login and create the character and play ^_^

One last minor detail... hes without any clothing or weaponds =(
kinda need that last part ;)

Ya i have the same problem...my character doesnt have clothes on and when i exit the game after getting items, they all disapear when i log back in...can someone help me with this? It seems to be my only problem.

Same hare! I am going to change to Laughing Onyxia's db

hm, still got the cloths bug dose any one know how to fix it ? This is my only problem to.

Bump

Bump...can someone plz help us with this problem...btw i also noticed that when switching areas (using the .recall command) the items that i had on disapear again. And the modifications that i make dont stay either eg. changing my health to like 5000 or something.

is there possibly a .ws unlock command.. like in the UWC 1.3.4 ?

or a .save command

Yes there is a .save command which DOES save your character...items, level, talents...etc. everything. I somehow figured how to keep the items on your character...I looked over my tables in Navicat and made sure that i had everything in the Sql update folder 2 in the Kobold Server Lite folder. Re-imported the tables...and found that one wasnt put inbefore...and it fixed the problem. BTW make sure after changing your tables around and editing that you make a new character to test it. Otherwise it wont work. There is also a file in your WTF folder under your characters account name that I was suggested to delete to fix the problem...its like mnd5. something i dont remember, but it supposibly fixes this. Try both.

thanks 098pad! haven't tested it yet but I will soon.

Need Help.... how to fix this err

i found this error after update server from kobold v1 to kobold v2
i use AceIndy Translated V2 DB

Quote:

04/12/2006 21:40:53 S Python: Init class: Mage
04/12/2006 21:40:53 S Python: Setting Initial Values for Health/Mana/RAGE/ENERGY (1st Level) ...
04/12/2006 21:40:53 S Python: ApplyModifier: 1 5 0 0 29447 0
04/12/2006 21:40:53 S Python: ApplyModifier: 1 0 0 0 12848 0
04/12/2006 21:40:53 E Unknown affect id 182 of spell 28574
04/12/2006 21:40:53 W mod: Unsupported SPELL_AURA_ADD_TARGET_TRIGGER
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 W mod: Unsupported SPELL_AURA_OVERRIDE_CLASS_SCRIPTS
04/12/2006 21:40:53 W mod: Unsupported SPELL_AURA_ADD_TARGET_TRIGGER
04/12/2006 21:40:53 E flatmod: out of range flatmod type[27]
04/12/2006 21:40:53 W mod: Unsupported SPELL_AURA_OVERRIDE_CLASS_SCRIPTS
04/12/2006 21:40:53 W mod: Unsupported SPELL_AURA_OVERRIDE_CLASS_SCRIPTS
04/12/2006 21:40:53 S Python: ApplyModifier: 1 30 0 0 29076 0
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: 1 result[0.0]
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: 1 result[0.0]
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: 1 result[0.0]
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 S Python: ApplyModifier: 1 0 0 0 28764 0
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: 1 result[0.0]
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:53 V affect: _ApplyPassiveSpell - add affect
04/12/2006 21:40:53 V Unit::_AddAura() - success
04/12/2006 21:40:54 V db: << player guid[77] name[Mely]: done
04/12/2006 21:41:01 S Python: ApplyModifier: 0 5 0 0 29447 0
04/12/2006 21:41:01 S Python: ApplyModifier: 0 0 0 0 12848 0
04/12/2006 21:41:01 E Unknown affect id 182 of spell 28574
04/12/2006 21:41:01 W mod: Unsupported SPELL_AURA_ADD_TARGET_TRIGGER
04/12/2006 21:41:01 W mod: Unsupported SPELL_AURA_OVERRIDE_CLASS_SCRIPTS
04/12/2006 21:41:01 S Python: ApplyModifier: 0 0 0 0 28764 0
04/12/2006 21:41:01 W mod: Unsupported SPELL_AURA_ADD_TARGET_TRIGGER
04/12/2006 21:41:01 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: -1 result[0.0]
04/12/2006 21:41:01 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: -1 result[0.0]
04/12/2006 21:41:01 E flatmod: out of range flatmod type[27]
04/12/2006 21:41:01 W mod: Unsupported SPELL_AURA_OVERRIDE_CLASS_SCRIPTS
04/12/2006 21:41:01 W mod: Unsupported SPELL_AURA_OVERRIDE_CLASS_SCRIPTS
04/12/2006 21:41:01 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: -1 result[0.0]
04/12/2006 21:41:01 S Python: ApplyModifier: 0 30 0 0 29076 0
04/12/2006 21:41:01 W mod[not supported by core]: SPELL_AURA_MOD_SPELL_HIT_CHANCE: -1 result[0.0]
04/12/2006 21:41:01 W ApplyModifier: already [REMOVED]

how to fix this error
sorry my eng lang is very poor

um hay dose any 1 know how to tranfer charector from a old serve to a new 1

Quote:

Originally Posted by smiling

um hay dose any 1 know how to tranfer charector from a old serve to a new 1

use export wizard in navicat.export to sql file

right click on character table fine export wizard.

sorry my eng lang is very poor