issue with live flight map ?

[BaderNET]

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 ?!

[servetas]

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

[BaderNET]

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

 

[Vangelis]

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

[BaderNET]

9 hours ago, Vangelis said:

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

 

[Vangelis]

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

[BaderNET]

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 ?!

 

[Vangelis]

is anybody flying ? 

[BaderNET]

1 hour ago, Vangelis said:

is anybody flying ? 

yes .. 

[Vangelis]

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

 

[BaderNET]

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 ?! 

[Vangelis]

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

[BaderNET]

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 '='
=====


=====

 

[Vangelis]

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

[BaderNET]

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