View previous topic :: View next topic |
Author |
Message |
kupakai
Joined: 29 Sep 2006 Posts: 283 Location: New York |
Posted: Wed Jun 20, 2007 9:44 pm Post subject: File section error |
|
|
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: | 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 |
|
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21271 Location: Chicago, IL |
Posted: Wed Jun 20, 2007 9:55 pm Post subject: |
|
|
Thanks for the heads up, I'm getting the same message. Let me see what I can do. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21271 Location: Chicago, IL |
Posted: Wed Jun 20, 2007 10:51 pm Post subject: |
|
|
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. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21271 Location: Chicago, IL |
Posted: Thu Jun 21, 2007 11:14 am Post subject: |
|
|
The file section is fixed. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
mdavej Expert
Joined: 08 Oct 2003 Posts: 4519
|
Posted: Thu Jun 21, 2007 1:06 pm Post subject: |
|
|
I'm still getting errors. Am I missing something? |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21271 Location: Chicago, IL |
Posted: Thu Jun 21, 2007 1:07 pm Post subject: |
|
|
It was fixed, but it looks like it broke again. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21271 Location: Chicago, IL |
Posted: Thu Jun 21, 2007 5:05 pm Post subject: |
|
|
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. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
|