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

Sorry for the outtage
Goto page 1, 2  Next
 
Post new topic   Reply to topic    JP1 Remotes Forum Index -> Web Site Issues
View previous topic :: View next topic  
Author Message
The Robman
Site Owner


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

                    
PostPosted: Wed Mar 19, 2008 3:56 pm    Post subject: Sorry for the outtage Reply with quote

My ISP decided to move my site from a cpanel platform to a vdeck platform over the weekend and they missed something on the database side. As I've been in a class for the last two days, I haven't had the time to sit on the phone for an hour, which is what it always takes, to get it resolved. But I'm out of my class now and I just sat on the phone for an hour and here's the forum back.

I hope y'all didn't get withdrawal symptoms!

Now I can go back to the political stuff! Smile
_________________
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
kupakai



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

                    
PostPosted: Wed Mar 19, 2008 4:20 pm    Post subject: Reply with quote

Thanks, I sure did have some withdrawal symptoms!
It seems like the file sections are still not working though. Direct links seem to work, but when I go to the section and try to go to the different categories, I get the following message:


Couldn't get file info for this category

DEBUG MODE

SQL Error : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

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 = 21 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
Mark Pierson
Expert


Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA

                    
PostPosted: Wed Mar 19, 2008 4:35 pm    Post subject: Reply with quote

kupakai wrote:
It seems like the file sections are still not working though. Direct links seem to work, but when I go to the section and try to go to the different categories, I get the following message:


Couldn't get file info for this category
Same here.
_________________
Mark
Back to top
View user's profile Send private message Send e-mail Visit poster's website
The Robman
Site Owner


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

                    
PostPosted: Wed Mar 19, 2008 5:31 pm    Post subject: Reply with quote

The file section uses a different database to the rest of the forum, so it looks like they need to fix that one also. I'm on hold with the ISP right now.
_________________
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: 21210
Location: Chicago, IL

                    
PostPosted: Wed Mar 19, 2008 7:32 pm    Post subject: Reply with quote

The ISP wasn't able to fix it, so I had to roll up my sleeves and fix it myself. For some reason, there was an index on the primary key of the comments table, so I changed the index to go against the file id and that seemed to get the main part of the file section working.

However, the file search still wasn't working. I ended up having to edit the SQL in one of the forum components to get that working!

If anyone spots any other part of the forum that isn't working, please post info about it here (but please don't all send me emails or PMs on it).
_________________
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
ElizabethD
Advanced Member


Joined: 09 Feb 2004
Posts: 2348

                    
PostPosted: Wed Mar 19, 2008 10:41 pm    Post subject: Reply with quote

Hi Rob,
So far it looks good. File section SEARCH works fine. Forum SEARCH works fine. Normal navigation, nothing weird. Thanks for fixing.
Hey, tell your ISP to practice data moves on THEIR TEST data not ours.
Happy politicking!
_________________
Liz
Tweeking 8910, HTPro/9811, C7-7800, 6131o, 6131n, AtlasOCAP-1056B01, RCA-RCRP05B and enjoying the ride Smile
Back to top
View user's profile Send private message
gloudemans



Joined: 04 Mar 2008
Posts: 8
Location: Fort Mill, SC USA

                    
PostPosted: Thu Mar 20, 2008 10:29 am    Post subject: Reply with quote

Real withdrawal for me. Been surfing this site for awhile, finally got my 2 new JP1.2 remotes and Tommy's cable and BAM! the site was down - how depressing.

Glad to see your back up and running and thanks for a great site.
Back to top
View user's profile Send private message
vickyg2003
Site Admin


Joined: 20 Mar 2004
Posts: 7073
Location: Florida

                    
PostPosted: Fri Mar 21, 2008 7:28 am    Post subject: Reply with quote

Well I sure missed this site while it was down! I found more problems this morning. A lot of the links on this page http://www.hifi-remote.com/files/ are dead.
Back to top
View user's profile Send private message Visit poster's website
The Robman
Site Owner


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

                    
PostPosted: Fri Mar 21, 2008 11:12 am    Post subject: Reply with quote

Thanks for the heads-up. Evidently the new server doesn't allow for file lists when the index.html file isn't present, so I'll need to see if there's a way that I can turn that feature on and if not, I'll need to create some HTML files so you can link to the files.
_________________
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: 4500

                    
PostPosted: Fri Mar 21, 2008 2:51 pm    Post subject: Reply with quote

This may have never worked for all I know, but the printer-friendly view button doesn't work.
Back to top
View user's profile Send private message
The Robman
Site Owner


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

                    
PostPosted: Fri Mar 21, 2008 8:45 pm    Post subject: Reply with quote

It is possible that that has never worked as I've never used it, it's a mod that Lucy added.
_________________
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
vickyg2003
Site Admin


Joined: 20 Mar 2004
Posts: 7073
Location: Florida

                    
PostPosted: Fri Mar 21, 2008 10:09 pm    Post subject: Reply with quote

Quote:
Liz wrote:
File section SEARCH works fine


What file search is that? I was doing them from google, but after the server move all the cached pages are gone.
Back to top
View user's profile Send private message Visit poster's website
pH7_jp1



Joined: 14 Sep 2003
Posts: 480
Location: Sterling Heights, MI

                    
PostPosted: Sat Mar 22, 2008 10:43 am    Post subject: Reply with quote

Back to top
View user's profile Send private message
vickyg2003
Site Admin


Joined: 20 Mar 2004
Posts: 7073
Location: Florida

                    
PostPosted: Sat Mar 22, 2008 11:07 am    Post subject: Reply with quote

Doh!
Back to top
View user's profile Send private message Visit poster's website
speaker.guy
Exile Island Resident


Joined: 17 Apr 2007
Posts: 260

                    
PostPosted: Sun Mar 23, 2008 3:58 am    Post subject: Reply with quote

I am on a cruise. Thought it was me!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic       JP1 Remotes Forum Index -> Web Site Issues All times are GMT - 5 Hours
Goto page 1, 2  Next
Page 1 of 2

 
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
Top 7 Advantages of Playing Online Slots The Evolution of Remote Control