issue with live flight map ?

First I would like to thank you for this wonderful Skin, It has been installed successfully on my Va but i have a some of issue .. ?! 

  • i can’t see any pilot flying or details on Live flight or Live map ?? ( I am using simpilot 5.5.2 Version ) And using Kacars ?!

 

Any help ?!

opll2.png.011465b1e0b4a3cea6c192dccc114500.png

What is your website url? Is your phpvms_acarsdata database table populated correctly? You can check your phpVMS database via phpMyAdmin.

6 minutes ago, servetas said:

What is your website url? Is your phpvms_acarsdata database table populated correctly? You can check your phpVMS database via phpMyAdmin.

my we url : www.kuwaitairways-va.org/index.php

 

acarsdata77.png.cbf278f2bae8b0db2e37c5e3139368ba.png

can you show us what is inside phpvms_acarsdata ? are the coordinates with a .(DOT) or , (Comma) ?

9 hours ago, Vangelis said:

can you show us what is inside phpvms_acarsdata ? are the coordinates with a .(DOT) or , (Comma) ?

 

dd111.png.8406caf25f6bb2e2b7ac3b9216a2a5c3.png

Data and map seems to be ok have you tried with the default template ? it might be a js problem 

7 minutes ago, Vangelis said:

Data and map seems to be ok have you tried with the default template ? it might be a js problem 

i back to default template map not working ?!

 

ojjhf44.png.42566e974b39e1a2bbf2e8aca6c72809.png

is anybody flying ? 

1 hour ago, Vangelis said:

is anybody flying ? 

yes .. 

turn on your logs and attach it mayby there is a clue why it is not working

 

On 5/8/2017 at 5:57 PM, Vangelis said:

turn on your logs and attach it mayby there is a clue why it is not working

 

There is no loges recorded ?! 

logess.png.00aad3cbaf865aa4edd69e33ac55374f.png

i would enable the logs by setting this in local.config.php

 Config::Set('DEBUG\_MODE', true); Config::Set('DEBUG\_LEVEL', 2); // 1 logs query errors, 2 logs all queries Config::Set('ERROR\_LEVEL', E\_ALL ^ E\_NOTICE);

and then see in core/logs folder for errors

25 minutes ago, Vangelis said:

i would enable the logs by setting this in local.config.php

Config::Set(‘DEBUG_MODE’, true); Config::Set(‘DEBUG_LEVEL’, 2); // 1 logs query errors, 2 logs all queries Config::Set(‘ERROR_LEVEL’, E_ALL ^ E_NOTICE);

and then see in core/logs folder for errors

That what i get into logs file… ?!

===== Time: 05.10.17 10:38:06 ===== Time: 05.10.17 10:38:06 Backtrace: DB::write\_debug \> DB::get\_results \> ACARSData::GetACARSData \> ACARS-\>data \> call\_user\_func\_array \> MainController::RunAllActions Query: SELECT a.\*, c.name as aircraftname, c.registration, p.code, p.pilotid as pilotid, p.firstname, p.lastname, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms\_acarsdata a LEFT JOIN phpvms\_aircraft c ON a.`aircraft`= c.`registration` LEFT JOIN phpvms\_pilots p ON a.`pilotid`= p.`pilotid` LEFT JOIN phpvms\_airports AS dep ON dep.icao = a.depicao LEFT JOIN phpvms\_airports AS arr ON arr.icao = a.arricao WHERE DATE\_SUB(NOW(), INTERVAL 720 MINUTE) \<= a.`lastupdate` Error: (1267) - Illegal mix of collations (latin1\_general\_ci,IMPLICIT) and (latin1\_swedish\_ci,IMPLICIT) for operation '=' ===== =====

 

check the collations of your tables every table should have the same collation 

 

have a look at this 

https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation

On 5/10/2017 at 11:54 AM, Vangelis said:

check the collations of your tables every table should have the same collation 

 

have a look at this 

https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation

I would like to thank you for helping me, I’ve solved the problem 

 

 

fixed1.png.279e73ad6051c85d1200f5873262d672.png