Server crash with MoP 1.7

[bySenom]

Hey, everyone

I got a problem with the new 1.7 Update that published yesterday, so I upgraded it from 1.6 to 1.7, but
my Worldserver close on startup everytime

Worldserver log
https://mega.nz/#!r0lgCQRD!1EB4fOInUytGThow3EgNoSoZTl_DoYK8wAIFDvWrXL8

maybe one of you know why it's closing

with best regards
bySenom

 

[ExO]

Can you send the worldserver log on a pastebin link instead of having to download it?
Will have a look then

 

[bySenom]

Can you send the worldserver log on a pastebin link instead of having to download it?
Will have a look then

yea sure^^

https://pastebin.com/B99TSafn

 

[Jack Sparrow]

Did you update the world database?

There is a table change with spell_area

 

[bySenom]

Did you update the world database?

There is a table change with spell_area

yes, I updated the world server to the latest version

 

[Mr. Satan]

Hey, everyone

I got a problem with the new 1.7 Update that published yesterday, so I upgraded it from 1.6 to 1.7, but
my Worldserver close on startup everytime

Worldserver log
https://mega.nz/#!r0lgCQRD!1EB4fOInUytGThow3EgNoSoZTl_DoYK8wAIFDvWrXL8

maybe one of you know why it's closing

with best regards
bySenom

Did you download a fresh 1.7, or just update the 1.6 to 1.7?
A fresh download of 1.7 works for me

 

[bySenom]

Did you download a fresh 1.7, or just update the 1.6 to 1.7?
A fresh download of 1.7 works for me

I updatet it form 1.6 to 1.7 as i wrote, anyways i tried to download the 1.7 MySQL database and it worked for me. Idk what the problem was, but when I using the other database it will not work even if I apply the sql's for the 1.7 version

OK, other question is there an tool where I can export Account/Character data? To Import them in the new database. Maybe it will not so stressfull

best regards
bySenom

 

[Jack Sparrow]

Have you ran the SpellAreaUpdate.sql ?

 

[bySenom]

Have you ran the SpellAreaUpdate.sql ?

yes I did. I applied every sql from version 1.7

 

[Fenris]

Same problem on my shard. I take all files from 1.7, and fresh 1.7 database , where I export my 1.6 auth and character sqlbases and my server crash everytime when going up.
Same problem if I ran 1.7 sql updates with my current 1.6 db.
I wrote about this here https://www.emucoach.com/mists-of-p...achs-official-repack-post63812.html#post63812
I think there is a some conflict between old 1.6 db and new version of 1.7 server. Under upper link I put console error and error log.

 

[Fenris]

Ahh and my other tip [MENTION=6651]Jack Sparrow[/MENTION] - all cinematics files must be inside data/models/cameras folder - not data/cameras - look at this log
Cinematic camera 'data/models/cameras/palantirofazora.m2': does not exist!
Cinematic camera 'data/models/cameras/flybyundead.m2': does not exist!
Cinematic camera 'data/models/cameras/flybyorc.m2': does not exist!
Cinematic camera 'data/models/cameras/flybydwarf.m2': does not exist!
Cinematic camera 'data/models/cameras/flybynightelf.m2': does not exist!
Cinematic camera 'data/models/cameras/flybyhuman.m2': does not exist!
Cinematic camera 'data/models/cameras/flybygnome.m2': does not exist!
Cinematic camera 'data/models/cameras/flybytroll.m2': does not exist!
Cinematic camera 'data/models/cameras/flybytauren.m2': does not exist!
Cinematic camera 'data/models/cameras/scry_cam.m2': does not exist!
Cinematic camera 'data/models/cameras/flybybloodelf.m2': does not exist!
Cinematic camera 'data/models/cameras/flybydraenei.m2': does not exist!
Cinematic camera 'data/models/cameras/flybysunwell5man.m2': does not exist!
Cinematic camera 'data/models/cameras/flybydeathknight.m2': does not exist!
Cinematic camera 'data/models/cameras/flybygilneas_telescope.m2': does not exist!
Cinematic camera 'data/models/cameras/flybygilneasshort.m2': does not exist!
Cinematic camera 'data/models/cameras/abyssal_maw_camerafly_01.m2': does not exist!
Cinematic camera 'data/models/cameras/flybyworgen.m2': does not exist!
Cinematic camera 'data/models/cameras/flybygoblin.m2': does not exist!
Cinematic camera 'data/models/cameras/flyby_maelstrom.m2': does not exist!
Cinematic camera 'data/models/cameras/firelands_bridge_camera_01.m2': does not exist!
Cinematic camera 'data/models/cameras/flybypandaren.m2': does not exist!
Cinematic camera 'data/models/cameras/flybygateofthesettingsun.m2': does not exist!
Cinematic camera 'data/models/cameras/flyby_mogubridge_collapse.m2': does not exist!
Cinematic camera 'data/models/cameras/flyby_mogusecret_door.m2': does not exist!

 

[Fenris]

[MENTION=6651]Jack Sparrow[/MENTION]

Some chance for a patch to allow the transfer of auth / character databases from version 1.6 to 1.7. Base 1.7 works ok on the new version of the server but with base 1.6 (even updated) there are problems I wrote about.

 

[Jack Sparrow]

[MENTION=18124]bySenom[/MENTION]

DROP TABLE IF EXISTS `character_raid`;

CREATE TABLE `character_raid` (
  `guid` int(11) NOT NULL DEFAULT '0',
  `mapId` int(11) NOT NULL DEFAULT '0',
  `encounterMask` int(11) DEFAULT '0',
  `data` text,
  `entranceId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`guid`,`mapId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Run in character database and try again.