Characters Not There ?

[Darkwow]

Hey. I am running a MaNGOS server 2.4.3, and I started and logged into my account (GM Lvl 3). I logged in, no problems, made a character, but when it brought me back to my character list, It showed a blank slate. I tried using different accounts, creating different ones, etc. but I still get the same blank list. Can anyone help with this ?

[arley]

check and see at your world console, see if there are any errors. usually there should be one rite after u created the char. im thinking there should be a query error

[latruwski]

check your database... your playercreateinfo tables need updates... (i dont know exacly how they are called in mangos)

grtz

[Darkwow]

OK then. I didn't know which was the one you were talking about so here's all the logs (or queries as you call them) with their titles

Char:
2008-07-25 14:04:16 Account: 2 (IP: 127.0.0.1) Create Character:[Jack]
2008-07-25 14:04:37 Account: 2 (IP: 127.0.0.1) Create Character:[Jack]
2008-07-25 14:04:56 Account: 2 (IP: 127.0.0.1) Create Character:[Behobuus]
2008-07-25 14:05:10 Account: 2 (IP: 127.0.0.1) Create Character:[Mokazumi]
2008-07-25 14:05:43 Account: 1 (IP: 127.0.0.1) Create Character:[Cart]
2008-07-25 14:15:30 Account: 5 (IP: 127.0.0.1) Create Character:[Roflcopter]
2008-07-25 14:38:23 Account: 4 (IP: 127.0.0.1) Create Character:[Darkwow]

DBerrors:2008-07-25 13:55:14 SQL: DELETE FROM corpse WHERE corpse_type = '0'
2008-07-25 13:55:14 SQL ERROR: Unknown column 'corpse_type' in 'where clause'
2008-07-25 13:55:17 SQL: SELECT mapid, resettime FROM instance_reset
2008-07-25 13:55:17 query ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime < '1217008517' AND instance.resettime > '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1217008517')
2008-07-25 13:55:17 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 SQL: INSERT INTO instance_reset VALUES ('249','4182020032')
2008-07-25 13:55:17 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2008-07-25 13:55:17 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-25 13:55:17 SQL: INSERT INTO instance_reset VALUES ('269','1839038400')
2008-07-25 13:55:17 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
2008-07-25 13:55:17 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-25 13:55:17 SQL: INSERT INTO instance_reset VALUES ('309','2137001920')

Server:2008-07-25 13:55:13 World Database: 127.0.0.1;3306;root;root;mangos
2008-07-25 13:55:13 MySQL client library: 5.0.56
2008-07-25 13:55:13 MySQL server ver: 5.1.25-rc-community
2008-07-25 13:55:13 Character Database: 127.0.0.1;3306;root;root;characters
2008-07-25 13:55:13 MySQL client library: 5.0.56
2008-07-25 13:55:13 MySQL server ver: 5.1.25-rc-community
2008-07-25 13:55:13 Login Database: 127.0.0.1;3306;root;root;realmd
2008-07-25 13:55:13 MySQL client library: 5.0.56
2008-07-25 13:55:13 MySQL server ver: 5.1.25-rc-community
2008-07-25 13:55:13 Realm running as realm ID 1
2008-07-25 13:55:13 Using UDB 0.10.3 (357) for MaNGOS rev. 6240 with SD2 SQL for rev. 473
2008-07-25 13:55:13 Using DataDir ./
2008-07-25 13:55:13 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-07-25 13:55:13 WORLD: VMap data directory is: ./vmaps
2008-07-25 13:55:13 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-07-25 13:55:14
2008-07-25 13:55:14 Loading MaNGOS strings...
2008-07-25 13:55:14
2008-07-25 13:55:14 >> Loaded 503 MaNGOS strings
2008-07-25 13:55:14 Initialize data stores...
2008-07-25 13:55:14 ERROR:SQL: DELETE FROM corpse WHERE corpse_type = '0'
2008-07-25 13:55:14 ERROR:SQL ERROR: Unknown column 'corpse_type' in 'where clause'
2008-07-25 13:55:17
2008-07-25 13:55:17 >> Loaded 55 data stores
2008-07-25 13:55:17
2008-07-25 13:55:17 Using Autodetected DBC Locale (0).

2008-07-25 13:55:17 Loading InstanceTemplate
2008-07-25 13:55:17 >> Loaded 51 Instance Template definitions
2008-07-25 13:55:17
2008-07-25 13:55:17 Loading SkillLineAbilityMultiMap Data...
2008-07-25 13:55:17
2008-07-25 13:55:17 >> Loaded 7025 SkillLineAbility MultiMap
2008-07-25 13:55:17 Cleaning up instances...
2008-07-25 13:55:17 ERROR:SQL: SELECT mapid, resettime FROM instance_reset
2008-07-25 13:55:17 ERROR:query ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 ERROR:SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime < '1217008517' AND instance.resettime > '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1217008517')
2008-07-25 13:55:17 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 ERROR:SQL: INSERT INTO instance_reset VALUES ('249','4182020032')
2008-07-25 13:55:17 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 ERROR:SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2008-07-25 13:55:17 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-25 13:55:17 ERROR:SQL: INSERT INTO instance_reset VALUES ('269','1839038400')
2008-07-25 13:55:17 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 ERROR:SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
2008-07-25 13:55:17 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-25 13:55:17 ERROR:SQL: INSERT INTO instance_reset VALUES ('309','2137001920')
2008-07-25 13:55:17 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-25 13:55:17 ERROR:SQL: INSERT INTO instance_reset VALUES ('409','1932070848')

Realmd:
2008-07-25 13:55:10 Using configuration file realmd.conf.
2008-07-25 13:55:10 MaNGOS/0.12.0-SVN (Revision 6372) (Win32,little-endian) (realm-daemon)
2008-07-25 13:55:10 <Ctrl-C> to stop.

2008-07-25 13:55:10 Database: 127.0.0.1;3306;root;root;realmd
2008-07-25 13:55:10 MySQL client library: 5.0.56
2008-07-25 13:55:10 MySQL server ver: 5.1.25-rc-community
2008-07-25 13:55:10 Added realm "MaNGOS".
2008-07-25 13:55:10 realmd process priority class set to HIGH
2008-07-25 13:55:10

I would apprecaite any help/tips. Thanks.

[Darkwow]

and lawtruski, im sorry, but i dont know what you want me to do. D:
Im kind of a noobie at this, but I understand alot more than most people.
Any extra instructions would be great.

[latruwski]

you dont seem to have a character DB...

https://mangos.svn.sourceforge.net/s...characters.sql

that is character DB

[Naxxiusrawr]

that blows dude.

[Darkwow]

K what do I do with the CharacterDB ? Is there any extra steps ? Thanks for the help.

[C.C.]

You execute it to a db in sqlyog.

[Darkwow]

How would I do that ? I have SQLYog, Connected it to my server, I have my my tables, but how do i put it in there ?