Sorry for the outtage

Post by **The Robman** » Wed Mar 19, 2008 2:56 pm

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!

kupakai · Post by **kupakai** » Wed Mar 19, 2008 3:20 pm

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

Mark Pierson · Post by **Mark Pierson** » Wed Mar 19, 2008 3:35 pm

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.

Post by **The Robman** » Wed Mar 19, 2008 4:31 pm

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.

Post by **The Robman** » Wed Mar 19, 2008 6:32 pm

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).

Post by **ElizabethD** » Wed Mar 19, 2008 9:41 pm

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!

gloudemans · Post by **gloudemans** » Thu Mar 20, 2008 9:29 am

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.

Post by **vickyg2003** » Fri Mar 21, 2008 6:28 am

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.

Post by **The Robman** » Fri Mar 21, 2008 10:12 am

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.

mdavej · Post by **mdavej** » Fri Mar 21, 2008 1:51 pm

This may have never worked for all I know, but the printer-friendly view button doesn't work.

Post by **The Robman** » Fri Mar 21, 2008 7:45 pm

It is possible that that has never worked as I've never used it, it's a mod that Lucy added.

Post by **vickyg2003** » Fri Mar 21, 2008 9:09 pm

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.

pH7_jp1 · Post by **pH7_jp1** » Sat Mar 22, 2008 9:43 am

Post by **vickyg2003** » Sat Mar 22, 2008 10:07 am

speaker.guy · Post by **speaker.guy** » Sun Mar 23, 2008 2:58 am

I am on a cruise. Thought it was me!