MaNGOS(Can't log into server)

[3wasLt]

Hello, i have a MaNGOS sever, but when i open MaNGOS.exe i get an error.

''
2007-06-10 01:28:50 World Database: 127.0.0.1;3306;root;mohebi001;mangos_bc
2007-06-10 01:28:50 Login Database: 127.0.0.1;3306;root;mohebi001;realmd_bc
2007-06-10 01:28:50 Realm running as realm ID 1
2007-06-10 01:28:50 Using DataDir ./
2007-06-10 01:28:50 Initialize data stores...
2007-06-10 01:28:50
2007-06-10 01:28:50 >> Loaded 28 data stores
2007-06-10 01:28:50
2007-06-10 01:28:50 Loading Game Object Templates...
2007-06-10 01:28:51 >> Loaded 10439 game object templates
2007-06-10 01:28:51
2007-06-10 01:28:51 Loading player Create Info & Level Stats...
2007-06-10 01:28:51 ERROR:SQL: SELECT `race`,`class`,`map`,`zone`,`position_x`,`position_y`,`position_z`,`displayID` FROM `playercreateinfo`
2007-06-10 01:28:51 ERROR:query ERROR: Unknown column 'displayID' in 'field list'
2007-06-10 01:28:51
2007-06-10 01:28:51 >> Loaded 0 player create definitions
2007-06-10 01:28:51 ERROR:Error loading `playercreateinfo` table or table empty.''


When i login with my username and password, it says that it's wrong. Any help would be appreciated.

To view the content, you need to sign in or register

(something of what it looks like)

 

[aitorsz]

Update you database

 

[3wasLt]

Update you database

Ok i did that, thanks alot. But im getting a new error now

''2007-06-10 11:21:02 World Database: 127.0.0.1;3306;root;mohebi001;mangos
2007-06-10 11:21:02 Login Database: 127.0.0.1;3306;root;mohebi001;realmd_bc
2007-06-10 11:21:02 Realm running as realm ID 1
2007-06-10 11:21:02 Using DataDir ./
2007-06-10 11:21:02 Initialize data stores...
2007-06-10 11:21:03
2007-06-10 11:21:03 >> Loaded 28 data stores
2007-06-10 11:21:03
2007-06-10 11:21:03 Loading Game Object Templates...
2007-06-10 11:21:03 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 18 fields in sql).''

When i open MaNGOS this is what happens.

 

[3wasLt]

Anyone, please help.

 

[FamineMK]

Your database is either too new or too old. Your build of MaNGOS doesn't recognize the database structure. You need to get versions of MaNGOS that match the Database you are using.

 

[kennythekid]

i guess your using the latest core ... since have been done alot of changes in the structure you need to get you db full updated ... well doesn't quite matter this its not about Sdb its about applying all the sql update provided by the mangos core that your database doesn't contain
in your case look for gameobject_template changes in mangos Sql directory apply them if you get an error while applying you have it allready if not its ok
if you don't have the latest sdb database means you don't have the latest in-game fixes the strucure fixes comes from mangos core

 

[3wasLt]

Thanks alot for the help guys, it works fine now. <3