Schedules disappear

[dimitris]

Hello!

I got a realy big and strange problem! All the flights from flight schedules has been disappear! look a the screen shot !

and the data base is full!

and the schedules_results.tpl is the following:

<?php
if(!$allroutes)
{
echo '<p align="center">No routes have been found!</p>';
return;
}
?>
<table id="tabledlist" class="tablesorter">
<thead>
<tr>
<th>Flight Info</th>
<th>Options</th>
</tr>
</thead>
<tbody>
<?php
foreach($allroutes as $route)
{

/* Uncomment this code if you want only schedules which are from the last PIREP that
	pilot filed */
/*if(Auth::LoggedIn())
{
	$search = array(
		'p.pilotid' => Auth::$userinfo->pilotid,
		'p.accepted' => PIREP_ACCEPTED
	);

	$reports = PIREPData::findPIREPS($search, 1); // return only one

	if(is_object($reports))
	{
		# IF the arrival airport doesn't match the departure airport
		if($reports->arricao != $route->depicao)
		{
			continue;
		}
	}
}*/

/*
Skip over a route if it's not for this day of week
Left this here, so it can be omitted if your VA
 doesn't use this. 

Comment out these two lines if you don't want to.
*/

/*	Check if a 7 is being used for Sunday, since PHP
	thinks 0 is Sunday */
$route->daysofweek = str_replace('7', '0', $route->daysofweek);

if(strpos($route->daysofweek, date('w')) === false)
	continue;

/* END DAY OF WEEK CHECK */



/*
This will skip over a schedule if it's been bid on
This only runs if the below setting is enabled

If you don't want it to skip, then comment out
this code below by adding // in front of each 
line until the END DISABLE SCHEDULE comment below

If you do that, and want to show some text when
it's been bid on, see the comment below
*/
if(Config::Get('DISABLE_SCHED_ON_BID') == true && $route->bidid != 0)
{
	continue;
}
/* END DISABLE SCHEDULE ON BID */


/*	Skip any schedules which have aircraft that the pilot
	is not rated to fly (according to RANK), only skip them if
	they are logged in. */
if(Config::Get('RESTRICT_AIRCRAFT_RANKS') === true && Auth::LoggedIn())
{
	/*	This means the aircraft rank level is higher than
		what the pilot's ranklevel, so just do "continue"
		and move onto the next route in the list 
	 */
	if($route->aircraftlevel > Auth::$userinfo->ranklevel)
	{
		continue;
	}
}

/* THIS BEGINS ONE TABLE ROW */
?>
<tr>
<td>
	<a href="<?php echo url('/schedules/details/'.$route->id);?>"><?php echo $route->code . $route->flightnum?>
		<?php echo '('.$route->depicao.' - '.$route->arricao.')'?>
	</a>
	<br />

	<strong>Departure: </strong><?php echo $route->deptime;?>         <strong>Arrival: </strong><?php echo $route->arrtime;?><br />
	<strong>Equipment: </strong><?php echo $route->aircraft; ?> (<?php echo $route->registration;?>)  <strong>Distance: </strong><?php echo $route->distance . Config::Get('UNITS');?>
	<br />
	<strong>Days Flown: </strong><?php echo Util::GetDaysCompact($route->daysofweek); ?><br />
	<?php echo ($route->route=='') ? '' : '<strong>Route: </strong>'.$route->route.'<br />' ?>
	<?php echo ($route->notes=='') ? '' : '<strong>Notes: </strong>'.html_entity_decode($route->notes).'<br />' ?>
	<?php
	# Note: this will only show if the above code to
	#	skip the schedule is commented out
	if($route->bidid != 0)
	{
		echo 'This route has been bid on';
	}
	?>
</td>
<td nowrap>
	<a href="<?php echo url('/schedules/details/'.$route->id);?>">View Details</a><br />
	<a href="<?php echo url('/schedules/brief/'.$route->id);?>">Pilot Brief</a><br />

	<?php 
	# Don't allow overlapping bids and a bid exists
	if(Config::Get('DISABLE_SCHED_ON_BID') == true && $route->bidid != 0)
	{
	?>
		<a id="<?php echo $route->id; ?>" class="addbid" 
			href="<?php echo actionurl('/schedules/addbid');?>">Add to Bid</a>
	<?php
	}
	else
	{
		if(Auth::LoggedIn())
		{
		 ?>
			<a id="<?php echo $route->id; ?>" class="addbid" 
				href="<?php echo url('/schedules/addbid');?>">Add to Bid</a>
		<?php			 
		}
	}		
	?>
</td>
</tr>
<?php
/* END OF ONE TABLE ROW */
}
?>
</tbody>
</table>
<hr>

[Kyle]

Check your days of selected in your flight admin. This is the most common problem people has.

Becasue i see in your database that the Saturaday is not enabled.

[dimitris]

Check your days of selected in your flight admin. This is the most common problem people has.

Becasue i see in your database that the Saturaday is not enabled.

Ok i will say that to my CEO thank you so much ! i m the Web Manager

[MrAmsterdam]

Ok i will say that to my CEO thank you so much ! i m the Web Manager

Yeah that must be it. I had the same problem... easy to overlook :-)

[flynryan692]

Hi, instead of making a full new topic, I'll continue with this one.

I have this problem too, however I have everyday of the week checked for the flights. This is only happening with flight from KFLL Fort Lauderdale..I'm not sure why...

[Nabeel]

Hi, instead of making a full new topic, I'll continue with this one.

I have this problem too, however I have everyday of the week checked for the flights. This is only happening with flight from KFLL Fort Lauderdale..I'm not sure why...

The flight might be bid on. In the local.config.php file there are two settings you should check to see if they're enabled. I don't remember them off the top of my head.

[AUZ]

This happened to me after setting up the Automatic Maintenance using a Cron Job on the server,

After it ran, it put all my schedules from 0123456 to 1 lol

Exported them all, edited them in excel and imported them.

The Cron Job runs every morning and it hasn't happened again.

[flynryan692]

Went into the local config, found it. Fixed it. Thank you!

[flyalaska]

Also if there are no flights for today, it will not show in schedules.

[Mysterious Pilot]

Also if there are no flights for today, it will not show in schedules.

I had the same problem of all flights in the schedule (airports too!) disappeared after I did an export. Never go them back. Yet the database still had all the data, very strange.

[Nabeel]

Make sure they are not marked as inactive

[Mysterious Pilot]

Make sure they are not marked as inactive

I did not make them inactive, if for some reason they became inactive then there must have been a glitch that reset the active flag by accident.