Page 1 of 1

MP down

Posted: Tue 29 Jun 2010 5:35 pm
by =gRiJ=Petr
Hi,

Everything was fine with the planner until just an few hours ago. Suddenly the MP doesn't want to load the requested map. It stops at:

Commander Administrator, please wait. We are gathering the latest intelligence from Administration HQ ...

And there is DONE with exclamation mark in the bottom left corner.
Details of the error are:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
Timestamp: Tue, 29 Jun 2010 21:35:01 UTC


Message: Expected '}'
Line: 12395
Char: 3
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Head.js


Message: 'NCurrentMissions' is undefined
Line: 34
Char: 10
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Body.js

AND:
Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
Timestamp: Tue, 29 Jun 2010 21:35:20 UTC


Message: Expected '}'
Line: 12395
Char: 3
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Head.js


Message: 'NCurrentMissions' is undefined
Line: 34
Char: 10
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Body.js

Anyone?
Thanks!
Cheers,
Petr

Posted: Wed 30 Jun 2010 3:22 am
by IV/JG7_4Shades
Hi Petr

Probably someone added a pilot report or a flight plan with a strange character in the text. Open Pilot_Reports table and look for quote characters, brackets etc. Also look at briefings in the latest GroupMissionData records.

Cheers,
4S

Posted: Wed 30 Jun 2010 4:16 am
by =gRiJ=Petr
Hi Shades,

The Pilot_recon_reports table is empty.
In the groupmission table I deleted all briefings I could find. There were no briefings for the current mission 16h hours. Some were there for previous mission and the text is Polish. I deleted that but no result.

Thanks!
Cheers,
Petr

Posted: Wed 30 Jun 2010 5:13 pm
by IV/JG7_4Shades
Hmm. Well someone did something to the DB (directly or via the MP) that has caused the error. THat's all I can offer at the moment, I'm sorry.

Cheers,
4S

Posted: Thu 01 Jul 2010 3:26 am
by =gRiJ=Petr
No problem, I have a working backup from just after the last analyze.Will restore and we'll start over. I'll keep a copy of the problem DB so you can analyze afterwards if you want to.

Thanks! Enjoy Europe!
Cheers,
Petr

Posted: Wed 14 Jul 2010 3:14 am
by =gRiJ=Petr
After the restore last time everything went well.

Now, a mission later the same error :shock:

Just took a backup and then deleted everything in the groupmission table but to no effect.

HELP! Mission is tonight!

Posted: Wed 14 Jul 2010 5:12 am
by =gRiJ=Petr
Hi Shades,

I found the problem but have no idea of the cause.
I got the MP back by deleting the last mission planned in the Objectmissiondata and the newwaypoints tables.
It was a mission which ended in a Withdraw, so I deleted the entry for that mission in the Withdrawels table as well.

After that, MP works again.
No clue what caused it though. No brief or anything. I do have a backup of the DB with the problem in case you want to debug...

Cheers,
Petr