1 (edited by Lazymoth 2013-10-08 15:13)

Topic: Forums and topics won't display [solved]

Hey everyone, I was hoping someone might know what was going on here and could help me out. Here are my forums.

Everything was totally fine, and then suddenly viewtopic.php and viewforum.php pages did not work at all, throwing up the "Sorry! The page could not be loaded." error with no explanation. It was not prompted by anything I could imagine- no new plugins were installed, no posts were made. There was just a point at which they arbitrarily stopped loading.

I'm running PunBB 1.4.2. My plugin loadout:

BBCode buttons 1.4.18
Colored usergroups 1.2.4
Del_bb 1.00
Fancy Video Tag 0.4.9
Forum news 1.1.2
jQuery 1.1.5
Private Messaging 2.4.2
Pun Move Posts 1.1.4
Pun poll 2.3
PunBB Repository 1.3.1
Simple Shoutbox 0.0.2
Simple subforums 0.0.2
Spoiler BBcode 0.8

But like I said, I don't think it's a plugin malfunction because it was working perfectly fine with all the plugins I was running, and I tried disabling them all one by one. Even when they were turned off, viewtopic.php and viewforum.php would not work.

You can see individual posts if you go into a user profile and click "display user's posts". However the error is again given with "display user's topics".

I would be super grateful for any help! I really hope someone has an idea of what's going on sad

Update:

I enabled debug mode and show queries. These are the errors:

viewforum.php error wrote:

Database reported: Can't create/write to file '/tmp/#sql_bee_0.MYI' (Errcode: 28) (Errno: 1).

Failed query: SELECT t.id, t.poster, t.subject, t.posted, t.first_post_id, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, p.poster_id AS has_posted FROM pbp_topics AS t LEFT JOIN pbp_posts AS p ON (p.poster_id=2 AND p.topic_id=t.id) WHERE t.id IN (532,489,475,461,449,446,425,410,361,267,255,250,247,241,236,232,207,204,189,170,142,97,91,87,76,57,49,43,33,26) GROUP BY t.id, t.poster, t.subject, t.posted, t.first_post_id, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, p.poster_id ORDER BY t.sticky DESC, t.posted DESC

The error occurred on line 151 in /home/dopterra/dopterra/root/doppbp/viewforum.php

viewtopic.php error wrote:

Database reported: Can't create/write to file '/tmp/#sql_bee_0.MYI' (Errcode: 28) (Errno: 1).

Failed query: SELECT u.email, u.title, u.url, u.location, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM pbp_posts AS p INNER JOIN pbp_users AS u ON u.id=p.poster_id INNER JOIN pbp_groups AS g ON g.g_id=u.group_id LEFT JOIN pbp_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.id IN (6349,6350,6364,6367,6368,6370,6414) ORDER BY p.id

The error occurred on line 324 in /home/dopterra/dopterra/root/doppbp/viewtopic.php

Update 2:

Well now I realize this is a mySql problem and not a punBB problem. Still any insight would be very much appreciated! If I find the solution myself I will update this post for anyone else who might have the same problem.

Re: Forums and topics won't display [solved]

Solved: There was a storage capacity limit on the server and not enough space to make the temp mysql files. Deleted a bunch of stuff to make room and now it's fine again. If anyone else has this problem, check and see if you're out of space!