CODEWITHSUNDEEP
phpmysql
deerox
deerox

Reputation: 1055

Getting "Maximum execution time" error intermittently

I am facing this problem, firstly I would like to say that I am very new to PHP and MySQL.

Fatal error: Maximum execution time of 30 seconds exceeded in 
.........................\cdn\wished.php on line 3

I don't know what is wrong in line 3, its giving error only sometimes. Here's my code:

<?php
//wished.php
$CheckQuery = mysql_query("SELECT * FROM users WHERE ownerid='$user->id'");
$wished = 0;
while($row = mysql_fetch_assoc($CheckQuery))
{
//  echo $row['fname']."<br/>";
    $wished++;
}
echo $wished;
?>

It was perfect when I run this in localhost with XAMPP. As soon as I hosted my app on my domain and used their database, it start getting error.

thanks every one :)

Upvotes: 0

Views: 272

Answers (1)

Stegrex
Stegrex

Reputation: 4024

The issue is that the SQL query is taking too long, and your production PHP configuration has the PHP script time limit set too low.

At the beginning of the script you can add more time to the PHP time limit:

http://php.net/manual/en/function.set-time-limit.php

set_time_limit(60);

for example to add 30 more seconds (or use 0 to let the PHP script continue running).

If your production database is different than your development DB (and I'm assuming production has way more data) then it might be a really expensive call to get everything from the user table.

Upvotes: 1

Related Questions