Fatal Error

[Allan]

I have recently contacted my host on this error

"Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 128 bytes) in /hermes/web02/b2669/pow.aj5214/htdocs/core/classes/ezdb/ezdb_mysql.class.php on line 273"

I got a response back from saying

"I would like to inform you that, I have tried by setting the maximum memory limit for the PHP . However, the URL http://usaflightclub.com/index.php/schedules/view still giving the same error. It appears to be issue with the script. So, I advice you please check the script and debug the issue from your end. "

How would I debug the system??

Thanks in advance

Regards,

Allan

[Guest lorathon]

Looks like you are pulling to much data. I had this issue when attempting to view all schedules. I limited the maximum number to 1000 viewable. I informed the pilots and told them to search for schedules not just attempt to view all.

[Nabeel]

How many schedules do you have?

[Allan]

Almost 14k

Regards

Allan

[joeri]

find it strange that its running out off mem with 14k schedulles

thats all for 1 airline?

[Allan]

Yes sir, we are only running prop aircraft, so routes are small

Regards

Allan

[Guest lorathon]

I still think that your best bet is to but a limit on the return. There is really no need for a pilot to see ALL of the schedules. If you construct your scheduling search page to force a pilot to choose a least one search criteria you may not even need to limit. It should limit for you since only schedule with that criteria will be returned.

We have over 133k schedule and do not experience this for the above reasons.

my 2 cents

[Allan]

Ok, Jeff will give a go on that but can you explain on how to do that?

Regards,

Allan

[Guest lorathon]

You have two easy option from what I can see (this is using the standard schedules function built into phpVMS

1. Do not show all of the schedules when navigating to the scheduling page (this is the easiest)

core/modules/schedules/schedules.php Around Line 159

public function showSchedules()
{
	$depapts = OperationsData::GetAllAirports();
	$equip = OperationsData::GetAllAircraftSearchList(true);

	$this->set('depairports', $depapts);
	$this->set('equipment', $equip);

	$this->render('schedule_searchform.tpl');

	# Show the routes. Remote this to not show them.   
	//$this->set('allroutes', SchedulesData::GetSchedules());   <--- Comment this line out as shown

	$this->render('schedule_list.tpl');
}

Or if you want to show at least some of them

Same file and function

public function showSchedules()
{
	$depapts = OperationsData::GetAllAirports();
	$equip = OperationsData::GetAllAircraftSearchList(true);

	$this->set('depairports', $depapts);
	$this->set('equipment', $equip);

	$this->render('schedule_searchform.tpl');

	# Show the routes. Remote this to not show them.
	$this->set('allroutes', SchedulesData::GetSchedules('true', '1000'));  <--- Change this as shown (this will show only the first 1000 enabled schedules

	$this->render('schedule_list.tpl');
}

This should work but I have not tried either.

[Allan]

The first option works great, I tried the second 1, no luck but will use the 1st one

Regards,

Allan

[Guest lorathon]

Try this

public function showSchedules()
       {
               $depapts = OperationsData::GetAllAirports();
               $equip = OperationsData::GetAllAircraftSearchList(true);

               $this->set('depairports', $depapts);
               $this->set('equipment', $equip);

               $this->render('schedule_searchform.tpl');

               # Show the routes. Remote this to not show them.
               $this->set('allroutes', SchedulesData::GetSchedules(true, '1000'));  //<--- Change this as shown (this will show only the first 1000 enabled schedules

               $this->render('schedule_list.tpl');
       }

I made a bone head move and put the true in quotes

[Allan]

Error

Parse error: syntax error, unexpected '<' in /hermes/web02/b2669/pow.aj5214/htdocs/core/modules/Schedules/Schedules.php on line 170

Regards,

Allan

[Guest lorathon]

You have to remove my comment <---- this part all of it

I will change the code to comment it out

[Allan]

Works Great!!

Thanks a Million

Regards,,

Allan