I was attempting to get multi-site working but to no avail.

Thank God I found a way to back up the database.

Now I restored the database but I always get the error below when I try to just view the index. Is something broken in the database?

Fatal error: Maximum execution time of 60 seconds exceeded in E:\server\xampp\htdocs\test\devsheffuncen.ath.cx\includes\common.inc on line 540

Comments

Miss Essence’s picture

I read somewhere that truncating the watchdog table helped them. I went ahead and did that and got:

Fatal error: Maximum execution time of 60 seconds exceeded in E:\server\xampp\htdocs\test\devsheffuncen.ath.cx\includes\common.inc on line 540

Fatal error: Maximum execution time of 60 seconds exceeded in E:\server\xampp\htdocs\test\devsheffuncen.ath.cx\includes\session.inc on line 56

Fatal error: Maximum execution time of 60 seconds exceeded in E:\server\xampp\htdocs\test\devsheffuncen.ath.cx\includes\session.inc on line 14

pmaster4’s picture

I am getting a similar problem however i created a custom module and started getting the error when i tried to gather data from the database

Fatal error: Maximum execution time of 60 seconds exceeded in.....line 153

the line that it points to is a just a string stored in an array used as select data for a form select option, wasn't giving errors before. I feel the problem may be how i tried to get the data from the database, welcome any help and forgive me i am new to drupal

function pejobsearch_form_submit($form_id, $form_values) {
  //db_query("SELECT vacancy_id, name_position, category FROM post_vacancy WHERE search_keyword ='%s'", $form_values['keyword']);
  //drupal_set_message(t('Gathering Data.'));

  while ($data = db_query("SELECT vacancy_id, name_position, category FROM post_vacancy WHERE search_keyword ='%s'", $form_values['keyword'])){
  	$rows[]	= array($data->name_position, '<strong><u>' .$data->category);
  }
  if ($pager = theme('pager', NULL, 50, 0, tablesort_pager())) {
	$rows[] = array(array('data' => $pager, 'colspan' => '4'));}
  if (!$rows){
	$rows[] = array(array('data' => t('Your search gather no results.'), 'colspan' => '4'));
		     }
  print theme('page', theme('table', $rows));
   return;
  } 
pmaster4’s picture

The problem in my situation was the code i was using to generate the page managed to fix it

Horsey’s picture

All,

I found these steps work:

1. create a .htaccess file with the line 'php_value max_execution_time 300'
2. in Apache config change these lines for the virtual host:
- from
Options None
AllowOverride None
- to
Options All
AllowOverride All
3. Restart Apache.

WARNING - this does add some security issues but at least should fix the fault and allow you to lockdown where necessary again.

SethVIII’s picture

Thanks, that helped me. I am running Drupal on a flash drive, so the install was rather slow and timing out...

cocogodiva’s picture

Where should the .htaccess file with 'php_value max_execution_time 300' be stored?

Thanks A Bunch!

tagawa’s picture

Adding this line to the .htaccess file in the root Drupal folder should be fine (i.e. alongside robots.txt, update.php, etc.).

umanda’s picture

When you are working on Drupal in your local installation some times you get :Fatal error: Maximum execution time of 30/60 seconds exceeded on your browser.

I also got that issue and what I did, I added this code block in my settings.php.

1) open your settings.php (sites / all / default/settings.php)

2) add this code for PHP settings: line number between 147 - 168

ini_set('max_execution_time', 0);

(you may get permission error, because by default setting.php is right protected. for that you can create a new setting.php file and make sure COPY AND PAST ALL data code in old setting.php then you can replace it )

noadek’s picture

All I had to do was change my php version to the version I used while creating the database. Don't know why it worked but I just wanted to share. Hope it helps someone.