JP1 Remotes

Posted: **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

Posted: **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.

Posted: **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.

Posted: **Thu Jun 21, 2007 10:14 am**

The file section is fixed.

Posted: **Thu Jun 21, 2007 12:06 pm**

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

Posted: **Thu Jun 21, 2007 12:07 pm**

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

Posted: **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.

JP1 Remotes

File section error

File section error