looks like your DB is missing a bunch of tables and some colums.Thank you for the help but now I can't get past the "Authenticating" stage or it says that the information is not valid. It switches between those two when I try to log on.
server.txt
2007-11-11 08:34:02 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-11-11 08:34:02 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-11-11 08:34:02 Realm running as realm ID 1
2007-11-11 08:34:02 Using DataDir ./
2007-11-11 08:34:02 Initialize data stores...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 32 data stores
2007-11-11 08:34:03
2007-11-11 08:34:03 Cleaning up instances...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Initialized 0 instances, deleted 0 old instances
2007-11-11 08:34:03 Packing instances...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Instance numbers remapped, next instance id is 1
2007-11-11 08:34:03 Loading Game Object Templates...
2007-11-11 08:34:03 >> Loaded 11867 game object templates
2007-11-11 08:34:03
2007-11-11 08:34:03 Loading Spell Chain Data...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 1672 spell chain records
2007-11-11 08:34:03 Loading Spell Learn Skills...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 42 spell learn skills + found in DBC 74
2007-11-11 08:34:03 Loading Spell Learn Spells...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 38 spell learn spells + found in DBC 5927
2007-11-11 08:34:03 Loading Spell Proc Event conditions...
2007-11-11 08:34:03 ERROR:Error in `spell_proc_event` table, probably sql file format was updated (there should be 7 fields in sql).
realmd.txt
2007-11-11 08:37:24 Verbinde zur Datenbank: 127.0.0.1;3306;root;mangos;realmd
2007-11-11 08:37:24 Benutze Realm "Testing".
2007-11-11 08:37:24 Realmd prozess priorität HOCH
2007-11-11 08:37:24
2007-11-11 08:37:39 ERROR:SQL: SELECT `password`,`banned`,`locked`,`last_ip`,`online` FROM `account` WHERE `username` = 'SPARTS'
2007-11-11 08:37:39 ERROR:query ERROR: Unknown column 'password' in 'field list'
Thank you for help.
try to dump the database then rerun the sql again