File section error

kupakai · Post by **kupakai** » Wed Jun 20, 2007 8:44 pm

I seem to getting the error below in the file section if I got to any of the categories or subcategories. Direct links to individual files seem to work though (like the last uploaded file link on the sides. (it's 10:40 PM EST on June 20, 2007)

Code: Select all

Couldn't get file info for this category

DEBUG MODE

SQL Error : 1 Can't create/write to file '/tmp/#sql_3c9_0.MYI' (Errcode: 28)

SELECT f1.*, f1.file_id, r.votes_file, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, COUNT(c.comments_id) AS total_comments FROM phpbb_pa_files AS f1 LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS c ON f1.file_id = c.file_id WHERE f1.file_pin = 1 AND f1.file_approved = 1 AND f1.file_catid = 23 GROUP BY f1.file_id ORDER BY file_name ASC

Line : 898
File : functions_pafiledb.php

Post by **The Robman** » Wed Jun 20, 2007 8:55 pm

Thanks for the heads up, I'm getting the same message. Let me see what I can do.

Post by **The Robman** » Wed Jun 20, 2007 9:51 pm

After waiting on hold with iPowerweb tech support for 40 minutes I had to give up, so this won't get solved today I'm afraid.

Post by **The Robman** » Thu Jun 21, 2007 10:14 am

The file section is fixed.

mdavej · Post by **mdavej** » Thu Jun 21, 2007 12:06 pm

I'm still getting errors. Am I missing something?

Post by **The Robman** » Thu Jun 21, 2007 12:07 pm

It was fixed, but it looks like it broke again.

Post by **The Robman** » Thu Jun 21, 2007 4:05 pm

Murphy's Law: I just waited on the phone again for tech support, except that this time when the support guy picked up and I directed him to the file section, it was working again (by itself).

Fingers crossed, hopefully it will keep working.