getting an error on one category

[billybrag]

At the site i am working on if i click on the nonFiction category the page takes ages to load and then (im guessing) times out, but i have no idea why

this is the error

Fatal error: Maximum execution time of 30 seconds exceeded in /home/www/mysite/includes/modules/new_products.php on line 61

 

 

 

 

 

 

heres the site to see what i mean (click on "non fiction")

Here

[♥bruyndoncx]

perhaps you have a problem with a particular record that is locked for editing ?

 

what's the query on line 61 ?

[billybrag]

i just tried it again and it said

Fatal error: Maximum execution time of 30 seconds exceeded in /home/www/mystore/includes/functions/database.php on line 106

[billybrag]

this is the code around line 61 of new_products

 

 ?if ($num_rows > 0) { ? ? ? ?
? ?while ($pCount < $max_new_products) { ? ?
? ? ?// choose a random row 
? ? ?$random_product = '';
? ? ?$random_row = tep_rand(0, ($num_rows - 1));
? ? ?tep_db_data_seek($new_products_query, $random_row);
? ? ?$random_product = tep_db_fetch_array($new_products_query);
? ? ?// see if found already, if not use else skip
? ? ?$found = 0;
? ? ?for ($ii=0; $ii < $pCount; $ii++) {
? ? ? ?if ($found_products[$ii] == $random_product['products_id']) {
? ? ? ? ?$found = 1;
? ? ? ? ?break;
? ? ? ?}
? ? ?}

 

and this is the code for 106 of database

  function tep_db_data_seek($db_query, $row_number) {

[♥bruyndoncx]

tep_db_data_seek will return true is OK, false otherwise.

Could it be that you only have 1 new product, $random_row being 0 and causing error ?

Can you add additional statements to check the return value and only execute the next statements when return was true ?

[billybrag]

tep_db_data_seek will return true is OK, false otherwise.

Could it be that you only have 1 new product, $random_row being 0 and causing error ?

Can you add additional statements to check the return value and only execute the next statements when return was true ?

 

sorry but that means nothing :(

 

there are two products in that category

[billybrag]

just tried it again and its now saying

 

the same but

new_products.php on line 57

 

i am getting very confused