Site Problems - Missing Users

New to maxcoderz forum? Go here first!

Moderator: MaxCoderz Staff

User avatar
benryves
Maxcoderz Staff
Posts: 3087
Joined: Thu 16 Dec, 2004 10:06 pm
Location: Croydon, England
Contact:

Site Problems - Missing Users

Post by benryves »

There have been a combination of strange problems with the hosting recently, so I apologise for any inconvenience from this issue.

I think I have sorted out the PHP issue, but one issue I cannot fix reliably are the missing entries on the user table.

The following users are still missing, with over a thousand posts between them.
I do not know if we have database backups; if we do we can restore those missing users as if nothing happened. In the meanwhile, if you are one of the affected users, I have created some temporary dummy accounts and linked them to the missing IDs to keep the forum vaguely working. If you wish to reclaim your account, please post in this thread and we'll see what we can do. :)

I have set up database backups to run daily personally to try and avoid such problems in future.

Many apologies. Please let us know if you spot any other problems.
Last edited by benryves on Wed 19 Dec, 2007 1:17 pm, edited 5 times in total.
User avatar
Timendus
Calc King
Posts: 1729
Joined: Sun 23 Jan, 2005 12:37 am
Location: Netherlands
Contact:

Post by Timendus »

Good to see you're on to it, Ben :)
http://clap.timendus.com/ - The Calculator Link Alternative Protocol
http://api.timendus.com/ - Make your life easier, leave the coding to the API
http://vera.timendus.com/ - The calc lover's OS
User avatar
benryves
Maxcoderz Staff
Posts: 3087
Joined: Thu 16 Dec, 2004 10:06 pm
Location: Croydon, England
Contact:

Post by benryves »

No worries. :) I think I've identified all but two of the missing users (big thanks to anyone who quoted one of their posts!). 797 is especially embarrassing as I've replied to their posts but can't for the life of me remember their name.
User avatar
kv83
Maxcoderz Staff
Posts: 2735
Joined: Wed 15 Dec, 2004 7:26 pm
Location: The Hague, Netherlands
Contact:

Post by kv83 »

So, what exactly happened. I recon you logged in with the admin details I sent you some time ago when I was on vacation?

I also got this letter, but don't know if you already saw that on revsoft;
Hi,

We have completed an upgrade to Apache 2.2 and FastCGI PHP. This should help performance and allow more flexibility, but one side effect is that some sites that use PHP need to be manually updated to work. If you're seeing a 403 error on your site, please do the following:

- Log into your control panel account (http://tengun.net/cp)

- In the list on the left, click on the site that's having problems.

- Next to "web service", click the edit icon (looks like a hammer).

- Near the top of the page, you should see some red text that says "changes need to be applied". Click the "apply" link next to this.

Once you've done that, it will take a few minutes to take effect, but your site should begin working again. If you have any other troubles, please reply to this email.

Thanks,

Tony Richards
Tengun Networks
Image
User avatar
benryves
Maxcoderz Staff
Posts: 3087
Joined: Thu 16 Dec, 2004 10:06 pm
Location: Croydon, England
Contact:

Post by benryves »

Erm, no, as I never visit RevSoft. :? I had to pester tr1p1ea for the cp credentials as well, having lost them when you sent them to me. :(

The first problem I had was that the site wasn't being resolved properly (I was getting the generic control panel page, as if you were going straight to the shared IP address rather than going via the correct domain). I added and removed a temporary domain, which seemed to fix that problem.

As for PHP, I was getting the 403 error. I noticed the requirement to apply changes, so I did. That didn't appear to do anything, so I tried switching PHP off then back on again, which also didn't work. I uploaded the following .htaccess file:

Code: Select all

AddType application/x-httpd-php .php
...which, bizarrely, seems to work.

As for the database issues, I've been searching for posts with poster_ids that don't exist on the users table, and manually adding replacement rows.
User avatar
kv83
Maxcoderz Staff
Posts: 2735
Joined: Wed 15 Dec, 2004 7:26 pm
Location: The Hague, Netherlands
Contact:

Post by kv83 »

Maybe it didn't work instantly, which resulted you trying the htaccess things which actually didn't do anything and instead of that helping it was the "apply changes"-thingie?
Image
User avatar
benryves
Maxcoderz Staff
Posts: 3087
Joined: Thu 16 Dec, 2004 10:06 pm
Location: Croydon, England
Contact:

Post by benryves »

I started testing by mapping .script to application/x-httpd-php, and a test.script I'd uploaded was working fine but test.php still wasn't.

I suspect you're correct though (it took a while to change), and the .htaccess file is no longer needed - so I've removed it. :)
dys
New Member
Posts: 1
Joined: Wed 19 Dec, 2007 4:10 am

Post by dys »

Hey Ben, I know I'm pretty inactive right now (I'm dysfunction, in case the truncated nick confuses anyone), but if you can get around to fixing my account it would be appreciated. I shall have need of it when I *ahem* have stuff to show in the somewhat near future.
User avatar
tr1p1ea
Maxcoderz Staff
Posts: 4141
Joined: Thu 16 Dec, 2004 10:06 pm
Location: I cant seem to get out of this cryogenic chamber!
Contact:

Post by tr1p1ea »

I have a database backup somewhere i think, im not sure how recent it is. Ill see if i can find it.
"My world is Black & White. But if I blink fast enough, I see it in Grayscale."
Image
Image
User avatar
Timendus
Calc King
Posts: 1729
Joined: Sun 23 Jan, 2005 12:37 am
Location: Netherlands
Contact:

Post by Timendus »

The front page is still broken. Which isn't really a problem, because it's boring anyway, but people coming in through www.maxcoderz.org will have a hard time figuring out it's just the front page ;)
http://clap.timendus.com/ - The Calculator Link Alternative Protocol
http://api.timendus.com/ - Make your life easier, leave the coding to the API
http://vera.timendus.com/ - The calc lover's OS
User avatar
benryves
Maxcoderz Staff
Posts: 3087
Joined: Thu 16 Dec, 2004 10:06 pm
Location: Croydon, England
Contact:

Post by benryves »

It does work here, just very slowly. It would appear that the database server is still running rather sluggishly.

tr1p1ea sent me an oldish backup, which I've used to restore some of the old user accounts. The three most recently created missing user accounts have not been backed up, and so will require manual editing.
User avatar
kv83
Maxcoderz Staff
Posts: 2735
Joined: Wed 15 Dec, 2004 7:26 pm
Location: The Hague, Netherlands
Contact:

Post by kv83 »

Hmm... the fp seems to work quite allright here. I might take a look at the database this weekend and see if I can optimize some things to let it work faster and clean up some things (like unused accounts)
Image
User avatar
kalan_vod
Calc King
Posts: 2932
Joined: Sat 18 Dec, 2004 6:46 am
Contact:

Post by kalan_vod »

Glad to see this being worked on, as it is appreciated! I am happy to belong to a community that is able and willing to help other out :P.
User avatar
DJ_O
Calc King
Posts: 2323
Joined: Mon 20 Dec, 2004 6:47 pm
Location: Quebec (Canada)
Contact:

Post by DJ_O »

post removed
Last edited by DJ_O on Fri 11 Jan, 2008 9:42 pm, edited 1 time in total.
ImageImageImageImage
Floodkiller
Sir Posts-A-Lot
Posts: 245
Joined: Mon 14 Nov, 2005 9:47 pm
Location: Getting overwhelmed by everything
Contact:

Post by Floodkiller »

Lol, I have been busy working on stuff so much I didn't even notice I lost my account here apparently. Great to see it was recovered, thanks ben!

Well, now everything from april 2007 on is red new again...also gotta get back all those points I was saving up for that DS item as well :(.
Main Projects:
Zombie Attack: 20%

Side Projects:
???-25%

Image

Staff member of Hikaru Rakuen Programming.
Post Reply