Author Topic: [VAM2.6.2] Acars Data MAX_JOIN_SIZE  (Read 433 times)

Timothee

  • Jr. Member
  • **
  • Posts: 73
    • View Profile
[VAM2.6.2] Acars Data MAX_JOIN_SIZE
« on: May 07, 2017, 03:14:32 PM »
Hi

After a while it may happen that the flight details page only shows an error message instead of the acars data:
Code: [Select]
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
In my oppinion there is an unnecessary join in the SQL statement.
I changed the last SQL query in flight_details.php and validate_vam_acars.php as followed:
Code: [Select]
$sql = "select vt.time_flag, vt.flight_status,vt.ias,vt.gs,vt.altitude,vt.fuel_used,vt.oat from vam_track vt where vt.flight_id='" . $vamflightid . "' order by vt.id asc";

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1325
    • View Profile
    • virtual Airlines Manager
Re: [VAM2.6.2] Acars Data MAX_JOIN_SIZE
« Reply #1 on: May 25, 2017, 09:33:38 PM »
Hi

After a while it may happen that the flight details page only shows an error message instead of the acars data:
Code: [Select]
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
In my oppinion there is an unnecessary join in the SQL statement.
I changed the last SQL query in flight_details.php and validate_vam_acars.php as followed:
Code: [Select]
$sql = "select vt.time_flag, vt.flight_status,vt.ias,vt.gs,vt.altitude,vt.fuel_used,vt.oat from vam_track vt where vt.flight_id='" . $vamflightid . "' order by vt.id asc";

Thanks again, I am now integrating all your fixes + other from me
VAM Creator and programmer.

FSC190

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: [VAM2.6.2] Acars Data MAX_JOIN_SIZE
« Reply #2 on: August 06, 2018, 10:32:56 AM »
Hi,
is there a fix or update available now?