I have a big problem here

[Mijae]

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:$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