character createing problems with mangos

[Mat15]

Hey its me again

Compiled mangos sofar all is good but, when i make a character and click create it just goes to the selection screen but don't list the character i've just made,i don't get a mysql error so its some what confusieng me.

By the way i'm useing silvers db.

[MentaL]

[Serapher]

I am having the exact same problem. Whenever I go to make a character, I click accept, and it brings me back to the character selection screen, with no characters available. I am running the latest posted mangos, 2665 i believe, with silvers db. Please let me know how I can fix this, or direct me to where I can find the answers.

Thanks.
Serapher

[bianu]

I am having the exact same problem. Whenever I go to make a character, I click accept, and it brings me back to the character selection screen, with no characters available. I am running the latest posted mangos, 2665 i believe, with silvers db. Please let me know how I can fix this, or direct me to where I can find the answers.

Thanks.
Serapher

that error have in Kobolds v2 server too. The correction is creating an file in notepad called characters.sql . Inside of it, put this code:

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;

Then Save the file. CHECK THE EXTENSION, need be .sql

In Navicat, delete character table, and right-click on server database, then click on Execute Batch File, and select characters.sql

I hope help.

[Serapher]

Ok, so, I just got the newest version of MaNGOS, loaded all that in. Download your Silvers DB, rev 272 is what i am using. add the silvers DB into your Mangos database in your SQL editor, I am using Navicat, and its pretty easy. After that, BE SURE TO ADD THE MANGOS.SQL from the Updated mangos revision. In other words, you are executing two files, your silver db, and the default mangos.sql. It is important, i think, to do silvers first, then the regular. after that, you should fix your character creation problem.

good luck

Serapher