am I in a wrong way?

[xiazai]

hi guys,I've tried to refresh the database 0.12.1 with madmax's 0.18.1 .sql files.

I did't delete the old database 0.12.1 just did importation on the database.

I imported the .sql files in sequence like below:

characters.sql

mangos.sql

mangos_full_db.sql

realmd.sql

mangos_scriptname_clear.sql

mangos_scriptname_full.sql

scriptdev2_create_database.sql

scriptdev2_create_structure_mysql.sql

scriptdev2_script_full.sql

mangos_optional_generic_creature.sql

no errors came out.(I wonder if I miss some .sql files to import.)

then I copied my old sever0.12.1 folders like DBC,MAPS,VMAPS to new server0.18.1 folder,

and run realmd.exe,it is ok,log file showed :

2014-07-02 21:19:22 mangos-zero/0.18.1 (07/04/2014 10:00 AM Revision 2462 - a02f520e508646c280b260fcef74b8310acdb465) for Win32 (little-endian) [realm-daemon]

2014-07-02 21:19:22 <Ctrl-C> to stop.

2014-07-02 21:19:22 Using configuration file ./realmd.conf.

2014-07-02 21:19:22 Login Database total connections: 2

2014-07-02 21:19:22 MySQL client library: 5.5.37

2014-07-02 21:19:22 MySQL server ver: 5.0.16-nt

2014-07-02 21:19:22 MySQL client library: 5.5.37

2014-07-02 21:19:22 MySQL server ver: 5.0.16-nt

2014-07-02 21:19:22 Added realm id 1, name 'MaNGOS'

2014-07-02 21:19:22 realmd process priority class set to HIGH

2014-07-02 21:19:22

then there are mangosd.exe and mangosd.conf in the same folder,but when i run the mangosd.exe it tells "Could not find configuration file ./mangosd.conf." what can do to handle this?

is the way I chose that update 0.12.1 to 0.181 right? I appreciate your help.

best regards.

[Hikari]

You didn't update your database. You've just overwritten it. Nevertheless, this means your database is up to date for the revision you use.

Make sure the configuration file is named mangosd.conf and not mangosd.conf.dist.in or mangosd.conf.txt (hidden expansions).

The other option I heard was, that there might be problems if the file is encoded in ANSI or was it UTF-8? Anyway save the file in the opposite encoding as it currently is and try it again.

[xiazai]

thank you very much,Hikari. I deleted the databases mangos,charactors,realmd,scriptdev2 and imported those .sql files.now I can startup the mangos server,game can logged in and played.but there are some errors appeared in server.log(please forgive me my poor English i will write the post in chinese):

No1 error 实事上,我不太懂这是什么错误,原谅我是个新手

2014-07-05 21:16:19 >> Loaded 27892 Item Enchantment definitions

2014-07-05 21:16:19 Loading Items...

2014-07-05 21:16:20 >> Loaded 14398 item prototypes

2014-07-05 21:16:20

2014-07-05 21:16:20 ERROR:Item (Entry: 765) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 785) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 2447) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 2449) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 2450) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 2452) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 2453) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 2931) has wrong Subclass value (1) for class 15

2014-07-05 21:16:20 ERROR:Item (Entry: 3355) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3356) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3357) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3358) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3369) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3818) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3819) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3820) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 3821) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 4625) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 8153) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 8831) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 8836) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 8838) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 8839) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 8845) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 8846) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 13463) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 13464) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 13465) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 13466) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 13467) has wrong Subclass value (9) for class 7

2014-07-05 21:16:20 ERROR:Item (Entry: 13468) has wrong Subclass value (9) for class

No.2 error entr 15118 我查了一下 名字叫Master Angler Form,不知道它是什么,在网上没有图片

2014-07-05 21:16:22 >> Loaded 9091 creature definitions

2014-07-05 21:16:22

2014-07-05 21:16:22 ERROR:Creature (Entry: 15118) has nonexistent faction_A template (0)

2014-07-05 21:16:22 ERROR:Creature (Entry: 15118) has nonexistent faction_H template (0)

No.3 error 这个问题是要RegenHealth=Curehealth? by the way,what's RegenHealth ？

2014-07-05 21:16:24 Loading Creature Data...

2014-07-05 21:16:25 ERROR:Table `creature` have creature (GUID: 4770 Entry: 4949) with `creature_template`.`RegenHealth`=1 and low current health (40000),

No.4 error 不知道怎么修改

2014-07-05 21:16:44 >> Loaded 233513 loot definitions (4406 templates)

2014-07-05 21:16:44 ERROR:Table 'creature_loot_template' entry 1 isn't creature entry and not referenced from loot, and then useless.

No.5 error 完全不知道怎么修改

2014-07-05 21:17:04 >> Loaded 19 CreatureEventAI summon definitions

2014-07-05 21:17:04 Loading CreatureEventAI Scripts...

2014-07-05 21:17:05 ERROR CreatureEventAI: Event 22301 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-05 21:17:05 ERROR CreatureEventAI: Event 27701 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-05 21:17:05 ERROR CreatureEventAI: Event 27901 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-05 21:17:05 ERROR CreatureEventAI: Event 29701 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-05 21:17:05 ERROR CreatureEventAI: Event 33101 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

No.6 这不是错误,只是有些表是空的,不知道这会不会影响游戏？

2014-07-05 21:16:57 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.

2014-07-05 21:16:50 Loading Vendors...

2014-07-05 21:16:50

2014-07-05 21:16:50 >> Loaded `npc_vendor_template`, table is empty!

2014-07-05 21:16:51

2014-07-05 21:16:51 >> Loaded 12549 vendor items

2014-07-05 21:16:51 Loading Trainers...

2014-07-05 21:16:51

2014-07-05 21:16:51 >> Loaded `npc_trainer_template`, table is empty!

2014-07-05 21:16:21 Loading Equipment templates...

2014-07-05 21:16:21 ERROR:creature_equip_template table is empty!

谢谢，thank you，

best regards.

[Hikari]

Those errors look pretty normal. Those are common database errors, which aren't fixed yet.

No.3 error 这个问题是要RegenHealth=Curehealth? by the way,what's RegenHealth ？

The RegenHealth-Flag indicates wheter the creature regenerates health while out of combat or not.

Let's say you wan't a creature to appear with 1000 health points of 1500. Then you set the curhealth to 1000 and RegenHealth to 0. Now the creature has 1000/1500 health points and won't regenerate up to 1500.

[xiazai]

Those errors look pretty normal. Those are common database errors, which aren't fixed yet.

The RegenHealth-Flag indicates wheter the creature regenerates health while out of combat or not.

Let's say you wan't a creature to appear with 1000 health points of 1500. Then you set the curhealth to 1000 and RegenHealth to 0. Now the creature has 1000/1500 health points and won't regenerate up to 1500.

Thank you very much,Hikari. I learned a lot from this site,you are doing a great job. I will keep studying on the mangos.