View previous topic :: View next topic |
Author |
Message |
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21210 Location: Chicago, IL |
Posted: Wed Mar 19, 2008 3:56 pm Post subject: Sorry for the outtage |
|
|
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! _________________ 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 |
|
|
kupakai
Joined: 29 Sep 2006 Posts: 283 Location: New York |
Posted: Wed Mar 19, 2008 4:20 pm Post subject: |
|
|
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 |
|
|
Mark Pierson Expert
Joined: 03 Aug 2003 Posts: 3017 Location: Connecticut, USA |
Posted: Wed Mar 19, 2008 4:35 pm Post subject: |
|
|
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 |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21210 Location: Chicago, IL |
Posted: Wed Mar 19, 2008 5:31 pm Post subject: |
|
|
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 |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21210 Location: Chicago, IL |
Posted: Wed Mar 19, 2008 7:32 pm Post subject: |
|
|
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 |
|
|
ElizabethD Advanced Member
Joined: 09 Feb 2004 Posts: 2348
|
Posted: Wed Mar 19, 2008 10:41 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
gloudemans
Joined: 04 Mar 2008 Posts: 8 Location: Fort Mill, SC USA |
Posted: Thu Mar 20, 2008 10:29 am Post subject: |
|
|
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 |
|
|
vickyg2003 Site Admin
Joined: 20 Mar 2004 Posts: 7073 Location: Florida |
Posted: Fri Mar 21, 2008 7:28 am Post subject: |
|
|
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 |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21210 Location: Chicago, IL |
Posted: Fri Mar 21, 2008 11:12 am Post subject: |
|
|
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 |
|
|
mdavej Expert
Joined: 08 Oct 2003 Posts: 4500
|
Posted: Fri Mar 21, 2008 2:51 pm Post subject: |
|
|
This may have never worked for all I know, but the printer-friendly view button doesn't work. |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21210 Location: Chicago, IL |
Posted: Fri Mar 21, 2008 8:45 pm Post subject: |
|
|
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 |
|
|
vickyg2003 Site Admin
Joined: 20 Mar 2004 Posts: 7073 Location: Florida |
Posted: Fri Mar 21, 2008 10:09 pm Post subject: |
|
|
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 |
|
|
pH7_jp1
Joined: 14 Sep 2003 Posts: 480 Location: Sterling Heights, MI |
Posted: Sat Mar 22, 2008 10:43 am Post subject: |
|
|
|
|
Back to top |
|
|
vickyg2003 Site Admin
Joined: 20 Mar 2004 Posts: 7073 Location: Florida |
Posted: Sat Mar 22, 2008 11:07 am Post subject: |
|
|
Doh! |
|
Back to top |
|
|
speaker.guy Exile Island Resident
Joined: 17 Apr 2007 Posts: 260
|
Posted: Sun Mar 23, 2008 3:58 am Post subject: |
|
|
I am on a cruise. Thought it was me! |
|
Back to top |
|
|
|