I have a big problem here

Last night my server's database went down and now they say its back up, but my vB wont show/load an posts or member profiles, but it does load everything else.

I get this:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/virtual/site24/fst/var/www/html/forum/admin/functions.php on line 225

And the same execution error in members.php

I didnt edit any of those files, or any vB files in the last 4 days, so I dont know whats wrong.

http://www.invoid.net/forum

[Xenon]

what are the lines 220 - 230 of your functions.php?

your board in general is really slow...
i'd say try to upgrade to the newest vb-version..

[Mijae]

/* 
global $totalcats;
for ($i = 1; $i <= $totalcats[0]; $i++) {
	if($post['item$i']!='No Item') {
		if(empty($post['icon$i'])) {
			$itemid = "itid$i";
			$iconid = "icon$i";
			$itemname = "item$i";
			$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$itemid]\"><img src=\"{imagesfolder}/itemshop/$post[$iconid].gif\" border=\"0\"></a> ";
		} else {
			$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$itemid]\"><img src=\"{imagesfolder}/itemshop/$post[$itemname].gif\" border=\"0\"></a> ";
		}
	} else {
		$post[items] .= "<img src=\"{imagesfolder}/itemshop/No Item.gif\" border=\"0\"> ";
	}
}
*/
global $totalcats; 
$nr=1; 
$count=1; 
while ($count <= $totalcats[0]) { 
$xc="item$nr"; 
$xv = "itid$nr"; 
if(!isset($post[$xv])) { 
$nr++; 
continue; 
} 
if($post[$xc]!='No Item' AND isset($post[$xc])) { 
$xvv = "item$nr"; 
$xv = "itid$nr"; 
$xvvv = "icon$nr"; 
if(empty($post[$xvvv])) { 
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"{imagesfolder}/itemshop/$post[$xvv].gif\" border=\"0\"></a> "; 
} else { 
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"{imagesfolder}/itemshop/$post[$xvvv].gif\" border=\"0\"></a> "; 
} 
} else { 
$post[items] .= "<img src=\"{imagesfolder}/itemshop/No Item.gif\" border=\"0\">";
} 
$nr++; 
$count++; 
}

that seems to be the problem, I will try removing it. But I have no idea why it doesnt work today if it did yesterday.

[Mijae]

Yes, it works now, but I have absolutely no idea why it does with that code >_<

[Mijae]

I found out the problem, thanks for the help anyways.

The error was produced when a member bought a pesonal itemshop, which caused an endless loop.

[Xenon]

this part is wrong:

PHP Code:

$count=1; 
while ($count <= $totalcats[0]) { 
$xc="item$nr"; 
$xv = "itid$nr"; 
if(!isset($post[$xv])) { 
$nr++; 
continue; 
} 


you have a endless while loop here!
it checks for count<=totalscat, but counts are never increased..

add $count++; after the while line