JP1 Remotes Forum Index JP1 Remotes


FAQFAQ SearchSearch 7 days of topics7 Days MemberlistMemberlist UsergroupsUsergroups RegisterRegister
ProfileProfile Log in to check your private messagesLog in to check your private messages Log inLog in

File section error

 
Post new topic   Reply to topic    JP1 Remotes Forum Index -> Web Site Issues
View previous topic :: View next topic  
Author Message
kupakai



Joined: 29 Sep 2006
Posts: 283
Location: New York

PostPosted: Wed Jun 20, 2007 9:44 pm    Post subject: File section error Reply with quote

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
View user's profile Send private message Send e-mail
The Robman
Site Owner


Joined: 01 Aug 2003
Posts: 18513
Location: Chicago, IL

PostPosted: Wed Jun 20, 2007 9:55 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
The Robman
Site Owner


Joined: 01 Aug 2003
Posts: 18513
Location: Chicago, IL

PostPosted: Wed Jun 20, 2007 10:51 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
The Robman
Site Owner


Joined: 01 Aug 2003
Posts: 18513
Location: Chicago, IL

PostPosted: Thu Jun 21, 2007 11:14 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
mdavej
Expert


Joined: 08 Oct 2003
Posts: 3769

PostPosted: Thu Jun 21, 2007 1:06 pm    Post subject: Reply with quote

I'm still getting errors. Am I missing something?
Back to top
View user's profile Send private message
The Robman
Site Owner


Joined: 01 Aug 2003
Posts: 18513
Location: Chicago, IL

PostPosted: Thu Jun 21, 2007 1:07 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
The Robman
Site Owner


Joined: 01 Aug 2003
Posts: 18513
Location: Chicago, IL

PostPosted: Thu Jun 21, 2007 5:05 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic       JP1 Remotes Forum Index -> Web Site Issues All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

Powered by phpBB © 2001, 2005 phpBB Group
Get Smart! the band's official homepage Rockabilly Central