One of the bugs I can’t figure out here at Forumosa is in the Housing Forum. I can’t view it and instead I get an overload error. I can view the latest post, and I can cycle through it using the previous post links, but I can’t see the View forum page itself
We tried to get smart one day by creating a brand new forum and moving all the Housing threads into it. It worked… for me (but not for Maoman) and only for about a week!
What’s up with that? I don’t understand the inconsistency, and I do not understand why it happens in only one forum.
Are you familiar with the problem we have with Housing? And do you have any suggestions?
[quote=“miltownkid”]I can never seem to get into the housing classifieds, either it’s really slow or I get an error. Does anyone else have this problem?
This is troublesome since I’m suppose to moderate that area. [/quote]
Warning: file_get_contents(/usr/share/phpbb2/site/tags/tagline94.txt): failed to open stream: No such file or directory in /usr/share/phpbb2/site/viewforum.php on line 402
Warning: file_get_contents(/usr/share/phpbb2/site/dave/pots94.txt): failed to open stream: No such file or directory in /usr/share/phpbb2/site/viewforum.php on line 403
I still get the Fatal Error when I try to visit the Housing Forum[quote]Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 3558201 bytes) in /usr/share/phpbb2/site/includes/prune.php on line 66[/quote]
XP Firefox 0.9.3 or MSIE
pjdrib, I’ve added the missing files you reported. Thank you. Since I haven’t been able to look at the husing forum, I didn’t notice there was an error like that. Things should be ok, I guess
Gus, I found some bug reports in German and French which might be about the same or a related problem. The French one says that it’s only moderators who get this error and it says that eventually other forums will be affected, too. Unfortunately, they didn’t post any solution.
Could you give me line 66 and surroundings from prune.php? If I have the time, I’m going to have a look at it. Now I have to leave the computer and take a shower because the neighbours will complain if anybody uses the shower after midnight (water pump is too loud).
Maybe try Resyc’in it in the admin control panel (couldn’t hurt). Since it says there’s a problem with the prune thing, maybe just turn pruning off for now.
I never get a link with this link: forumosa.com/taiwan/viewforum.php?f=94
But then again I’m not a mod there or an administrator, like MK, Goose and Bu.
PS. I think a Haunted House forum is a good idea, Most Taiwanese wouldn’t even buy a house next to a graveyard, so they should be cheaper for the rest of us.
[quote=“Bu”]For two days I haven’t been able to access the Housing Classifieds Forum. [/quote]And how long have you been a mod there ?[quote=“Egg”]I’ve had this problem for much longer than just the last 2 days [/quote]You’ve had mod powers in there for longer than 2 days
Well, that explains why it’s been only a few days for me, and GooseEgg and MK have the same prob. I’ve been temporary mod of the forum that long. Weird.
There’s a couple of threads there I wanted to merge.
$sql = "SELECT t.topic_id
FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t
WHERE t.forum_id = $forum_id
$prune_all
AND ( p.post_id = t.topic_last_post_id
OR t.topic_last_post_id = 0 )";
#-----[ REPLACE WITH ]----------------------------------
$sql = "SELECT t.topic_id
FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t
WHERE t.forum_id = $forum_id
$prune_all
AND p.topic_id = t.topic_id
AND ( p.post_id = t.topic_last_post_id
OR t.topic_last_post_id = 0 )";
If these are the lines causing the error, the added code is certainly going to reduce the number of returned results. However, I’m not familiar with the PHPBB database structure so I don’t know what exactly it does. Anyhow, nothing really bad can happen, in the worst case pruning won’t work correctly anymore.
The underlying problem seems to be a database incoherency.
Sorry, GF is nagging, have to drive her to the shopping mall.
[quote=“Goose Egg”]Still can’t figure out why it only affects this forum (I suppose one of these threads is corrupted somehow)[/quote]Could be, does this link work ? forumosa.com/taiwan/viewforum.ph … 0&start=50
If so, twiddle about with the start number until you find the broken thread.
Yes, this has to be it: a broken thread (=“orphan” posts without topic id). I read that the pruning function can’t handle this. With the new “AND p.topic_id = t.topic_id” condition in the SQL query, those posts won’t be selected anymore, so the problem should be solved (the orphan posts will remain, though, and I don’t know how they appeared in the first place or what exactly about them causes the “out of memory”-error, however, I don’t really have to know this ). Please let me know if the proposed solution worked.
Unfortunately, they didn’t post any solution.
). Please let me know if the proposed solution worked.