[Kobold] Character Error

[DigitalEffect]

[QUOTE]16 22:43:38 E sqlpp: error executing query, error code[1][Field 'reputation' doe
E sqlpp: sn't have a default value]
16 22:43:38 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: (2, 1, 'Emia', 1, 8, 5, 0, 85, 1676.35, 1677.45, 121.67, 3.
E sqlpp: 14, '2 0 25 0 1065353216 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 62 140 0 100 100 0 1 5 2053 0 0 0 0 0 0 0 0 0 2
E sqlpp: 62152 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
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 2900 2000 0 1
E sqlpp: 050455048 1069547520 57 57 0 1083942971 1088137275 0 0 0 0
E sqlpp: 0 0 0 0 0 1065353216 0 0 0 0 19 18 21 21 27 41 0 0 0 0 0 0
E sqlpp: 145 72 0 9 0 0 18 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 100861188 33554438 0 0 4008636142 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 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: 6090 0 0 ╝☺

[MentaL]

[resinate]

same here pls post a fix

[qazqwertyqaz]

same here
and the good guys of emupedia dont want help us!
damn they says to replace the character table with the old one,
but wont work!
help again!
thx

[resinate]

ok i got it lol. u have to use the 3.2 server db for sql and it works perfect

[aceindy]

ALTER TABLE `characters` CHANGE COLUMN `reputation` `reputation` text NOT NULL default '' AFTER `outfit`;

[aceindy]

ALTER TABLE `characters` CHANGE COLUMN `reputation` `reputation` text NOT NULL default '' AFTER `outfit`;

[qazqwertyqaz]

drop character table and run this:

/*
MySQL Data Transfer
Source Host: localhost
Source Database: wow_server
Target Host: localhost
Target Database: wow_server
Date: 17.11.2006 13:13:26
*/

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,
`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(20) 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,
`status` int(2) default '0',
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------



--------------------------------------------------------------------------
THIS WORK!
TRY!

[aceindy]

Lol...sure...keep on dropping...why do it easy the easy way if you can do it the hard way :P

You DO realise you loose all data & triggers when you start dropping tables?

[qazqwertyqaz]

if you drop only the character table you dont lost anything!
and if you want know your metods wont work!
only this work and another one!
so if you want make working your luddy,
search the other metod or drop that fu table and replace with that!
-----------------------------------------
Angry Gren
-----------------------------------------