[Mangos Zero] mpfans server setup database issue

[madmax]

As i will be out today another member of the team will need to take this on.

This thread is for mpfans:

5.6 version installation is complete running the mangosd.exe and realmd.exe ,the error report

2016-02-26 16:30:16 Using configuration file mangosd.conf.

2016-02-26 16:30:16 World Database total connections: 2

2016-02-26 16:30:16 MySQL client library: 5.6.26

2016-02-26 16:30:16 MySQL server ver: 5.6.26-log

2016-02-26 16:30:16 MySQL client library: 5.6.26

2016-02-26 16:30:16 MySQL server ver: 5.6.26-log

2016-02-26 16:30:16 ERROR:SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

2016-02-26 16:30:16 ERROR:query ERROR: Unknown column 'structure' in 'field list'

2016-02-26 16:30:16 ERROR:The table `db_version` in your [World] database is missing or corrupt.

2016-02-26 16:30:16 ERROR:

2016-02-26 16:30:16 ERROR: [A] You have database Version: MaNGOS can not verify your database version or its existence!

2016-02-26 16:30:16 ERROR:

2016-02-26 16:30:16 ERROR: You need database Version: 21

2016-02-26 16:30:16 ERROR: Structure: 1

2016-02-26 16:30:16 ERROR: Content: 0

2016-02-26 16:30:16 ERROR: Description: revision_refactor

2016-02-26 16:30:16 ERROR:

2016-02-26 16:30:16 ERROR:Please verify your database location or your database integrity.

[madmax]

[MENTION=6072]mpfans[/MENTION]

Have you got any further with the database?

[mpfans]

no progress

[madmax]

So what have you done exactly? How are you trying to load the databases into your mysql server?

There is a bat file included. But you can also use sqlyog community edition.

[mpfans]

[MENTION=6072]mpfans[/MENTION]

Have you got any further with the database?

edit "db_version.sql " ,del Repeat "('MaNGOSZero Database Rev 21000_17',NULL,NULL)" import procedure no error

[madmax]

do you have skype i can talk to you on?

[mpfans]

do you have skype i can talk to you on?

yes.i have.. but my English is poor

[madmax]

Ok, all I could suggest is try getting SQLyog community edition and importing the needed .sql files that way.

If that does not work out for you I we could type over skype and arrange teamviewer or something for me to show you how to set it up?

[mpfans]

Ok, all I could suggest is try getting SQLyog community edition and importing the needed .sql files that way.

If that does not work out for you I we could type over skype and arrange teamviewer or something for me to show you how to set it up?

I use SQLyog community tried, but .....

please tell me your skype ID.

[madmax]

My skype is xmark202