fatal error

[jeff5656]

The following script converts the "rcf_date" field (varchar) to "rcf_date2" (date format) in the table "active_consults".

 

On my test server it works.

When I put I applied it to the actual database (930 records) I get:

 

Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\consults\convertdate-3.php on line 9

 

Here is code that produces that error:  Any ideas?

 

<?php include "connectdb.php"; 


$query = mysql_query("SELECT * FROM active_consults")or die(mysql_error());
while($info = mysql_fetch_array( $query ))
{
$newdate = date("Y-m-d", strtotime($info['rcf_date']));
$upq = "update active_consults set rcf_date2 = '$newdate' where id_incr = '" . $info['id_incr'] . "'";
   $rs = mysql_query($upq) or die("Problem with the update query: $upq<br>" . mysql_error());
   
}
?>

[kenrbnsn]

Take a look at the set_time_limit() function.

 

Ken

 

 

[shreej21]

Just change the time in php.ini file

 

and change the seconds for

set_time_limit

[jeff5656]

Oh ok.  Well, in the meantime I solved problem by adding LIMIT 0,300 and then run it and then change it to LIMIT 301,500 etc until the file was converted.

[PFMaBiSmAd]

Running two queries (SELECT and UPDATE) and two slow php functions (date() and strtotime()) for every row is bound to take a long time. Since this is a one time operation, running a single query that updates all the rows at one time in your database administration tool (phpmyadmin or mysql administrator...) would have been the simplest solution.